MySQL Forums
Forum List  »  Other Migration

Migrating MySQL 5.0 to MySQL 5.5
Posted by: Khuram Raza
Date: March 20, 2012 12:27PM

Greetings All,

can anyone guide me on how to migrate MySQL 5.0 to a new server running MySQL 5.5??

my server is running more than 95 databases, i need to migrate users along with it as they are also 200+ in number.

if i want to use MySQLDump, i can use this command

mysqldump -u root -pPassword -x --all-databases > db_dullll.sql
mysql -u root -pPassword < db_dullll.sql

but this is not working as databases get transfer users don't.

thanks in advance :)

Options: ReplyQuote

Written By
Migrating MySQL 5.0 to MySQL 5.5
March 20, 2012 12:27PM

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.