0

I want to make a copy of a MySQL database but preserve the information_schema.create_time for each of the tables. I haven't been able to find an option to do that with mysqldump.

Vietyank
  • 123
  • 2
  • 2
  • 7

1 Answers1

0

There's a response for this here: MySQL - mysqldump. preserve update_time and modify_time

As @RolandoMySQLDBA said:

There is no way to reload the INFORMATION_SCHEMA manually. All the tables are dynamic entities.

oNare
  • 3,231
  • 2
  • 22
  • 35