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.

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 ...