[MySQL] MySQL Database setup recommendation for best results.

[Alexander]

Hello, there are two ways:
first is to increase max_execution_time and session.gc_maxlifetime settings in your php.ini file if you are going to perform such operations via phpMyAdmin in future;
second is to perform restoration via command line interface. To do it, you need to upload your archive via ftp or file manager, unzip it using the command

unzip <archive name>

and restore it

mysql dbname < dbdump.sql

Please, note, that these operations should be performed logged as root user.

[omarfilip]

you need to upload your archive via ftp or file manager

Forgive my ignorance, but where exactly should I upload the gzipped file?

[Alexander]

You can upload it in any folder on your VPS, logged as root user you can unzip it and restore without any problems. Please, note, that during the restoration the extracted dump must be in your current folder. Also, the db should exist.