Export MYSQL / RDS

Export MYSQL with mysqldump Command

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 

Backup untuk single database

mysqldump -u root -ppassword wpdb > wpdb_backup.sql

Backup multiple database

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

Backup all database

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

Backup only structure table

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

Backup specify table

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

sources: https://snapshooter.com/learn/mysqldump-ultimate-guide