I am trying to migrate my site to an AWS server to be used as a test/dev environment. And also to test a migration process. I am getting a 504 Gateway Timeout error during the restore of the Database tables. It gets to about ~ 80% or so. I do see some of the DB tables have been restored but not all of them.
I am restoring to an empty DB. Although it has a diffrent name than the live site. I copied both the snapshot installer file and full backup from the managed backups into the webroot directory, which is empty.
AWS server t2.micro (1 CPU with 1GB Ram)
Running: Ubuntu 16.04, PHP7, NGINX 1.10, MariaDB