Moving Servers, Different Version Of Mysql

Am i going to run into problems with moving servers when the current servers version of mysql is 3.23.49 and the new servers version of mysql is 5.0...

Will i run into problems when importing the DB from the 3,23 version to the 5.0 version

 

yes, there are some HUGE changes, you should test it on the new version prior to moving it.

It's quite possible you will need to restructure the database in this case. Even moving from 4.x to 5.x is a big change.

It's also quite possible that you won't run into any problems at all. We use complex database structures and we had to convert our db when upgrading versions. You might experience same or different results. Just test it out locally first.

 

How would i go about restructureing?

 

http://dev.mysql.com/doc/refman/5.0/en/news-5-0-x.html

Read up on that, that's the 5.x changelog.

 

Im not that familiar with Mysql as it is so i dont really understand much at that link.

 

You should try just testing it on MySQL 5.x to see if it works and if it doesn't, you should hire someone to convert it.

 

For those of you in the same situation as i was or are just even interested this worked fine without any problems.

 

Glad it worked

Others won't always have the same results, but I'm glad you had good results.

 

Wasnt good to start with, the Invision Power Board backup tool doubled the DB into one file so it was mentioning duplicate entries and messed up. Found a nifty little tool called AutoMysqlBackup, i backed the DB up from the Linux CLI using AutoMysqlBackup which made the .sql file outputted smaller 149Mb compared to 251Mb using the IPB backup tool. Worked second time around

 

fsmedia, can I ask how you did the conversion, any tools. I recently ran a massive server update due to some servers crashing and didn't have time to check mysql version before hand.

Anyways, now I have a about 1 too many hosting accounts to tie me over until I have time to do the db conversion.