Option 3: the command line Tried and true, the command line will always be the most efficient—though not the most friendly way—to accomplish a database export/import.

You can copy a MySQL database to a website using a tool such as phpMyAdmin or by using the MySQL command line. Create a new target database, export the data from the source database and import it ...

The mysql command-line interactive program is a very powerful way to access, display and even manipulate data without the need for any GUI at all. The basic commands are well worth learning, so if you ...

User xxx logs in fine from the command line, and the xxx user has permissions on *.* from the host (all but grant). The dumpfile works fine after I scp it to the xxx host and import. The xxx user ...

LibreOffice Base can make working with remote MySQL databases a snap. Jack Wallen walks you through the steps to make this happen.