MySQL Forums :: Backup :: Backup MySQL Server 5.1.45


Advanced Search

Re: Backup without much disk space
Posted by: Rick James ()
Date: September 19, 2010 08:56AM

If you are doing a mysqldump and don't have enough disk space for the output, what are the alternatives?

* If you have some space, but not enough, compress on the fly:
mysqldump ... | gzip >dump.gz
(This may not work well on Windows.)

* Pull the output from another machine:
host2$ mysqldump -h host1 ... >dump.sql
This may require granting access explicitly for host2.

Options: ReplyQuote


Subject Views Written By Posted
Backup MySQL Server 5.1.45 4092 Anandhan S 09/09/2010 09:11AM
Re: Backup MySQL Server 5.1.45 1577 Rick James 09/12/2010 12:49PM
Re: Backup MySQL Server 5.1.45 1334 Anandhan S 09/18/2010 07:48AM
Re: Backup without much disk space 1854 Rick James 09/19/2010 08:56AM
Re: Backup without much disk space 1425 Anandhan S 09/19/2010 09:01AM
Re: Backup MySQL Server 5.1.45 2074 Jack Brassard 09/17/2010 04:14PM
Re: Backup MySQL Server 5.1.45 1228 Anandhan S 09/18/2010 07:42AM
Re: Backup MySQL Server 5.1.45 3510 Anandhan S 09/19/2010 09:04AM
Re: Backup MySQL Server 5.1.45 1364 Rick James 09/19/2010 10:07PM
Re: Backup MySQL Server 5.1.45 1372 Anandhan S 09/20/2010 05:18AM
Re: Backup MySQL Server 5.1.45 1302 Rick James 09/20/2010 10:51AM
Re: Backup MySQL Server 5.1.45 1367 Anandhan S 09/20/2010 09:01PM
Re: Backup MySQL Server 5.1.45 1425 Rick James 09/21/2010 12:03AM
Re: Backup MySQL Server 5.1.45 1434 Anandhan S 09/21/2010 04:43AM
Re: Backup MySQL Server 5.1.45 1349 Rick James 09/21/2010 03:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.