Migrate all mysql databases

[Anon]

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 database" in the mysql shell, the error message is prompt out,

Cannot read dir of './database/' "Errcode:13"
Databasebase changes.

Please give me advice, since there are a lot of database in my Linux server, thanks.

Sincerely yours,
Simon

[phpjuggler]

hi,
you have to change the access right for the database files. This error means:
<b>Error code 13: Permission denied</b>

Greetings
juggler

[Anon]

Dear Phpjuggler,

How do I change the authority of these databases, since there are hundred of databases in my mysql server, thanks in advance for your assistance

Simon

phpjuggler wrote:

hi,
you have to change the access right for the database files. This error means:
<b>Error code 13: Permission denied</b>

Greetings
juggler

[[deleted]]

Not autority of databases, the data files.

When you copied the datafiles, you change the file permissions so that mysql can nolonger read/write the files.

Change the filepermissions of the datafiles.

[Anon]

Dear Vincent,

I have found all the users' privilege in the mysql table, then how to change the authority of every databases in detail?
Thanks a lot

Sincerely yours,
Simon

vincent wrote:

Not autority of databases, the data files.

When you copied the datafiles, you change the file permissions so that mysql can nolonger read/write the files.

Change the filepermissions of the datafiles.

[[deleted]]

I'll repeat myself: this has NOTHING to do with the contents of the datafiles AT ALL.

It is a simple matter of changing the file permissions so that mysql can read the files.

read about chmod and chown and read the mysql manual about it.