mysql disaster recovery?

I have recently had a hardware failure on my mysql server. i've got a new machine ready to take it's place, but i never had a chance to do a mysqldump of my data. i have access to all the hard drives from the old machine - how can i pull the mysql data off the old drives? where does mysql store databases by default in slackware?

i've tried to google search for this but all i get are guides about how to do a mysqldump - and ads for companies that do data recovery. i wasn't able to do a dump - what do i do now?

thanks in advance!
dbc

Originally Posted by dbc001 I have recently had a hardware failure on my mysql server. i've got a new machine ready to take it's place, but i never had a chance to do a mysqldump of my data. i have access to all the hard drives from the old machine - how can i pull the mysql data off the old drives? where does mysql store databases by default in slackware? i've tried to google search for this but all i get are guides about how to do a mysqldump - and ads for companies that do data recovery. i wasn't able to do a dump - what do i do now? thanks in advance! dbc

The directory "/var/lib/mysql" is where the data for the databases are stored for mysql, if I'm not mistaken.

ok... looks like it's kind of working. i moved all the files to the new server, and phpmyadmin lists all the databases and tables. but i get database errors when i try to use the data. for example, when I browse to the wordpress database and click the wp_posts table on the left side, I get this error:

Error SQL query: SHOW INDEX FROM `wp_posts` ; MySQL said: #1017 - Can't find file: './wordpress/wp_posts.frm' (errno: 13)

if i browse to /var/lib/mysql all the files seem to be there:

/var/lib/mysql# ls -al wordpress/ total 412 drwxr-xr-x 2 root root 4096 2006-09-24 13:21 ./ drwxr-x--- 10 mysql mysql 4096 2006-09-24 13:55 ../ -rw-rw---- 1 root root 65 2006-09-17 21:09 db.opt -rw-rw---- 1 root root 48 2006-09-17 21:15 wp_categories.MYD -rw-rw---- 1 root root 3072 2006-09-21 12:02 wp_categories.MYI -rw-rw---- 1 root root 8822 2006-09-17 21:11 wp_categories.frm -rw-rw---- 1 root root 224 2006-09-17 21:15 wp_comments.MYD -rw-rw---- 1 root root 4096 2006-09-18 11:20 wp_comments.MYI -rw-rw---- 1 root root 9295 2006-09-17 21:11 wp_comments.frm -rw-rw---- 1 root root 112 2006-09-17 21:18 wp_linkcategories.MYD -rw-rw---- 1 root root 2048 2006-09-21 12:02 wp_linkcategories.MYI -rw-rw---- 1 root root 9120 2006-09-17 21:11 wp_linkcategories.frm -rw-rw---- 1 root root 660 2006-09-17 21:20 wp_links.MYD -rw-rw---- 1 root root 4096 2006-09-21 12:02 wp_links.MYI -rw-rw---- 1 root root 9134 2006-09-17 21:11 wp_links.frm -rw-rw---- 1 root root 191804 2006-09-18 08:06 wp_options.MYD -rw-rw---- 1 root root 8192 2006-09-21 12:02 wp_options.MYI -rw-rw---- 1 root root 9063 2006-09-17 21:11 wp_options.frm -rw-rw---- 1 root root 50 2006-09-17 21:15 wp_post2cat.MYD -rw-rw---- 1 root root 3072 2006-09-19 13:34 wp_post2cat.MYI -rw-rw---- 1 root root 8644 2006-09-17 21:11 wp_post2cat.frm -rw-rw---- 1 root root 76 2006-09-17 21:15 wp_postmeta.MYD -rw-rw---- 1 root root 5120 2006-09-21 12:02 wp_postmeta.MYI -rw-rw---- 1 root root 8682 2006-09-17 21:11 wp_postmeta.frm -rw-rw---- 1 root root 776 2006-09-17 21:15 wp_posts.MYD -rw-rw---- 1 root root 3072 2006-09-21 12:02 wp_posts.MYI -rw-rw---- 1 root root 9729 2006-09-17 21:11 wp_posts.frm -rw-rw---- 1 root root 764 2006-09-17 21:14 wp_usermeta.MYD -rw-rw---- 1 root root 5120 2006-09-21 12:02 wp_usermeta.MYI -rw-rw---- 1 root root 8684 2006-09-17 21:11 wp_usermeta.frm -rw-rw---- 1 root root 220 2006-09-17 21:14 wp_users.MYD -rw-rw---- 1 root root 3072 2006-09-21 12:02 wp_users.MYI -rw-rw---- 1 root root 8968 2006-09-17 21:11 wp_users.frm

am i missing something?

dbc

a little more progress - if I go to /var/lib/mysql and do chown -R mysql wordpress/ that lets phpmyadmin access the database, but wordpress still can't get to it...

I had a similar issue to this once, but I don't use Slackware packages for MySQL so my data was in a different place.

After I had copied all the MySQL data to the new machine, I got errors until I re-chmod'd and chgrp'd the data directory's contents to the correct owner. Right now it seems that only root can read/write those wp_* files, so that might be the problem.

Still no luck:

/var/lib/mysql# chmod -R 660 wordpress/ /var/lib/mysql# chown -R mysql wordpress/ /var/lib/mysql# chgrp -R mysql wordpress/

I still get errors trying to access my databases, except from phpmyadmin. there must be another step that i'm missing...

At this point I think my problem is more MySQL than it is slackware. I've posted my remaining problem here: http://www.linuxquestions.org/questi....php?p=2436225

cheers,
dbc

ps thanks for your help Voltar & Aeiri!