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.

6 rows in set (0.00 sec) Just the Tip of the Iceberg! 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.

When running non-interactive MySQL commands one may submit MySQL credentials on the command line (we'll share with you a better option after the break), e.g.: mysql --password=secret --user=username ...

The MySQL command line can be a bit daunting at first, but once you get the hang of it, it’ll become second nature. SEE: Server deployment/migration checklist (Tech Pro Research) ...