Portal Home > Knowledgebase > Articles Database > Easy to upgrade from MySQL 4.1 to MySQL 5?
Easy to upgrade from MySQL 4.1 to MySQL 5?
| Posted by pythonrocks, 06-13-2007, 11:37 AM |
| I have a number of web sites on a dedicated server. Some of these web sites are a few years old. Are there any issues upgrading from MySQL 4.1 to 5.x? Are there web sites that may have compatibility issues? Please let me know
Thanks.
|
| Posted by 2dayhost, 06-13-2007, 12:16 PM |
| I suggest you to get MySQL 5 with MySQL 4 together.
Therefore you will be able to switch and test each website one after another
|
| Posted by pythonrocks, 06-13-2007, 01:01 PM |
| Problem is that you can't have both on the same server (at least not easily).
|
| Posted by 2dayhost, 06-13-2007, 01:05 PM |
| Do you have Linux server?
Try to read the following article: http://www.howtoforge.com/mysql5_debian_sarge
|
| Posted by whmcsguru, 06-13-2007, 01:50 PM |
| Running 4 and 5 puts unnecessary load on your server.
I have had zero problems upgrading DB's from 4 to 5 at all, no issues , no compatability problems, nothing of the like.
What you SHOULD do is run a FULL sql backup (with complete drop tables, inserts, etc) BEFORE you upgrade, this way you can always go right back to the prior version if necessary.
|
| Posted by mooodi, 06-13-2007, 02:50 PM |
| In windows machine it is very easy to run more than 1 mysql version. All you would need to install it with different Service name and port.
|
| Posted by wKkaY, 06-14-2007, 09:55 AM |
| Table issues aside, there are application gotchas when upgrading MySQL 4 -> 5, as detailed in this page: http://dev.mysql.com/doc/refman/5.0/...-from-4-1.html . I've seen Invision Board and Cacti breaking due to the change in JOINs.
If the number of websites you run are small, you can run through the Changelogs of the latest versions and see if they have any MySQL compatibility fixes since your installed version.
|
Add to Favourites 
Print this Article
Also Read
