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

In the case of MySQL database migration, you have many options for accomplishing the task. I’ll discuss three of the most common options and when to use each. Option 1: phpMyAdmin ...