>Script ignore unnecessary tables when exporting database

Script ignore unnecessary tables when exporting database

There are some cases we need to export database:

  • moving server.
  • setup dev site or local version.
  • backup.

The size of database sometimes is very big, because it contains too much data. If we just need to setup a local version, the following tables are unnecessary:

core_url_rewrite
dataflow_batch_export
dataflow_batch_import
index_process_event
log_customer
log_quote
log_summary
log_summary_type
log_url
log_url_info
log_visitor
log_visitor_info
log_visitor_online
report_event

I wrote the sh script to export database without those tables. Please download it here: https://www.dropbox.com/s/5aeqe3ab3kc7xah/export.sh?dl=0.

< Previous Post
Next Post >