There are some cases we need to export database:
- moving server.
- setup dev site or local version.
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.