0

How to rename MySQL database name using Query?

Omar AbaHaji
  • 1
  • 1
  • 1
  • 3

1 Answers1

0

You can't rename. You can create one like existing database.

mysqladmin -u root -p mypassword create newdbname
mysqldump -u root -p mypassword --routines olddbname | mysql -u root -p mypassword newdbname
mysqladmin -u root -p mypassword drop olddbname
Osama Rizwan
  • 615
  • 1
  • 7
  • 19
Caner
  • 813
  • 1
  • 12
  • 26