Quickest way to transfer data from MySQL DB 1 to MySQl DB 2 -

I have a new database, similar to the old one, but with more columns and tables. So the old table's data is still usable and it needs to be moved.

The old database is on a different one on a different server. I want to transfer data from one database to another.

I have naval, but it takes forever to transfer the data to the host. Even after downloading a SQL file that takes too much time (also it inserts 4 seconds per second).

The downloaded SQL file is approximately 40 MB (with complete insert statement) Finally, maybe 60 MB to 80 MB

What is the best way to move this data? (A process I will need to repeat for some time).

"post-text" itemprop = "text">

Make a mysqldump on the source machine and Then slurping it on the other side, a 40-100MB file is well within reason but also make it from the command line.

  (source machine) mysqldump -u user -p password database & gt; Database sql  

.. Transfer file to recipient machine ...

  (recipient machine) mysql -u user -p password database & lt; Database.sql