Need a utility to scan .sql files for coruption

[Gutspiller]

I have backed up some sites I have that use mysql (vbulletin and others) using phpmyadmin, but is there any program out there that will tell me if I've gotten all the info in the .sql file and make sure that all the data is included in the .sql file and nothing is missing?

If anybody knows of something like this, please let me know as I could really use a utility like this.

Thank you.

[Marco van Herwaarden]

? program like that would be facing a chicken and egg problem. How this program should know there is something missing if it is not there. ;)

[Dan]

This brings us the more ultimate question....

What came first the chicken or the egg?

[Marco van Herwaarden]

My mother

[Gutspiller]

Is what I ment is for the program to detect if there is corruption inside the sql file. I thought that was what I asked?

[filburt1]

You could set up a database on a separate system and execute the SQL file. If it completes successfully, then it's likely fine. Also look at the very end of the file which is where any corruption would have likely occurred. There may also be a simulator mode for MySQL which interprets the queries but doesn't really execute them.

[Gutspiller]

re-executing the sql file wouldn't work as I have about 8 sites and was looking for a faster way. Guess a program doesn't exist. I will check the end of the files to see if I can even understand it. What would be the best to open the sql file though? My forum sql file is 800 MB, I don't think notepad would like that.

[Marco van Herwaarden]

On a Unix/Linix system, best is to use: tail -20 <filename>
Otherwise a decent editor that can handle big files.