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.

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.

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

I'm coming from a MS SQL Server background, where I would just create a job and import for this, and I'd be all set. I don't know MySQL well at all, so I was hoping someone could point me in the ...