# sudo su
# cd /var/lib/mysql
# mysqldump live_database > live_database.sql
# sed -i 's/livedomain.com/stagingdomain.com/g' ./live_database.sql
# mysql staging_database < ./live_database.sql
# rm live_database.sql
If you see the message: “Please login as the user “centos” rather than the user “root” we need to allow root access via SSH.
# ssh -i PrivateKey.pem centos@Floating-IP-Address
# sudo -s
# vi /root/.ssh/authorized_keys
# vi/etc/ssh/sshd_config
# systemctl restart sshd
Now you can SSH as root to your instance, high five!