3 ms·
I store the dump of the database in source control, so several years ago I made a small program mysqldump_ddl to strip out all ephemeral data that clutters up t
by ars 13y ago
I store the dump of the database in source control, so several years ago I made a small program mysqldump_ddl to strip out all ephemeral data that clutters up the changes:
#!/bin/sh
mysqldump --no-data $* | sed 's/ AUTO_INCREMENT=[0-9]*//' | egrep -v '^-- (MySQL dump|Server version|Dump completed on)'
Now the database diff only has actual changes. (Mostly - sometimes new versions of mysql change other things.)