MySQL Data Dumper

MyISAM tables

Asked by Gustavo Tonello

Hi guys,

I tried search some answer for my case, but I can't find.

I'm using mydumper to generate my backup.
One of my databases, have a MyISAM table, and when I restore this backup, I can't find this table.

Have a limitation in mydumper to backup MyISAM tables?
I create my backup only using --build-empty-files and --compress options.

Thanks.
Regards,

Question information

Language:
English Edit question
Status:
Solved
For:
MySQL Data Dumper Edit question
Assignee:
No assignee Edit question
Solved by:
Gustavo Tonello
Solved:
Last query:
Last reply:
Revision history for this message
Max Bubenick (max-bubenick) said : 		#1

Hi Gustavo, there is not limitation with myisam tables, are you sure that table was there when you took the backup?

Can you show me the mydumper command you ran and the method to restore that backup?
Is the file db.your_mysiam_table-schema.sql for that table in the output dir?

Revision history for this message
Gustavo Tonello (gustavo-tonello-l) said : 		#2

Hi Max,

Yes, you're right.
Mydumper works fine here. I don't know why but I checked backup again, and schema and data files of this table are in backup.
I restore backup again, and table was imported without problem.

Any way, thank you for the answer and sorry for the inconvenience.

Regards,