A
A
Anton B2015-11-24 15:46:47
MySQL
Anton B, 2015-11-24 15:46:47

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 question

Ask a Question

731 491 924 answers to any question