Solved

MySQL Foreign Key Checking tool

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySql hide the stored procedures 2 40
Unable to save view in SSMS 21 60
RDBMS and No sql database 4 47
how to see all occupied ports on windows 10 laptop 15 26
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:

863 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now