MySQLDump Restore dead slow
I need to do backups of 5 InnoDB databases (5.7 on Windows) and restore them on another server. When I use MySQLDump (or software such as Workbench or SQLBackupandFTP which use MySQLDump), the backup takes 25 minutes but the restore takes several days. This is not practical.
One of the tables involved has 70 million rows and takes up about 10GB. It has one primary key and four other columns (int,datetime,double,double) each one of which has a non-unique index.
I assume that it is the setting of these indexes after each insert that makes the restore so slow but I might be wrong. Maybe MySQLDump is the wrong approach altogether. Anyway this needs to be solved - ideally, the restore should take a few hours at most so I can automatize the backup/restore to run every day. Ideas anyone?
Subject
Views
Written By
Posted
MySQLDump Restore dead slow
1558
August 20, 2021 07:06AM
827
September 07, 2021 09:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.