In the case of MySQL ... command line will always be the most efficient—though not the most friendly way—to accomplish a database export/import. To start, SSH into the first server (using ...

However, if you have already created a database and want to export ... use MySQL's "mysqldump" function to create a file containing the commands necessary to recreate the tables. Open a DOS ...