Support

First, let me correct you. It's the restoration, not the dump, which hangs. Dump is when you take the data from a database to a file. Restoration is when you take the data from a file to a database. Since you're talking about site restoration, it's database restoration.

I can think of a few reasons why it hangs:
- The PHP timeout is set very low, causing the restoration to hang
- The MySQL packet limit is set very low. However you'd get an error, not just a hang
- There is a query limit per hour set up on the MySQL server. That's a little crazy to do on a homebrew server and it should result to an error.
- The connection between the browser and the server is flakey, causing the process to hang indefinitely waiting for an acknowledgment from the server which never comes.
- The server has a very slow disk (e.g. consumer-grade SATA). After you restore a bunch of data to the MySQL server it will try to dump its data cache to disk. On slow disks this may take a substantial amount of time, triggering a timeout error or causing the server to return no data. If PHP is running as CGI or FastCGI the latter issue is very common when the execution takes too long.

The only workaround is using the manual method described in our documentation as the last resort for restoring your backups.

You're welcome!