what precautions needed before upgrading MySQL on server?
Permalink
Hi, Newbie to concrete5 and mySQL here...
I logged into my server recently and it had a notice complaining that my current version of MySQL is 5.0 and should be upgraded to 5.5. It appears that Cpanel can lead me through this upgrade process.
Does concrete5 install its own MySQL for itself, running alongside my server's? Or does it simply use whatever MySQL is installed on the server (my server is linux based on LAMP stack)? I'm assuming the latter...
Beside backing up my site, are there any special precautions I should be aware of regarding upgrading MySQL on my server and concrete5? For example, any tasks that I should complete before upgrading, etc.?
I logged into my server recently and it had a notice complaining that my current version of MySQL is 5.0 and should be upgraded to 5.5. It appears that Cpanel can lead me through this upgrade process.
Does concrete5 install its own MySQL for itself, running alongside my server's? Or does it simply use whatever MySQL is installed on the server (my server is linux based on LAMP stack)? I'm assuming the latter...
Beside backing up my site, are there any special precautions I should be aware of regarding upgrading MySQL on my server and concrete5? For example, any tasks that I should complete before upgrading, etc.?
I ran into permalink issues with Godaddy - you can search the forums here for the specifics. Knowing that, I would think that you could have host-specific issues.
Concrete5 is just a PHP application, so it uses whatever MySQL server your hosting account provides.
There shouldn't be any incompatibilities between 5.0 and 5.5 that would affect Concrete5. It runs just fine on both versions. There's a MySQL upgrade script that has to be run to convert the data after installing 5.5, but I assume cPanel will do that for you.
I would definitely make a backup of the C5 database before upgrading, just in case, but I would expect this to be pretty seamless.
There shouldn't be any incompatibilities between 5.0 and 5.5 that would affect Concrete5. It runs just fine on both versions. There's a MySQL upgrade script that has to be run to convert the data after installing 5.5, but I assume cPanel will do that for you.
I would definitely make a backup of the C5 database before upgrading, just in case, but I would expect this to be pretty seamless.
Thanks, I upgraded to MySQL 5.6 and it seems to have worked fine.
