0
votes
0answers
195 views

Mysql won't start after replacing data in datadir.

so I have a little problem. I had errors with our old system and was unable to backup the old databases properly so I went ahead and backed up the datadir which had all of the databases folders inside ...
1
vote
1answer
336 views

MySQL ZRM restore failed with mysql error unknown command \0

I am restoring an incremental backup with ZRM server on mysql database. I am having blob data in the tables. The incremental backup not getting restored and giving mysql error unknown command '\0'. ...
3
votes
2answers
6k views

Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> doesn't exist (1146)”

Backstory Ubuntu died (wouldn't boot) and I couldn't fix it. I booted a live cd to recover the important stuff and saved it to my NAS. One of the things I backed up was /var/lib/mysql. Reinstalled ...
0
votes
1answer
107 views

selectively import “record sets” from one mysql instance to another

I have a mysql server hosting a production database, and routinely I make snapshots of it, which we can also use as a staging environment. Sometime bad things happen, e.g. we delete a row (and all ...
1
vote
2answers
1k views

Error code 1005 (errno: 121) upon create table while restoring MySQL database from a dump

I have a linux prod machine and a Win7 64bit dev machine. My workflow includes dumping the production MySQL database on the linux machine and restoring it in my local MySQL database on the windows ...