You need to login to send post. No account yet? Create one:
Create account

How to backup big MySQL database

No replies
admin

Web designer's life is full of small surprises. Yo can - e.g. - find out that your MySQL database from last time you've seen it did overgrow ability of PhpMyAdmin to backup (download) it.

In that momen is only solution use MySQL command "mysqldump" direct. Luckilly it is easy:

~# mysqldump -u username -p password database_name
 | gzip -9 > database_name.sql.gz