WordPress 5 Cookbook

How it works...

We created a backup in the previous recipe. Then we altered the database by creating a new post in this recipe. When we want to switch back to the old database, we can use the built-in Manage Backup DB section of the plugin. We can select one of the backups from the list. You can pick the latest backup or select a backup based on the date. Once it's selected and the Restore button is clicked, the plugin will internally execute a SQL command similar to the following:

"c:/wamp64/bin/mysql/mysql5.7.26/bin/mysql.exe" –host="localhost" –user="root" –password="" –default-character-set="utf8" cookbooktest1 < "C:/wamp64/www/cookbook1/wp-content/backup-db/2793a78b670042d4037acf18d9f317b3_-_1577860977_-_cookbooktest1.sql"

We use mysql.exe ...