Which is the fastest way to transfer mysql databases from xampp on Windows to a MySql server on Ubuntu?
closed as off-topic by Tom O'Connor♦ Aug 14 at 21:27
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions must be relevant to professional system administration. Server Fault is a site dedicated to professionals; novice questions are off-topic. Please see the Help Center for more information on topicality. The best advice we can give you is to hire a professional to help you out." – Tom O'Connor
Xampp comes packaged with PhpMyAdmin, if memory serves. Use that web interface to export your database tables in .sql format.
If you have PhpMyAdmin on the Ubuntu machine as well, you can use that to import the exported .sql file there.
If you don't, you can do the import from the command line.
Create an empty database on the Ubuntu machine with:
After that, you can import the .sql file you made earlier using
Thanks to xofer for the comment below, I updated my answer.
from the command line:
then copy the .sql to the ubuntu server and then: