Sql sync has a nice feature to skip the content of certain tables, and only sync it's structure. Which can save time...

Usage: Define the code below in e.g. ~/.drush/local.drushrc.php

/**
 * List of tables whose *data* is skipped by the 'sql-dump' and 'sql-sync'
 * commands when the "--structure-tables-key=common" option is provided.
 * You may add specific tables to the existing array or add a new element.
 */
$options['structure-tables']['common'] = array('cache', 'cache_field', 'cache_views', 'cache_form', 'cache_filter', 'cache_menu', 'cache_page', 'history', 'sessions', 'watchdog', 'accesslog');

Comments

helmo created an issue. See original summary.

  • helmo committed 04e6fc4 on 7.x-3.x
    Issue #2892822: Use structure-tables-key option of sql-sync
    
helmo’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.