Révision 2a0f9a31
Ajouté par Florent Torregrosa il y a presque 7 ans
| .drush/drushrc.php | ||
|---|---|---|
| 270 | 270 |
*/ |
| 271 | 271 |
# $options['structure-tables']['common'] = array('cache', 'cache_filter', 'cache_menu', 'cache_page', 'history', 'sessions', 'watchdog');
|
| 272 | 272 |
|
| 273 |
$options['structure-tables']['common-d7'] = [ |
|
| 274 |
'cache', |
|
| 275 |
'cache_*', |
|
| 276 |
'flood', |
|
| 277 |
'history', |
|
| 278 |
'search_*', |
|
| 279 |
'sessions', |
|
| 280 |
'watchdog', |
|
| 281 |
]; |
|
| 282 |
|
|
| 283 |
$options['structure-tables']['common-d8'] = [ |
|
| 284 |
'cache', |
|
| 285 |
'cache_*', |
|
| 286 |
'flood', |
|
| 287 |
'history', |
|
| 288 |
'search_*', |
|
| 289 |
'sessions', |
|
| 290 |
'watchdog', |
|
| 291 |
]; |
|
| 292 |
|
|
| 273 | 293 |
/** |
| 274 | 294 |
* List of tables to be omitted entirely from SQL dumps made by the 'sql-dump' |
| 275 | 295 |
* and 'sql-sync' commands when the "--skip-tables-key=common" option is |
| bin/d7-all-dump-individual.sh | ||
|---|---|---|
| 34 | 34 |
dir=$(get_site_dir_from_name "${site}")
|
| 35 | 35 |
|
| 36 | 36 |
if [ "${mode}" = 'auto' ] ; then
|
| 37 |
drush @"${site}" sql-dump --result-file="${d7_dir_individual_auto_backup}/${dir}/${current_date}.${dir}.sql" --gzip
|
|
| 37 |
drush @"${site}" sql-dump --result-file="${d7_dir_individual_auto_backup}/${dir}/${current_date}.${dir}.sql" --gzip --structure-tables-key=common-d7
|
|
| 38 | 38 |
else |
| 39 |
drush @"${site}" sql-dump --result-file="${d7_dir_individual_manual_backup}/${dir}/${current_date}.${dir}.sql" --gzip
|
|
| 39 |
drush @"${site}" sql-dump --result-file="${d7_dir_individual_manual_backup}/${dir}/${current_date}.${dir}.sql" --gzip --structure-tables-key=common-d7
|
|
| 40 | 40 |
fi |
| 41 | 41 |
done |
| bin/d7-sync-site.sh | ||
|---|---|---|
| 63 | 63 |
dir="assos.centrale-marseille.fr.${dest_site_name}"
|
| 64 | 64 |
fi |
| 65 | 65 |
if [ -z "${new_site}" ] ; then
|
| 66 |
drush -y "@${source_site_name}" sql-dump --result-file="${d7_dir_individual_manual_backup}/${dir}/${current_date}.${dir}.sql" --gzip
|
|
| 66 |
drush -y "@${source_site_name}" sql-dump --result-file="${d7_dir_individual_manual_backup}/${dir}/${current_date}.${dir}.sql" --gzip --structure-tables-key=common-d7
|
|
| 67 | 67 |
fi |
| 68 | 68 |
|
| 69 | 69 |
|
| ... | ... | |
| 80 | 80 |
## Sync |
| 81 | 81 |
current_date=$(date "+%Y-%m-%d-%Hh%Mm%Ss") |
| 82 | 82 |
sql_file="${dir_tmp}/${current_date}.${source_site_name}.sql"
|
| 83 |
drush -y "@${source_site_name}" sql-dump --result-file="${sql_file}"
|
|
| 83 |
drush -y "@${source_site_name}" sql-dump --result-file="${sql_file}" --structure-tables-key=common-d7
|
|
| 84 | 84 |
sed -i -e "s#https?://assos.centrale-marseille.fr/${source_site_name}#https://assos.centrale-marseille.fr/${dest_site_name}#g" "${sql_file}"
|
| 85 | 85 |
sed -i -e "s#/${source_site_name}/sites/assos.centrale-marseille.fr.${source_site_name}#/${dest_site_name}/sites/assos.centrale-marseille.fr.${dest_site_name}#g" "${sql_file}"
|
| 86 | 86 |
drush -y "@${dest_site_name}" sql-drop
|
Formats disponibles : Unified diff
Issue #650: Do not export data of some tables when dumping database.