ignore

sshz extranetdb "mysqldump  --single-transaction --opt  --ignore-table=crm_zeald.accounts --ignore-table=crm_zeald.accounts_bugs --ignore-table=crm_zeald.accounts_contacts --ignore-table=crm_zeald.accounts_opportunities --ignore-table=crm_zeald.active_customers --ignore-table=crm_zeald.adodb_logsql --ignore-table=crm_zeald.agencies --ignore-table=crm_zeald.autosave --ignore-table=crm_zeald.billing --ignore-table=crm_zeald.billing_exports --ignore-table=crm_zeald.billing_exports_approval --ignore-table=crm_zeald.billing_exports_salesperson_2016_q3_model --ignore-table=crm_zeald.budgets --ignore-table=crm_zeald.bugs --ignore-table=crm_zeald.calls --ignore-table=crm_zeald.calls_contacts --ignore-table=crm_zeald.calls_resources --ignore-table=crm_zeald.calls_users --ignore-table=crm_zeald.campaign_costs --ignore-table=crm_zeald.campaigns --ignore-table=crm_zeald.cases --ignore-table=crm_zeald.cases_bugs --ignore-table=crm_zeald.cases_drafts --ignore-table=crm_zeald.catalog_domains --ignore-table=crm_zeald.change_log --ignore-table=crm_zeald.checksum --ignore-table=crm_zeald.client_data --ignore-table=crm_zeald.companies --ignore-table=crm_zeald.config --ignore-table=crm_zeald.consultant_invoices --ignore-table=crm_zeald.consultant_purchase_orders --ignore-table=crm_zeald.contacts --ignore-table=crm_zeald.contacts_bugs --ignore-table=crm_zeald.contacts_cases --ignore-table=crm_zeald.currencies --ignore-table=crm_zeald.custom_fields --ignore-table=crm_zeald.designs --ignore-table=crm_zeald.documents_queue --ignore-table=crm_zeald.emails --ignore-table=crm_zeald.emails_accounts --ignore-table=crm_zeald.emails_cases --ignore-table=crm_zeald.emails_contacts --ignore-table=crm_zeald.emails_message_body_bak --ignore-table=crm_zeald.emails_opportunities --ignore-table=crm_zeald.emails_users --ignore-table=crm_zeald.external_address --ignore-table=crm_zeald.external_calendar --ignore-table=crm_zeald.feeds --ignore-table=crm_zeald.files --ignore-table=crm_zeald.form_notes --ignore-table=crm_zeald.gdrive_upload_queue --ignore-table=crm_zeald.google_sync --ignore-table=crm_zeald.iframes --ignore-table=crm_zeald.import_maps --ignore-table=crm_zeald.jobs --ignore-table=crm_zeald.kpi_log_detail --ignore-table=crm_zeald.lead_duplicates --ignore-table=crm_zeald.leads --ignore-table=crm_zeald.leads_opportunities --ignore-table=crm_zeald.meeting_recurrence --ignore-table=crm_zeald.meetings --ignore-table=crm_zeald.meetings_contacts --ignore-table=crm_zeald.meetings_resources --ignore-table=crm_zeald.meetings_users --ignore-table=crm_zeald.members_teams --ignore-table=crm_zeald.migrations --ignore-table=crm_zeald.notes --ignore-table=crm_zeald.openerp_consultant_invoices --ignore-table=crm_zeald.openerp_consultant_payments --ignore-table=crm_zeald.openerp_consultant_purchase_orders --ignore-table=crm_zeald.openerp_consultant_time_materials --ignore-table=crm_zeald.opportunities --ignore-table=crm_zeald.opportunities_contacts --ignore-table=crm_zeald.opportunities_pipeline --ignore-table=crm_zeald.prices --ignore-table=crm_zeald.products --ignore-table=crm_zeald.products_groups --ignore-table=crm_zeald.products_job_codes --ignore-table=crm_zeald.project_change_lines --ignore-table=crm_zeald.project_changes --ignore-table=crm_zeald.project_stage_workflows --ignore-table=crm_zeald.projects --ignore-table=crm_zeald.projects_bugs --ignore-table=crm_zeald.projects_contacts --ignore-table=crm_zeald.projects_stages --ignore-table=crm_zeald.queues --ignore-table=crm_zeald.quotes --ignore-table=crm_zeald.quotes_job_codes --ignore-table=crm_zeald.releases --ignore-table=crm_zeald.report_usage --ignore-table=crm_zeald.resources  --ignore-table=crm_zeald.status_history --ignore-table=crm_zeald.summary_timetracking_billings --ignore-table=crm_zeald.supplies --ignore-table=crm_zeald.survey_email_sent --ignore-table=crm_zeald.survey_satisfaction --ignore-table=crm_zeald.tags --ignore-table=crm_zeald.tasks --ignore-table=crm_zeald.teams --ignore-table=crm_zeald.test_email --ignore-table=crm_zeald.timetracking --ignore-table=crm_zeald.timetracking_sessions  --ignore-table=crm_zeald.timetracking_tags --ignore-table=crm_zeald.tmp_accounts --ignore-table=crm_zeald.tmp_agency_contacts --ignore-table=crm_zeald.tmp_backup_20181107_accounts --ignore-table=crm_zeald.tmp_backup_20181107_jobs --ignore-table=crm_zeald.tmp_backup_20181107_opportunities --ignore-table=crm_zeald.tmp_backup_20181107_projects --ignore-table=crm_zeald.tmp_backup_20191024_prices --ignore-table=crm_zeald.tmp_budgets_20191114 --ignore-table=crm_zeald.tmp_budgets_20191121 --ignore-table=crm_zeald.tmp_contacts --ignore-table=crm_zeald.tmp_existing_clients --ignore-table=crm_zeald.tmp_existing_urls --ignore-table=crm_zeald.tmp_extra_agency_client_detail --ignore-table=crm_zeald.tmp_extra_agency_clients --ignore-table=crm_zeald.tmp_incorrect_ops --ignore-table=crm_zeald.tmp_jobs_20191114 --ignore-table=crm_zeald.tmp_leads --ignore-table=crm_zeald.tmp_opps --ignore-table=crm_zeald.tmp_reassign --ignore-table=crm_zeald.tmp_restore --ignore-table=crm_zeald.tmp_ssl_sales --ignore-table=crm_zeald.tmp_tags_pre_mautic --ignore-table=crm_zeald.tmp_timetracking_20191114 --ignore-table=crm_zeald.tmp_timetracking_20191121 --ignore-table=crm_zeald.tmp_timetracking_20191214 --ignore-table=crm_zeald.tmp_workflow_activities_20180409 --ignore-table=crm_zeald.tmp_workflow_activities_20191107 --ignore-table=crm_zeald.tmp_workflow_activity_actions_20191107 --ignore-table=crm_zeald.tmp_zest_promo_accounts --ignore-table=crm_zeald.tracker --ignore-table=crm_zeald.upfront_TM_change_log --ignore-table=crm_zeald.users --ignore-table=crm_zeald.users_email_signatures --ignore-table=crm_zeald.users_feeds --ignore-table=crm_zeald.users_last_import --ignore-table=crm_zeald.users_targets --ignore-table=crm_zeald.view_dps_report --ignore-table=crm_zeald.view_services_websites_without_catalogs --ignore-table=crm_zeald.website_current_metrics --ignore-table=crm_zeald.workflow_activities --ignore-table=crm_zeald.workflow_activity_actions --ignore-table=crm_zeald.workflow_activity_roles --ignore-table=crm_zeald.workflow_checklists --ignore-table=crm_zeald.workflow_instance_activities --ignore-table=crm_zeald.workflow_instance_activities_temp --ignore-table=crm_zeald.workflow_instance_comments --ignore-table=crm_zeald.workflow_instances --ignore-table=crm_zeald.workflow_processes --ignore-table=crm_zeald.workflow_roadmap_supercedes --ignore-table=crm_zeald.workflow_roles --ignore-table=crm_zeald.workflow_task_savesearch --ignore-table=crm_zeald.workflow_transitions --ignore-table=crm_zeald.workflow_user_roles --ignore-table=crm_zeald.workflow_workitems crm_zeald  | gzip "  | gzip -d | mysql -u root -h 192.168.35.11 crm_zeald