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.

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.

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

He was very gracious and sent me a simple one-liner I could run on the command line to get the information he needed. I was very thankful, but admittedly embarrassed. I figured if I don't know how to ...