mysqldump  u  p  all databases gzip filename gz  by gzipping it while we are dumping we lower the requirement for the space required on the server side  our gig db compresses down to about megs right now 