Restore large mysql databases with nginx 504 Gateway Timeout
I had to restore a 36MB sql database today and kept getting a "504 Gateway Time-out".
After playing around with the config files, adding fastcgi_read_timeout to the settings for php5-fpm, and fiddling with the php.ini, I realized that this can be accomplished with one single line using ssh:
Assuming that you have packed the .sql file into a zip file, and you are currently in that folder:
# gunzip < databasebackup.sql.gz | mysql -DDATABASENAME -uUSERNAME -pPASSWORD
DATABASENAME = name of the database
USERNAME = mysql username
PASSWORD = mysql password
USERNAME = mysql username
PASSWORD = mysql password
I hope this helps when trying to restore large mysql databases with nginx 504 Gateway Timeout
2338
