Backup RDS MySQL AWS

mysqldump -h xxxxxxx.ap-southeast-3.rds.amazonaws.com -u adminxxxx --password=passwordxxx databasexxx --set-gtid-purged=OFF > /home/ubuntu/waikiki/backup_database_26jan2024.sql

Single Database Backup

mysqldump -u root -ppassword wpdb > wpdb_backup.sql

Multiple Database Backup

mysqldump -u root -ppassword --databases wpdb1 wpdb2 wpdb3 > wpdb_backup3.sql

All Database Backup

mysqldump -u root -ppassword --all-databases > alldb_backup.sql

Table Structure Only Backup

mysqldump -u root -ppassword --no-data wpdb > wpdb_backup.sql

Specific Table Backup

mysqldump -u root -ppassword --no-data wpdb wptable > wpdbtable_backup.sql

Reference:

• MySQL Dump Ultimate Guide