I'm working towards using sql-dump together with git to version the drupal database. Having structure-only tables is a great thing for excluding all cache tables. But there is still one gotcha: The cache tables still have an incrementing AUTO_INCREMENT= setting. This is due to a bug in MySQL ( http://bugs.mysql.com/bug.php?id=44425 ).

It would be great to delete this setting for all structure_tables.

I attach a patch that implements this using sed. This wouldn't work on windows though. Any suggestions?

CommentFileSizeAuthor
drush-no-auto_increment.diff610 bytestorotil

Comments

torotil’s picture

torotil commented
Status: Active » Needs review
moshe weitzman’s picture

moshe weitzman commented
Status: Needs review » Closed (won't fix)

I'm not too interested in post-procesing the dump. You can use the drush invoke API to run code after sql-dump finishes. see docs/drush.api.php