Project Setup

Create Database on Staging Server

ssh [email protected]
mysql -uroot -pREMOTE_MYSQL_ROOT_PASSWORD
create database REMOTE_DBNAME COLLATE 'utf8_unicode_ci';
show databases;
exit

Create Database on Local Server

ssh [email protected]
mysql -uroot -pLOCAL_MYSQL_ROOT_PASSWORD
create database LOCAL_DBNAME COLLATE 'utf8_unicode_ci';
show databases;
exit

Sync assets and database from local PC to staging server (1.3 to 99)

In local server

ssh [email protected]

Dump and import to remote server

mysqldump -uMYSQL_USER -pLOCAL_MYSQL_ROOT_PASSWORD LOCAL_DBNAME | ssh [email protected] mysql -uroot -p'REMOTE_MYSQL_ROOT_PASSWORD' REMOTE_DBNAME    
ctrl+d

In remote server

ssh [email protected]
cd /var/www/PROJECT_NAME
wp search-replace LOCAL_PROJECT_URL REMOTE_PROJECT_URL --allow-root
wp user list --allow-root
wp user update 1 --user_pass=NEW_PASSWORD --allow-root
ctrl+d

In developer pc

Copy wp-config.php and .htaccess file to remote server

cd LOCAL_PROJECT_PATH
scp -r wp-config.php [email protected]:/var/www/PROJECT_NAME
scp -r .htaccess [email protected]:/var/www/PROJECT_NAME

Sync local project folder to remote server project folder

rsync -chavzP --stats LOCAL_PROJECT_PATH/UPLOADS_FOLDER_PATH [email protected]:/var/www/PROJECT_NAME/UPLOADS_FOLDER_PATH

Sync assets and database from staging server to local PC (99 to 1.3)

In local server

ssh [email protected]

Dump local database for backup (optional)

cd ~/Documents
mysqldump -u MYSQL_USER -pLOCAL_MYSQL_ROOT_PASSWORD LOCAL_DBNAME --compatible=mysql40 > LOCAL_DBNAME.$(date +%Y-%m-%d-%H.%M.%S).sql

Dump and import to local server

ssh [email protected] mysqldump -u root -pREMOTE_MYSQL_ROOT_PASSWORD REMOTE_DBNAME | mysql -uMYSQL_USER -pLOCAL_MYSQL_ROOT_PASSWORD LOCAL_DBNAME   
ctrl+d