I took the backup of mysql database using mydumper command:

mydumper -B mydb -o /backup/oct3 -s 500000 -c -m -S /tmp/mysql.sock -u root -p password@123 -v 3

Now, I am restoring mysql database backup with the myloader command:

myloader -d /backup/oct3 -S /tmp/mysql.sock -u root -p password@123 -v 3


CRITICAL **: Error restoring mydb.tabe1 from file mydb.table1.sql.gz: Table 'mydb.table1' doesn't exist ** Message: Thread 2 shutting down

I believe the table should be created while restoring the database.

But I could not figure out what I missed. The mydumper version is 0.6.2.

My.cnf file:

innodb_buffer_pool_size = 2308M
innodb_data_home_dir = /database
innodb_data_file_path = ibdata1:1G;ibdata2:1G;
innodb_log_files_in_group = 3
innodb_file_per_table = 0

The dumped .gz files are from MySQL 5.5 and I am restoring to MySQL 5.6.

Does it matter of version incompatibility?

Any suggestions will be appreciated. Thanks.

1 Answer 1


problem is you backed up your databases using mydumper with -m or --no-schemas option, so the database create commands were not backed up.

So on restore you are not able to re-create the database tables prior to myloader reimporting data.

  • Thanks p4guru. I took schema backup with following command and loaded schema before backup with myloader. # mysqldump -u root -p --no-data dbname > /backup/rcmwf.schema.sql Commented Oct 27, 2014 at 5:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.