How to take SQL backup In GZIP format?


#1

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

THanks!


#2

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


#3

I guess you can do like this:

mysqldump -H -B -u -p |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/


#4

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 ?


#5

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/