mysqlamazon-web-servicesamazon-rds

How to rename MYSQL database in RDS?

I have searched enough to find steps to rename a Database name in RDS MySQL and unable to find one. Can someone point to the place that has database renaming instruction on an RDS instance?

Solution

  • you can use mysqldump. Backup then restore database.

    mysqldump -h [aws-host] –u [UserName] –p[Password] –R [DB_Name] > [DB_Name].sql
mysqladmin -h [aws-host] –u [UserName] –p[Pasword] create [New_DB_Name]
mysql -h [aws-host] –u [UserName] –p[Password] [New_DB_Name] < [DB_Name].sql
mysqladmin -h [aws-host] -u [Username] –p[Password] drop [DB_Name]