The MySQL command line can be a bit daunting at first, but once you get the hang of it, it’ll become second nature. ... First gain access to the MySQL prompt with the command: sudo mysql.

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.