SQL script to help recover from corrupted database
The compiler should generate some SQL scripts to help discover referential integrity violations, e.g. when using MyISAM storage engine.Submitted by Danny Groenewegen on 21 May 2010 at 17:10
I can make a check script generator and make it a builder in the WebDSL plugin. Will that do?
Done. The WebDSL editor now has a 'database integrity check' builder, which produces a SQL script to check the database. The SQL script will output all invalid references. Only foreign key checks for now. Will add uniqueness checks later.
Log in to post comments