virtualmin restore-domain - set order to restore mysql databases

1 post / 0 new
#1 Tue, 09/29/2015 - 15:35
botzko

virtualmin restore-domain - set order to restore mysql databases

Hello there,

I'm trying to make virtual copy of my server. For this purpose I'm using this procedure https://virtualmin.com/documentation/system/migrate. My problem is that I must set the order databases must be restored. Reason for this is that I have 2 databases: DB1 and DB2. DB1 has tables that have foreign keys in DB2. So DB1 must be created after DB2 but restore procedure is trying to restore DB1 first and it produce an error (es expected). I read the help for this command and didn't found nothing related to this.

P.S. I know I can manually restore these databases first and after this to run the restore procedure. Or may be there is some way to reorder them in the produced archive.

Kind regards.