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.

I’m going to assume your website depends on a MySQL database, runs on Apache, and /var/www/html is your document root. To make this backup/restore happen, you’ll need a user with root privileges.