Brian Dunning wrote:
I have a bunch of databases - some are really big, 2GB - on a number of
different accounts at PowWeb. I am buying a Rackspace server and want to
move everything over -- hopefully all in one night. Can anyone suggest
the best way to do this? Would it be to use the Export command in
phpMyAdmin?
--MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
I'm not familiar with phpMyAdmin, but I would dump everything to sql
files, using the extended insert option then compressing the resulting
sql files. Then create a hash (MD5) and ftp the files over, checking the
hash on the remote system, uncompressing, and importing. I do something
like this with my backups (all automated, except for the checking of the
hash on the remote system, I just store the MD5 in an ascii file.)
--
Thanks,
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
