-- CREATE WEBSITE STAGING
ssh dokku@staging.gbh.com.do apps:create <staging-app-name>

-- CREATE WEBSITE DATABASE
ssh dokku@staging.gbh.com.do mysql:create <database-name>

Note: ** After creating the database, add the data to .deploy FOLDER / wp-config **

define('DB_NAME', 'Name__DB');
define('DB_USER', 'mysql');
define('DB_PASSWORD', 'f1544ee7b35e474e');
define('DB_HOST', 'dokku-mysql-policlinico');


-- ADD .deploy FOLDER AND Dockerfile FILE, AND CONFIGURE THE wp-config INSIDE .deploy FOLDER


-- LIST STAGING
ssh dokku@staging.gbh.com.do apps:list


-- LIST DATABASE
ssh dokku@staging.gbh.com.do mysql:list


-- LINK WEBSITE DATABASE
ssh dokku@staging.gbh.com.do mysql:link <database-name> <staging-app-name>


-- ADD GIT REMOTE STAGING
git remote add dokku dokku@staging.gbh.com.do:<staging-app-name>


-- MAKE COMMIT ABOUT THE ADDED FILES


-- PUSH GIT REMOTE STAGING
git push dokku <local-branch>:master


-- GO TO YOUR HOMESTEAD VIA SSH CONNECTION
vagrant ssh


-- EXPORT DATABASE FROM HOMESTEAD AND REPLACE DOMAIN ROUTE
wp search-replace <local-site-url> <staging-site-url> --allow-root --export=<database-name>.sql


-- IMPORT DATABASE
ssh dokku@staging.gbh.com.do mysql:import <database-name> < <database-name>.sql --binary-mode=1


-- FIND AND REPLACE URL ON DATABASE
ssh dokku@staging.gbh.com.do run <database-name> wp search-replace '<local-site-url>' '<staging-site-url>' --allow-root


-- CHECK IF THERE IS ANY MATCH WITH THE SEARCH MADE ON THE DATABASE
ssh dokku@staging.gbh.com.do run <database-name> wp search-replace '<local-site-url>' '<staging-site-url>' --allow-root --dry-run


-- CHECK DATABASE INFO
ssh dokku@staging.gbh.com.do mysql:info <database-name>