Re: MySQL database transfer to another server - how?
Hi
If you have command line access you can also compress the data before it hits the disk. Most mysql tables compress well, especially if you have a lot of strings in them.
eg
mysqldump --quick --opt -u user -ppass dbname | gzip > filepath.sql.gz
This also speeds up the process considerably
__________________
Peter Dunham
Webgains
|