[MySQL] MySQL Database setup recommendation for best results.

[omarfilip]

I'm trying to import a MySQL database that's 26MB gzipped or about 120MB unzipped. I ran an import of the gzipped version through phpMyAdmin, but it seems to have timed out somewhere at 20% of the file.

Any suggestions on how to accomplish the import?

Thanks,
Omar

[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.