Solved

MySQL Foreign Key Checking tool

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
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 …

744 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

11 Experts available now in Live!

Get 1:1 Help Now