RDS Backup and Rollback Command

[emAmazed]

Backup entire DB

mysqldump -h <endpoint> -P 3306 -u <username> -p <db-name> > backup-filename.sql

Backup all except certain tables

mysqldump -h <endpoint> -P 3306 -u <username> -p <db-name> --ignore-table=<db-name>.<table-name-1> --ignore-table=<db-name>.<table-name-2> >> backup-filename.sql

Backup selected tables

mysqldump -h <endpoint> -P 3306 -u <username> -p <db-name> <table-name-1> <table-name-2> <table-name-3> > backup-filename.sql

Restore

mysql -h <endpoint> -u <username> -p <db-name> < backup-filename.sql