Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

DROP and CREATE on Amazon RDS MySQL Instance

Is it safe to connect to my MySQL RDS Amazon instance and run a DROP and CREATE on the database (Basically re-create the database)?

Example:

DROP DATABASE <db_name>;
CREATE DATABASE <db_name>;

I am just worried that there are some background "fingerprints" that will be wiped, like the database backup etc.

like image 569
Koekiebox Avatar asked Oct 22 '22 21:10

Koekiebox


2 Answers

Due to the instance being reserved and not the database (or a database), all databases on the instance will be backed-up.

Watch out, only InnoDB tables will be backed-up on the Automatic backups.

like image 182
Koekiebox Avatar answered Oct 24 '22 11:10

Koekiebox


I don't think that could cause any trouble with backups.

like image 24
Everton Yoshitani Avatar answered Oct 24 '22 10:10

Everton Yoshitani