Re: Importing mySQL 5.0 database files into MySQL 5.5
Posted by: Rick James
Date: July 20, 2012 10:08PM

> - a backup (no exported sql or dump file) of the old MySQL 5.0 installation
First, we need to understand how you got the backup. It sounds like you have a copy of the disk files? Was mysqld stopped when you copied the files?

Plan A: (I do not know if it will work):
Install 5.5, but do not start.
Copy all the files _except_ the "mysql" directory (`mysql` database)
Start mysqld.

Plan B:
Get a copy of 5.0; install it.
Do mysqldump of everything but the `mysql` database.
Find out the logins you need to reconstruct. Do SHOW GRANTS... if necessary.
Remove 5.0 executables and data.
Install 5.5
mysql <dumpfile.sql

Options: ReplyQuote


Subject
Written By
Posted
Re: Importing mySQL 5.0 database files into MySQL 5.5
July 20, 2012 10:08PM


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.