Anyway to restore db's after a crash?!

ashagg

Verified User
Joined
Jul 7, 2005
Messages
11
Location
Delhi , INDIA.
Hi there..

My server recently crashed and I had to get a complete reinstall of the OS and DA on a new hdd.

The OLD hdd is mounted as /root/old

Is there a way I can reuse the DB's from the old setup ? The clients are complaining :(

Any help would be appriciated.

BTW, I tried copying /root/old/var/sql/* to the new one but then it gives me access not allowed for the db's..

PLEASE HELP!! :(

ashagg
 
The databases are all under /var/log/mysql on the server I'm looking at now.

They're in directories.

The directories are named the same as the databases. They're owned by mysql:mysql, and their permissions are 700.

The files inside each directory are also owned by mysql:mysql and the permissions are 660.

So if your permissions and ownerships don't match, change 'em :) .

Jeff
 
Back
Top