The above command will dump a compressed version of your database backup in the defined file (in this case products.sql.tgz). Keep it going You’re ready to continue the work.

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.

There are many backup options for databases, but here are recommendations for Cassandra, DB2, DynamoDB, MongoDB, MySQL, Oracle, and PostgreSQL.