-- basic mysql credential template
-- generated on 2019/03/14 16:53:01 for virtualhost supered-mrm.sugar8.loadedstage.com
-- user: supered_mrm_suga
-- pass: YGoF9twGqAtd
-- db: supered_mrm_sugar8_loadedstage_com

-- FULL DB Dump
-- mysqldump --create-options -h db.sugar8.loadedstage.com -u supered_mrm_suga -pYGoF9twGqAtd supered_mrm_sugar8_loadedstage_com > backup/supered_mrm_sugar8_loadedstage_com_timestamp.sql

-- Dump without the heavy unnecessary tables
-- mysqldump --create-options -h db.sugar8.loadedstage.com -u supered_mrm_suga -pYGoF9twGqAtd supered_mrm_sugar8_loadedstage_com --ignore-table=supered_mrm_sugar8_loadedstage_com.activities --ignore-table=supered_mrm_sugar8_loadedstage_com.job_queue --ignore-table=supered_mrm_sugar8_loadedstage_com.activities_users | gzip -9 > backup/supered_mrm_sugar8_loadedstage_com_T.sql.gz

-- Dump fields_meta_data only (for Deployment purposes)
-- mysqldump --create-options --extended-insert=FALSE --insert-ignore -h db.sugar8.loadedstage.com -u supered_mrm_suga -pYGoF9twGqAtd supered_mrm_sugar8_loadedstage_com fields_meta_data > scripts/supered_mrm_sugar8_loadedstage_com_fields_meta_data.sql


CREATE DATABASE supered_mrm_sugar8_loadedstage_com CHARACTER SET='utf8';
CREATE USER 'supered_mrm_suga'@'%' IDENTIFIED BY 'YGoF9twGqAtd';
CREATE USER 'supered_mrm_suga'@'localhost' IDENTIFIED BY 'YGoF9twGqAtd';
GRANT ALL PRIVILEGES ON supered_mrm_sugar8_loadedstage_com.* TO 'supered_mrm_suga'@'%';
GRANT ALL PRIVILEGES ON supered_mrm_sugar8_loadedstage_com.* TO 'supered_mrm_suga'@'localhost';
