Re: Migrate HUGE Database
- Date: Tue, 11 Mar 2008 10:05:34 +0000
- From: Richard Heyes <richardh@xxxxxxxxxxx>
- Subject: Re: Migrate HUGE Database
How very inconsistent and obnoxious.
But yet far more secure. FWIW, if you're transferring between machines
you can gzip the output of mysqldump to compress it, resulting in far
less transfer time.
Eg.
mysqldump -u username -p database_name | gzip -c > dump.sql.gz
IIRC
--
Richard Heyes
Employ me:
http://www.phpguru.org/cv
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx