import database dump of a big size? PhpMyAdmin fails with Gateway Timeout 504 error

504 error in PhpMyAdmin means that php interpreter exceeds script execution time limit (limited for security reasons).

If you have SSH access provided by your hosting plan, follow these instructions:

– if database dums was compressed (zip, gz, tar.gz, bz2), uncompress it (should be with .sql extension). You may do that with any favorite archive manager or trough console, for example with command “unzip dump.zip” for zip achived dump.

– paste dump.sql file in any place you can easy to remember.

– execute command:

mysql -uUSERNAME -pPASS -f DATABASE < /path/dump.sql

Where “USERNAME” – login and PASS – password of new database user where dump is will be imported. 

“/path/dump.sql” – absolute or relative path to uncompressed dump file.

Was this helpful?

0 / 0