Skip to content

Instantly share code, notes, and snippets.

@omega8cc
Created March 3, 2015 14:25
Show Gist options
  • Save omega8cc/e75d228d4f3b54fa72a2 to your computer and use it in GitHub Desktop.
Save omega8cc/e75d228d4f3b54fa72a2 to your computer and use it in GitHub Desktop.
o1.ftp:~$ drush @d7.demo.aegir.cc sql-dump --skip-tables-list=cache,cache_block,cache_bootstrap,cache_field,cache_filter,cache_form,cache_libraries,cache_menu,cache_metatag,cache_page,cache_path,cache_token,cache_update,cache_views,cache_views_data,session --result-file=./file.sql -vd
Starting Drush preflight. [0.01 sec, 3.76 MB] [preflight]
Loaded alias @d7.demo.aegir.cc from file /home/o1.ftp/.drush/d7.demo.aegir.cc.alias.drushrc.php [0.03 sec, 3.77 MB] [notice]
Cache SET cid: 7.0-dev-alias-path--823921912d0a1c6791ddcd5f3298fc59 [0.04 sec, 3.84 MB] [debug]
Cache HIT cid: 7.0-dev-commandfiles-0-445c35303224e4f67ed0c7df677f9dee [0.05 sec, 3.86 MB] [debug]
Bootstrap to phase 0. [0.19 sec, 10.13 MB] [bootstrap]
Bootstrap to phase 0. [0.19 sec, 10.13 MB] [bootstrap]
Found command: sql-dump (commandfile=sql) [0.19 sec, 10.14 MB] [bootstrap]
Calling hook drush_sql_dump [0.2 sec, 10.17 MB] [debug]
Drush bootstrap phase : _drush_bootstrap_drupal_root() [0.2 sec, 10.18 MB] [bootstrap]
Initialized Drupal 7.34 root directory at /data/disk/o1/distro/012/drupal-7.34.1-stage [0.21 sec, 10.76 MB] [notice]
Cache MISS cid: 7.0-dev-install_profile-4410ec34d9e6c1a68100ca0ce033fb17 [0.22 sec, 8.37 MB] [debug]
Cache HIT cid: 7.0-dev-commandfiles-1-d7e87de5da59591486dd57992d48011c [0.22 sec, 8.38 MB] [debug]
Drush bootstrap phase : _drush_bootstrap_drupal_site() [0.22 sec, 8.38 MB] [bootstrap]
Loading drushrc "/data/disk/o1/distro/012/drupal-7.34.1-stage/sites/d7.demo.aegir.cc/drushrc.php" into "site" scope. [0.22 sec, 8.39 MB] [bootstrap]
Initialized Drupal site d7.demo.aegir.cc at sites/d7.demo.aegir.cc [0.34 sec, 11.34 MB] [notice]
Cache MISS cid: 7.0-dev-install_profile-84638b39c51776bc80e4f9c4744dec8d [0.35 sec, 8.94 MB] [debug]
Cache MISS cid: 7.0-dev-install_profile-84638b39c51776bc80e4f9c4744dec8d [0.35 sec, 8.95 MB] [debug]
Cache HIT cid: 7.0-dev-commandfiles-2-baf18e7b7b076e20cd690d1d3370bbbd [0.35 sec, 8.95 MB] [debug]
Drush bootstrap phase : _drush_bootstrap_drupal_configuration() [0.35 sec, 8.95 MB] [bootstrap]
Cache MISS cid: 7.0-dev-install_profile-84638b39c51776bc80e4f9c4744dec8d [0.36 sec, 9.03 MB] [debug]
sql-query: SHOW TABLES; [0.36 sec, 9.2 MB] [status]
Executing: mysql --defaults-extra-file=/home/o1.ftp/.tmp/drush_JhoJZq --database=d7demoaegircc --host=localhost --port=3306 --silent < /home/o1.ftp/.tmp/drush_AOm02g
actions
authmap
batch
block
block_custom
block_node_type
block_role
blocked_ips
cache
cache_block
cache_bootstrap
cache_entity_comment
cache_entity_file
cache_entity_node
cache_entity_taxonomy_term
cache_entity_taxonomy_vocabulary
cache_entity_user
cache_field
cache_filter
cache_form
cache_image
cache_menu
cache_page
cache_path
cache_update
comment
date_format_locale
date_format_type
date_formats
field_config
field_config_instance
field_data_body
field_data_comment_body
field_data_field_image
field_data_field_tags
field_revision_body
field_revision_comment_body
field_revision_field_image
field_revision_field_tags
file_managed
file_usage
filter
filter_format
flood
history
image_effects
image_styles
menu_custom
menu_links
menu_router
node
node_access
node_comment_statistics
node_revision
node_type
queue
rdf_mapping
registry
registry_file
role
role_permission
search_dataset
search_index
search_node_links
search_total
semaphore
sequences
sessions
shortcut_set
shortcut_set_users
system
taxonomy_index
taxonomy_term_data
taxonomy_term_hierarchy
taxonomy_vocabulary
url_alias
users
users_roles
variable
watchdog
Calling system((mysqldump --defaults-extra-file=/home/o1.ftp/.tmp/drush_K6iMZA d7demoaegircc --host=localhost --port=3306 --no-autocommit --single-transaction --opt -Q --ignore-table=d7demoaegircc.cache --ignore-table=d7demoaegircc.cache_block --ignore-table=d7demoaegircc.cache_bootstrap --ignore-table=d7demoaegircc.cache_field --ignore-table=d7demoaegircc.cache_filter --ignore-table=d7demoaegircc.cache_form --ignore-table=d7demoaegircc.cache_menu --ignore-table=d7demoaegircc.cache_page --ignore-table=d7demoaegircc.cache_path --ignore-table=d7demoaegircc.cache_update) > ./file.sql);
Database dump failed [0.38 sec, 9.21 MB] [error]
Returned from hook drush_sql_dump [0.38 sec, 9.21 MB] [debug]
Command dispatch complete [0.38 sec, 9.17 MB] [notice]
Timer Cum (sec) Count Avg (msec)
page 0.032 1 31.97
o1.ftp:~$
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment