I am switching VPS providers and I want to get my MySQL table data in one server over to another. I currently have a daily mysqldump of all the tables and the biggest tables have in excess of 10M rows and the dump file is approx 4-5GB in size. The import of this is taking many many hours and I am wondering if there is a faster way to do this - something that takes 10 or 15 mins rather than hours and hours. Thanks!
Edit: all my tables are InnoDB
--disable-keys
?-h
option from the first VPS will usually be slower. Copying the dump files across will usually go faster if you use a compression option (scp -C
orrsync -z
or you could just usegzip
before copying andgunzip
after.)