I have found a php script that makes a backup of a mysql database.
Simply upload or save the php script on the server, open an url to
the php file and download the backup.sql.
Gives me my own control to make database backups. So far so good.
I made a second sql backup of the same database simply through
the CPanel of the Hoster using phpmyadmin.
Thing is when I open this second backup.sql file in wordpad and compare it
with the first backup sql file made with the php script, it looks very different.
Also both of the backups differ in size.
Of course I could setup a test server and try both sql backups
and see if the website works the same.
My question is, is there another way to compare two sql backups
to check if they have the same number of tables, create table, insert into, etc. ?