cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL Database upgrade in magento

MySQL Database upgrade in magento

I need to upgrade the database version in magento CE 1.9. Please let me know the changes affects in magento configuration and the steps we need to follow. Its very urgent.

 

Thanks in advance

3 REPLIES

Re: MySQL Database upgrade in magento

Do you mean that you are upgrading the MySQL version? 

 

What version are you currently on and what version are you upgrading to? 

James Lee | Moderator • Magento Master
See My Recommended Magento Hosting & Security Tips

Re: MySQL Database upgrade in magento

I would like to upgrade the database version from mysql4  to mysql5 and my magento store is hosted in godaddy server. Please suggest the upgrade steps.


JLHC wrote:

Do you mean that you are upgrading the MySQL version? 

 

What version are you currently on and what version are you upgrading to? 


 

Re: MySQL Database upgrade in magento

Do you control the server with root access or are you just on shared hosting? 

 

Upgrading from MySQL 4 to the current latest MySQL is quite tedious with a few steps involved. You will first need to upgrade to MySQL 5.0 and from there to the current version.

 

If you can afford a little bit of downtime, the easier way is to take a MySQL backup with mysqldump, remove MySQL 4, install the latest MySQL 5.6 or 5.7 and then restore your MySQL backup. 

James Lee | Moderator • Magento Master
See My Recommended Magento Hosting & Security Tips