Restoring MySQL databases from file system back up

Question

I've had a hard drive crash on me and unfortunately I do not have .sql dumps available to restore my databases. Though I do have a very recent back up of my entire file system.

I've grabbed the files from /usr/local/var/mysql/ from my back up and placed it in my fresh reinstall at the same location.

I can see all my databases when I use show databases; via the command line. I can also select a database using use <database>;. However, when I try to access any table on the database I see: ERROR 1146 (42S02): Table 'database.table' doesn't exist.

Thankfully it's only happening for a few less important databases but ideally I'd like to restore them fully.

Thanks

score 0 · Answer 1 · edited Mar 20 '17 at 10:18

0

did you restarted mysql daemon after overwrite? Also check this thread: https://superuser.com/questions/165575/import-or-restore-mysql-databases-from-var-directory

edited Mar 20 '17 at 10:18

Community

1
1

answered Jan 05 '13 at 04:42

Vahid Farahmand

2,528
2
14
20

I did stop mysql before switching out the files – Allan Thomas Jan 05 '13 at 04:57
did you check suggestions on given URL? – Vahid Farahmand Jan 05 '13 at 05:04

score 0 · Answer 2 · edited May 23 '17 at 12:25

0

It's not clear from your description if you've copied all your files from /usr/local/var/mysql/ . You will need different sets of files depending on whether the tables in your databases were MyISAM or InnoDB storage engines. Please check out this comment: Restoring MySQL database from physical files

edited May 23 '17 at 12:25

Community

1
1

answered Jun 02 '14 at 23:03

Marcus Barnes

11
2

Restoring MySQL databases from file system back up

2 Answers2