Answer the question
In order to leave comments, you need to log in
Will restoring a single table work correctly when creating a dump with mysqlhotcopy?
Hello!
I have always created dumps with mysqldump. I have all MyISAM tables, I decided to look towards mysqlhotcopy.
I understand the difference between these two utilities:
mysqldump - creates instructions (queries) that allow you to restore data;
mysqlhotcopy - just copies data (files).
The logic of restoring tables from a mysqldump backup is clear (execution of instructions).
Question: when restoring one table from a mysqlhotcopy backup, is it enough to just copy the table files in the park with the database files? It's just that MySQL has additional tables information_schema, performance_schema, mysql and, for example, information_schema contains information about all tables, fields, table data. How will this data be updated after simply copying the files to the database folder?
Thank you!
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question