Solved

MySQL Foreign Key Checking tool

Posted on 2014-03-17
3
237 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 26

Accepted Solution

by:
dpearson earned 500 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
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.

785 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