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

RollandNon

New Member
Joined
Mar 26, 2024
Messages
9
Изготовление стильных фотокниг недорого. Быстрая и качественная печать фотобуков на заказ. Создавайте фотоальбомы онлайн с помощью простого и бесплатного фоторедактора фотокнига новорожденного
 
Top Bottom