<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1200432328;
mso-list-type:hybrid;
mso-list-template-ids:-1306608414 201916431 201916441 201916443 201916431 201916441 201916443 201916431 201916441 201916443;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l1
{mso-list-id:1386836693;
mso-list-type:hybrid;
mso-list-template-ids:1382843442 201916431 201916441 201916443 201916431 201916441 201916443 201916431 201916441 201916443;}
@list l1:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:18.0pt;
text-indent:-18.0pt;}
@list l2
{mso-list-id:1901554850;
mso-list-type:hybrid;
mso-list-template-ids:-1596004248 201916431 201916441 201916443 201916431 201916441 201916443 201916431 201916441 201916443;}
@list l2:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-AU link=blue vlink=purple>
<div class=Section1>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Database
files from an older version of MySQL can sometimes introduce problems when
copied straight into a new version of MySQL. For this reason it's advisable to dump
the database from the old server and import it to the new server. <o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>If
you have access to PHPMyAdmin on both servers, this is how to do it: <o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:
l0 level1 lfo1'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>1.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>On the old
server, select your database from the drop down list on the left. Once it's
loaded, click the "Export" tab. <o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:
l0 level1 lfo1'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>2.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Make sure all
the tables in the multi-select field are selected. Chose the “SQL”
option from the export list, and ensure the following checkboxes are checked:<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:72.0pt;text-indent:-18.0pt;mso-list:
l0 level2 lfo1'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>a.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Structure<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:72.0pt;text-indent:-18.0pt;mso-list:
l0 level2 lfo1'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>b.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Add DROP TABLE
/ DROP VIEW<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:72.0pt;text-indent:-18.0pt;mso-list:
l0 level2 lfo1'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>c.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Add
AUTO_INCREMENT value<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:72.0pt;text-indent:-18.0pt;mso-list:
l0 level2 lfo1'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>d.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Enclose table
and field names with backquotes<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:72.0pt;text-indent:-18.0pt;mso-list:
l0 level2 lfo1'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>e.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Data<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:72.0pt;text-indent:-18.0pt;mso-list:
l0 level2 lfo1'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>f.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Complete
inserts<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:72.0pt;text-indent:-18.0pt;mso-list:
l0 level2 lfo1'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>g.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Extended
inserts<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:72.0pt;text-indent:-18.0pt;mso-list:
l0 level2 lfo1'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>h.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Use
hexadecimal for binary fields<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:72.0pt;text-indent:-18.0pt;mso-list:
l0 level2 lfo1'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>i.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Save as file<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:10.0pt;
font-family:"Trebuchet MS","sans-serif"'>Also ensure that the export type is
set to “INSERT”<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:
l0 level1 lfo1'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>3.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Set compression
to “zipped”<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:
l0 level1 lfo1'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>4.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Press “Go”<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:
l0 level1 lfo1'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>5.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>That will (eventually)
present you with a download file dialogue box. Save the file to your computer –
you’ve now got a local backup of your database. <o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:10.0pt;
font-family:"Trebuchet MS","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:10.0pt;
font-family:"Trebuchet MS","sans-serif"'>On the new server…<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:10.0pt;
font-family:"Trebuchet MS","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:
l2 level1 lfo3'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>1.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Select the
database from the drop down list on the left, and click the Import tab<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:
l2 level1 lfo3'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>2.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Click the
browse button, and select your newly downloaded database dump, and press Go<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:
l2 level1 lfo3'><![if !supportLists]><span style='font-size:10.0pt;font-family:
"Trebuchet MS","sans-serif"'><span style='mso-list:Ignore'>3.<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Done!<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>If
both servers are running Linux and you have shell access, it’s far
simpler. Issue the following commands on the new server (you’ll have to
have a MySQL account that has remote access enabled):<o:p></o:p></span></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>mysqldump –u [username] –p [database name] –h
[ip address of your old server] > dump.sql<o:p></o:p></p>
<p class=MsoPlainText>mysql –u [username] –p [database name] <
dump.sql<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif"'>Example:<o:p></o:p></span></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>mysqldump –u moodleuser –p moodle –h
192.168.0.50 > dump.sql<o:p></o:p></p>
<p class=MsoPlainText>mysql –u moodleuser –p moodle < dump.sql<o:p></o:p></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span
style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";color:#2C2C2C'><o:p> </o:p></span></b></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span
style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";color:#2C2C2C'>Michael
Greenhill</span></b><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#2C2C2C'><br>
</span><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:gray'>IT Technician<br>
Wheelers Hill Secondary College<br>
+61 03 9561 5811</span><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif"'><o:p></o:p></span></p>
</div>
<p class=MsoPlainText><span lang=EN-US>-----Original Message-----<br>
From: moodle-bounces@edulists.com.au [mailto:moodle-bounces@edulists.com.au] On
Behalf Of Chris Ellis<br>
Sent: Monday, 8 September 2008 11:09 AM<br>
To: The Moodle Users' in Schools Mailing List<br>
Subject: Re: [Moodle] Migrating established Moodle to new server</span><o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>If you have full access to the server I'd make a copy of
the <o:p></o:p></p>
<p class=MsoPlainText>Moodledata and mySql folders.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Take moodle off-line. Rename the Moodle folder to
something like <o:p></o:p></p>
<p class=MsoPlainText>MoodlePreUpgrade so you have a copy of everything such as
style <o:p></o:p></p>
<p class=MsoPlainText>sheets, config files, additional modules, etc.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Upload and extract your latest Moodle install into your
web server <o:p></o:p></p>
<p class=MsoPlainText>folder and rename the extracted folder back to Moodle.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Copy across config files etc from the MoodlePreUpgrade
folder.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Browse to myusualmoodleURL/admin and the update script
should run. <o:p></o:p></p>
<p class=MsoPlainText>Your database files will be where they should be without
having to <o:p></o:p></p>
<p class=MsoPlainText>bother with backup and restore SQL dumps (and you also
have a copy of <o:p></o:p></p>
<p class=MsoPlainText>the MySQL folder for safety)<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Put Moodle back on line.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>This is how I've dealt with the last couple of updates
and works the <o:p></o:p></p>
<p class=MsoPlainText>best and simplest.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>If it all falls over, delete the new install moodle and
rename your <o:p></o:p></p>
<p class=MsoPlainText>preupgradefolder back to Moodle and you'll be back where
you started.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Cheers<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Chris Ellis<o:p></o:p></p>
<p class=MsoPlainText>ICT Coordinator<o:p></o:p></p>
<p class=MsoPlainText>Lorne-Aireys INlet P-12 College<o:p></o:p></p>
<p class=MsoPlainText>ellis.christopher.l@edumail.vic.gov.au<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Important - This email and any attachments may be
confidential. If received in error, please contact us and delete all copies.
Before opening or using attachments check them for viruses and defects.
Regardless of any loss, damage or consequence, whether caused by the negligence
of the sender or not, resulting directly or indirectly from the use of any
attached files our liability is limited to resupplying any affected
attachments. Any representations or opinions expressed are those of the
individual sender, and not necessarily those of the Department of Education and
Early Childhood Development.<o:p></o:p></p>
<p class=MsoPlainText>_______________________________________________<o:p></o:p></p>
<p class=MsoPlainText>http://www.edulists.com.au - FAQ, resources, subscribe,
unsubscribe<o:p></o:p></p>
<p class=MsoPlainText>Moodle Mailing List kindly supported by<o:p></o:p></p>
<p class=MsoPlainText>http://www.vcaa.vic.edu.au - Victorian Curriculum and
Assessment Authority and<o:p></o:p></p>
<p class=MsoPlainText>http://www.vitta.org.au - VITTA Victorian
Information Technology Teachers Association Inc<o:p></o:p></p>
</div>
<br>
--<br>
<br>
-- <br>
Important Notice:<br>
This email is for the named recipient only. Its contents are confidential.<br>
If you are not the authorised recipient you must not use, disclose or copy any <br>
of these contents.<br>
If you receive this email in error please contact us immediately and delete the <br>
email from your system. Representations or opinions expressed are those of the <br>
sender & not necessarily those of Wheelers Hill SC.<br>
</body>
</html>