-- basic mysql credential template
-- generated on 2014/09/09 15:35:52 for virtualhost supered.mrm.loadedstage.com
-- user: supered_mrm_load
-- pass: gbdpPXHfGtf4
-- db: supered_mrm_loadedstage_com

-- FULL DB Dump
-- mysqldump --create-options -h db.stage.loadedtech.com.au -u supered_mrm_load -pgbdpPXHfGtf4 supered_mrm_loadedstage_com > backup/supered_mrm_loadedstage_com_timestamp.sql

-- Dump without the heavy unnecessary tables
-- mysqldump --create-options -h db.stage.loadedtech.com.au -u supered_mrm_load -pgbdpPXHfGtf4 --ignore-table=supered_mrm_loadedstage_com.activities --ignore-table=supered_mrm_loadedstage_com.job_queue --ignore-table=supered_mrm_loadedstage_com.activities_users supered_mrm_loadedstage_com | gzip -9 > backup/supered_mrm_loadedstage_com_T.sql.gz

-- Dump fields_meta_data only (for Deployment purposes)
-- mysqldump --create-options --extended-insert=FALSE -h db.stage.loadedtech.com.au -u supered_mrm_load -pgbdpPXHfGtf4 supered_mrm_loadedstage_com fields_meta_data > scripts/supered.mrm.loadedstage.com_fields_meta_data.sql

CREATE DATABASE supered_mrm_loadedstage_com CHARACTER SET='utf8';
CREATE USER 'supered_mrm_load'@'%' IDENTIFIED BY 'gbdpPXHfGtf4';
CREATE USER 'supered_mrm_load'@'localhost' IDENTIFIED BY 'gbdpPXHfGtf4';
GRANT ALL PRIVILEGES ON supered_mrm_loadedstage_com.* TO 'supered_mrm_load'@'%';
GRANT ALL PRIVILEGES ON supered_mrm_loadedstage_com.* TO 'supered_mrm_load'@'localhost';



--	mysqldump --create-options -h db.stage.loadedtech.com.au -u supered_mrm_load -pgbdpPXHfGtf4 supered_mrm_loadedstage_com --ignore-table=supered_mrm_loadedstage_com.accounts_contacts --ignore-table=supered_mrm_loadedstage_com.calls_contacts --ignore-table=supered_mrm_loadedstage_com.contacts --ignore-table=supered_mrm_loadedstage_com.contacts_audit --ignore-table=supered_mrm_loadedstage_com.contacts_bugs --ignore-table=supered_mrm_loadedstage_com.contacts_cases --ignore-table=supered_mrm_loadedstage_com.contacts_cstm --ignore-table=supered_mrm_loadedstage_com.contacts_users --ignore-table=supered_mrm_loadedstage_com.contracts_contacts --ignore-table=supered_mrm_loadedstage_com.documents_contacts --ignore-table=supered_mrm_loadedstage_com.lt_funds_contacts_c --ignore-table=supered_mrm_loadedstage_com.meetings_contacts --ignore-table=supered_mrm_loadedstage_com.opportunities_contacts --ignore-table=supered_mrm_loadedstage_com.projects_contacts --ignore-table=supered_mrm_loadedstage_com.quotes_contacts --ignore-table=supered_mrm_loadedstage_com.se_advice_contacts_c --ignore-table=supered_mrm_loadedstage_com.se_documentinteractions_contacts_c --ignore-table=supered_mrm_loadedstage_com.se_flcompetencyresult_contacts_c --ignore-table=supered_mrm_loadedstage_com.se_investments_contacts_c --ignore-table=supered_mrm_loadedstage_com.se_memberupdates_contacts_c --ignore-table=supered_mrm_loadedstage_com.se_advice --ignore-table=supered_mrm_loadedstage_com.se_advice_cstm --ignore-table=supered_mrm_loadedstage_com.se_advice_audit --ignore-table=supered_mrm_loadedstage_com.se_advice_documents_1_c --ignore-table=supered_mrm_loadedstage_com.se_advice_se_transactions_1_c --ignore-table=supered_mrm_loadedstage_com.se_documentinteractions --ignore-table=supered_mrm_loadedstage_com.se_documentinteractions_cstm --ignore-table=supered_mrm_loadedstage_com.se_documentinteractions_audit --ignore-table=supered_mrm_loadedstage_com.se_documentinteractions_documents_c --ignore-table=supered_mrm_loadedstage_com.se_investments --ignore-table=supered_mrm_loadedstage_com.se_investments_cstm --ignore-table=supered_mrm_loadedstage_com.se_investments_audit --ignore-table=supered_mrm_loadedstage_com.se_investments_se_investmentoptions_c --ignore-table=supered_mrm_loadedstage_com.se_transactions --ignore-table=supered_mrm_loadedstage_com.se_transactions_cstm --ignore-table=supered_mrm_loadedstage_com.se_transactions_audit --ignore-table=supered_mrm_loadedstage_com.se_investments_se_transactions_c --ignore-table=supered_mrm_loadedstage_com.se_members_se_investments_c --ignore-table=supered_mrm_loadedstage_com.se_memberupdates --ignore-table=supered_mrm_loadedstage_com.se_memberupdates_audit --ignore-table=supered_mrm_loadedstage_com.lt_funds --ignore-table=supered_mrm_loadedstage_com.lt_funds_cstm --ignore-table=supered_mrm_loadedstage_com.lt_funds_audit --ignore-table=supered_mrm_loadedstage_com.se_flcompetencyresult --ignore-table=supered_mrm_loadedstage_com.se_flcompetencyresult_audit --ignore-table=supered_mrm_loadedstage_com.se_flcompetencyresult_cstm --ignore-table=supered_mrm_loadedstage_com.se_flcompetencyresult_se_fl_competency_c --ignore-table=supered_mrm_loadedstage_com.email_addr_bean_rel --ignore-table=supered_mrm_loadedstage_com.email_addresses --ignore-table=supered_mrm_loadedstage_com.emails_email_addr_rel --ignore-table=supered_mrm_loadedstage_com.emails --ignore-table=supered_mrm_loadedstage_com.emails_text --ignore-table=supered_mrm_loadedstage_com.email_cache --ignore-table=supered_mrm_loadedstage_com.activities --ignore-table=supered_mrm_loadedstage_com.job_queue --ignore-table=supered_mrm_loadedstage_com.activities_users > backup/supered_mrm_loadedstage_com_SELECTIVE_timestamp.sql
