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.

The command-line client is nice too. Also, I use MariaDB instead of MySQL in my examples, because that's what I have installed, and because I like the improvements MariaDB includes in both the command ...

Once you have all the data necessary, your database is ready for usage by your web-based tool. Just remember to connect the tool using the MySQL we created earlier, and you’re good to go.