Exit out of the MySQL prompt with the command exit; Your WordPress instance (set up with the proper user credentials for the database) should be able to use the remote MySQL server as its database ...

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.