Welcome!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!

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

Administrator

Administrator
Joined
May 18, 2016
Messages
83
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.
 
Top Bottom