?
Solved

MySQL Foreign Key Checking tool

Posted on 2014-03-17
3
Medium Priority
?
264 Views
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.
0
Comment
Question by:heyday2004
3 Comments
 
LVL 86

Expert Comment

by:CEHJ
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
0
 
LVL 28

Accepted Solution

by:
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:
http://www.percona.com/doc/percona-toolkit/2.2/

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

Doug
0
 

Author Comment

by:heyday2004
ID: 40558719
Thanks.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Suggested Courses

839 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