WordPress Backup and Restore

wpBackupRestore.sh

# Backup WordPress DB. Find the servername, username, and db name from wp-config.php. 
mysqldump --column-statistics=0 -h <sql-server-name> -u <sql-username> -p <sql-db-name> | bzip2 -c > blog.bak.sql.bz2

# Restore WordPress DB.

# First, uncompress the sql backup file. 
bzip2 -d blog.bak.sql.bz2

# Second, import the the database tables. Added protocol for docker compatability.
mysql -h localhost -P 8037 --protocol=tcp -u root -p wordpress < blog.bak.sql