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