Compare 2 mysql or mariadba database data changes12.08.18

1.
create a small bash script with:
export.sh

#!/bin/bash
docker  run -i --rm --net=host  salamander1/mysqldump --verbose --skip-comments --skip-extended-insert  -h 127.0.0.1 -u USERNAE -pMYPASS DBNAME > MYDB-${1}.sql

2.
before the database change run it with
./export.sh 1

3.
after the changes just run it like: 
./export.sh 2

f you're working with small databases I've found running mysqldump on both databases with the --skip-comments and --skip-extended-insert options to generate SQL scripts, then running diff on the SQL scripts works pretty well.

By skipping comments you avoid meaningless differences such as the time you ran the mysqldump command. By using the --skip-extended-insert command you ensure each row is inserted with its own insert statement. This eliminates the situation where a single new or modified record can cause a chain reaction in all future insert statements. Running with these options produces larger dumps with no comments so this is probably not something you want to do in production use but for development it should be fine. I've put examples of the commands I use below:

mysqldump --skip-comments --skip-extended-insert -u root -p dbName1>file1.sql
mysqldump --skip-comments --skip-extended-insert -u root -p dbName2>file2.sql
diff file1.sql file2.sql

https://stackoverflow.com/questions/225772/compare-two-mysql-databases

Anonymous

Compare 2 mysql or mariadba database data changes12.08.18

Information Epoch 1732660487