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.

Jack Wallen explains how to add data into a MySQL table from the command line.

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

Whether you're running a LAMP stack on Ubuntu or CentOS, you need to back up your MySQL databases. Learn how to do this with the help of the mysqldump command.