MySQL Forums
Forum List  »  Backup

MySQLDump Restore dead slow
Posted by: Michael Peters
Date: August 20, 2021 07:06AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQLDump Restore dead slow
257
August 20, 2021 07:06AM
159
September 07, 2021 09:15AM


Sorry, only registered users may post in this forum.

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.