Note: Login first to serbisyo.com server.
Backup the DB of 2nd.serbisyo.com
Note: All settings and configs in implementation checklist were already applied to 2nd.serbisyo.com. That's why it's good to make it as our base/initial DB.
mkdir -p ~/db_backup
cd ~/db_backup
sudo mysqldump -h 23.92.53.254 -u secondserbisyo -p secondserbisyo --single-transaction --quick --lock-tables=false > secondserbisyo_mysql_dump-$(date +%F).sql
Note: Get the DB password of secondserbisyo in pass.camp. Just search "secondserbisyo".
Replace the URLs in MySQL dump file for it to be compatible with serbisyo.com
sed -i "s/2nd\.serbisyo\.com/www\.serbisyo\.com/g" secondserbisyo_mysql_dump-$(date +%F).sql
Restore the database
Note: Drop/backup and recreate the serbisyo DB if necessary.
sudo mysql -u root -p serbisyo < secondserbisyo_mysql_dump-$(date +%F).sql
Note: Get the DB password of serbisyo in pass.camp. Just search "Prod-PhpMyAdmin-root".
Finally, test and double check all the functionalities in both admin dashboard and customer site.