MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: what is the right way to change a database to a new server which runs also a newer version of MySQL?
Posted by: Rick James
Date: April 20, 2014 10:37PM

> mysql_upgrade is available since MySQL 5.0.x. But do I really need it?

mysql_upgrade _mostly_ fixes changes to the `mysql` database. In a few cases it changes issues with other tables. (I don't have the details.)

> I take only one database, and the system tables are coming from each new installation. I only import this one database from a sql-file (dump-file).

Yes, that should be much more straight-forward. TYPE -> ENGINE is the main thing that might bight you. However, consider this: Use a newer mysqldump to dump the data from an older version; that will avoid the "ENGINE" hiccup, and possibly other issues. Possibly (but I am not sure), the 5.5 version can read the 4.0 data, maybe even the 3.x data.

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.