M
M
Maxim Timofeev2018-02-27 20:01:59
MySQL
Maxim Timofeev, 2018-02-27 20:01:59

How to compare two MySql databases?

There are two databases (mySql), in theory identical, but the 1st app crashes (with a very strange error, not about mysql at all, it’s useful to debug, an hour later I decided that it was probably easier to compare). I want to find differences. What's the easiest way?
win10 openserver mysql5.6

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
Maxim Timofeev, 2018-02-27
@webinar

found some hell of a mess. In php addslashes, I replaced NULL with "" As a result, a very non-obvious error.
I compared it like this: I
made two dimps, threw it into phpStorm, compared it using the history of file changes.
How did you not guess right away? HZ. Thanks to everyone who tried to help.

I
ivankomolin, 2018-02-27
@ivankomolin

Check for the presence of keys in tables.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question