How to take SQL backup In GZIP format?

How to take SQL backup In GZIP format? I got SSH access aswell..

THanks!

Hi!

You just need your browser: use phpMyAdmin (control panel --> goodies --> mysql)!

In phpMy Admin:

- Login with the user for the DB you want to backup.
- Choose the DB from the menu on the left.
- Click on the Export-Tab
- On the bottom of the page, check "Save as file" and choose "gzipped"

Bye
EnPa

I guess you can do like this:

mysqldump -H<dbservername> -B<dbname> -u<username> -p<password> |gzip -c >example.sql.gz

Add whatever the option you would like to the mysqldump command.
Also, I think I've seen something explaining these in DH wiki.


.*.*.* I'd be happier if DH had free shared SSL and redundant server setup. *.*.*.
http://Hostwick.com/

PHPMYADMIN doesnt work for me, it gives error.

My SQL is Large, so it takes time to Backup, so when i use SSH command it waits for sometime then Dreamhost server kills the Command, and i only get half of my DB.

What other methods i could do to get my whole DB ?

Then you can possibly split the process, by backing up some tables separately.
You can do that by adding table name(s) in the mysqldump command.

Or you can try a script like this (I've never uesd and don't know how it works, though).
http://www.ozerov.de/bigdump.php



.*.*.* I'd be happier if DH had free shared SSL and redundant server setup. *.*.*.
http://Hostwick.com/