Migrate all mysql databases?

[Simon Lee]

Dear all,

Owing to new linux server (Redhat 7.1) installation, we want to migrate all the mysql databases from the old server to the new one. We only copy all MYD, MYI, and frm files to the folder
/var/lib/mysql/databasename/.
Then I test the databases validity.

When enter "use databasename" in the mysql shell, the error message is prompt out,

Cannot read dir of './databasename/' "Errcode:13"
Database changes.

This show database have no authority.
Since there are a lot of database in my Linux server, please give an effective way to change the authority of each database, thanks.

Sincerely yours,
Simon

[Stuka]

You can actually dump the contents of the MySQL db into a file (of SQL statements), then use that file to recreate the db on the new server. This SHOULD give you the exact same db arrangement you had...

[chikn]

MySQL Dump (http://www.mysql.com/doc/m/y/mysqldump.html) Not being a smarty but RTFM.

[TheBouleOfFools]

Well he said there were alot and dumping all of them could get real boring real fast. Also, if everyone were to "RTFM" then this board would have no purpose.

[chikn]

Originally posted by TheBouleOfFools:
<STRONG>Well he said there were alot and dumping all of them could get real boring real fast. Also, if everyone were to "RTFM" then this board would have no purpose.</STRONG>

The right ways always better than the easiest way.

I think this board is here to help them willing to help themselves...if not my bad then.