<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 15 (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:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></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-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>I have now done two 5208 to 5209 migrations in the last two weeks and am getting the hang of the issues.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>There are two main problems I have had that others might benefit from knowing about.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>One, If you use the Server Backup package from Solarspeed/Compass you should know that the MySQL backup/restore process at<o:p></o:p></p><p class=MsoNormal><a href="http://www.blueonyx.it/index.php?page=cmu-migrations">http://www.blueonyx.it/index.php?page=cmu-migrations</a> where you tar up the whole /home/mysql folder is much better than using the mysql dump file. Not only is it WAY faster for large database migrations but it just works much easier.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>There are however a couple of notes to make things even easier. It is very easy to tar and back-up the whole /home/mysql folder instead of (or in addition to) creating the regular MySQL dump file with the Server-Backup plugin. You can create scripts to run before and after the extra folders are tar’ed up. So, create a folder /home/solarspeed/solbackup/server_backup/plugins and then create a script called pretardirs.sh and posttardirs.sh<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>In pretardirs.sh put something like:<o:p></o:p></p><p class=MsoNormal>service mysql stop<o:p></o:p></p><p class=MsoNormal>sleep 10<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>in posttardirs.sh put:<o:p></o:p></p><p class=MsoNormal>service mysql start<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>chmod 755 both files and then add /home/mysql to the Server-Backup Extra Directories screen.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Michael, perhaps you could add this as an option to the Server-Backup package?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Also if moving from a 5208 to a 5209 with this process you will need to run the following after you untar your /home/mysql folder to the correct location to upgrade the database: mysql_upgrade –pyour-root-password<o:p></o:p></p><p class=MsoNormal>That will upgrade your databases to work with the much newer version of MariaDB on the 5209.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The second thing to watch out for is also something that perhaps Michael Stauber can fix. When you use CMU Import to restore your sites it does not correctly setup PHP, and the httpd service will refuse to start. You must go into each vsite and reset or choose new PHP Scripting in the Web Vsite settings. It appears that the PHP version for each vsite on the 5209 is a new needed datapoint and that new data field is imported blank so the web server won’t start. Once you go choose any setting for each site and save them in the GUI then the web server will start properly. Perhaps Michel you could change the way that code works so if that data is null the web server defaults to using the lowest available PHP version.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I hope this info saves some others time and troubleshooting effort.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Other than the few small issues I have had to figure out, I have been very happy with the move to the 5209. The ability to choose the PHP version for each Vsite is a really good addition.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks to everyone who contributes to BlueOnyx!<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>______________________________<br>M Aronoff Out – <a href="mailto:maronoff@gmail.com"><span style='color:blue'>maronoff@gmail.com</span></a> <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I'm a great believer in luck, and I find the harder I work the more I have of it.<br> - <a href="http://www.quotationspage.com/quote/31912.html"><span style='color:windowtext;text-decoration:none'>Thomas Jefferson</span></a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>