dg/mysql-check

Checks a MySQL database for orphaned records or invalid foreign keys, i.e., keys pointing to missing rows.

v1.0.0 2013-06-23 21:44 UTC

BSD-3-Clause

• David Grudl

• mysql

README

Checks a MySQL database for orphaned records or invalid foreign keys, i.e., keys pointing to missing rows.

Create MySQLi object and then check database named blog:

$mysqli = new mysqli('localhost', 'root', 'password');
checkForeignKeys($mysqli, 'blog');

Or without parameter it checks all databases:

checkForeignKeys($mysqli);

If you like it, please make a donation now. Thank you!