Now, your MySQL database will be backed up every day at 1 a.m. into the /home/USER directory. How to restore your database OK, so let’s say disaster has struck, and you need to restore your website.

If a web-based GUI is better suited to your admin skills, Jack Wallen wants to show you how to back up and restore your MySQL/MariaDB databases with one of the easiest tools on the market.

To see a list of databases running in your MySQL instance, use the statement show databases;.This is pretty straightforward and does just what you'd think—on a new system, you'll see information ...