I'm hosting a 60GB
InnoDB file-per-table MySQL database with a VPS provider.
I want to generate a dump of the file. Running
mysqldump makes the website connected to this database extremely slow, resulting in recurrent timeouts during the period of the dump. The VPS provider offers a service of spontaneous disk cloning.
Is there a way to dump the database from the offline clone instead of the online live database? During that time I'll make the latter read-only to avoid any incoherences.
- The clone is simply a duplicate of the database disk.
- I have root access.