mysql permissions

[s1nn0n]

Hi,

the sql folders in /var/lib/mysql have been restored from a system level backup, and all works fine.

Now, I want to copy a newer database from /old_drive/var/lib/mysql to /var/lib/mysql as the newer file exists on the old primary drive which I now have mounted.


But when i copy them over, sites just go white, all over the screen, that need the sql database.

Do you have any idea what could be causing this?

Thanks.

 

[smtalk]

If you want to set the right owner (as I see in the topic of the thread):

chown -R mysql:mysql /var/lib/mysql/[b]database_name[/b]

And it needs to have 660 chmod:

chmod 660 /var/lib/mysql/[b]database_name[/b]/*

 

[s1nn0n]

Thanks for the reply, but no thats still not fixed it. Still the same issue.

 

[DirectAdmin Support]

Hello,

1) Try testing the login/password being used manually, eg:

mysql -u[b]user_dbuser[/b] -p[b]password[/b] [b]user_dbname[/b]

2) You may also need to run:

REPAIR TABLE [b]tablename[/b]

from within mysql if there are any problems with the file.. if it's possibly for a different version of mysqld.
3) also check the error log in /var/lib/mysql/<hostname>.err
4) and the apache error log for the domain as well as /var/log/httpd/error_log for any errors.

John