MySQL Database upgrade in magento

[jagsout]

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

[JLHC]

Do you mean that you are upgrading the MySQL version? 

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

[jagsout]

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? 

---

[JLHC]

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.