snippetsqlMinor
Amazon: How to change database name in Amazon RDS MySQL?
Viewed 0 times
databasemysqlamazonnamehowrdschange
Problem
I want to change MYSQL database name of the DB instance of Amazon RDS.
How it can be possible?
How it can be possible?
Solution
you can rename the database using the following command but make sure to take backup first
references:
http://www.rndblog.com/how-to-rename-a-database-in-mysql/
https://stackoverflow.com/questions/12190000/rename-mysql-database
CREATE database new_db_name;
RENAME TABLE db_name.table1 TO new_db_name, db_name.table2 TO new_db_name;
DROP database db_name;references:
http://www.rndblog.com/how-to-rename-a-database-in-mysql/
https://stackoverflow.com/questions/12190000/rename-mysql-database
Code Snippets
CREATE database new_db_name;
RENAME TABLE db_name.table1 TO new_db_name, db_name.table2 TO new_db_name;
DROP database db_name;Context
StackExchange Database Administrators Q#76091, answer score: 7
Revisions (0)
No revisions yet.