How to Dump/Backup large database if phpmyadmin fail to download the gzip compressed file

[Administrator]

This error may cause to some webmasters, if they have a very large database and with very limited server configuration and php limitations.

if you own a vps or have access to SSH of the server, try this command on your UBUNTU running machine.

mysqldump -u [username] -p [database-you-want-to-dump] | gzip > dumpfilename.sql.gz

[username] - Enter your database username

[database-you-want-to-dump] - Database name

dumpfilename.sql.gz - Use any file name to dump the file, but do not change the .sql.gz extension.

Any doubt our help, just comment below, will do the need.