MySQL Foreign Key Checking tool

Posted on 2014-03-17
Medium Priority
Last Modified: 2015-01-19
What's the best tool to do MySQL foreign key checking similar to this link: https://github.com/michaelirey/mysql-foreign-key-checker

This link is great, the only problem is it's using Ruby Script. Any other best tool to do MySQL Foreign Key Checking? Thanks.
Question by:heyday2004
LVL 86

Expert Comment

ID: 39936565
Shouldn't be too difficult to produce a Java version, though since this is an admin tool, i'd be surprised if there isn't already a MySql tool to do this
LVL 28

Accepted Solution

dpearson earned 1500 total points
ID: 39937621
Percona (http://www.percona.com/) has a powerful set of free tools that do a lot of schema verification, duplicate index checking etc.  I'm not sure if they have one that explicitly does foreign key checking but it would be worth checking their list:

(Percona is a bunch of MySQL experts - they even support their own build of MySQL).


Author Comment

ID: 40558719

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
The viewer will learn how to implement Singleton Design Pattern in Java.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question