How to check database backup integrity




How can I check that the wordpress database is correctly backup ?
When I download the zip file generated I don’t know where the database is stored.
I am new with php and mysql sorry if it’s a stupid question.



Hi, nicoev!

The db file is in the zip, if you unzip it you’ll find a .sql file at /wp-content/upgrade/dreamobject-db-backup.sql

Sadly the only way to test an SQL file is to upload it to an SQL server and look to see if everything is there. Personally, I like to install MAMP (a local version of webhosting software) on my laptop, so I can check those out.


Great I’ve found it !
Thank you