MySQL Forums :: Other Migration :: Migrating MySQL 5.0 to MySQL 5.5
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 :)
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 :)
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Migrating MySQL 5.0 to MySQL 5.5 | 867 | Khuram Raza | 03/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.
© 2013, Oracle Corporation and/or its affiliates