0

How to rename MySQL database name using Query?

Omar AbaHaji
  • 1
  • 1
  • 3

1 Answers1

0

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

mysqladmin -uroot -pmypassword create newdbname
mysqldump -uroot -pmypassword --routines olddbname | mysql -uroot -pmypassword newdbname
mysqladmin -uroot -pmypassword drop olddbname
Caner
  • 685
  • 1
  • 11
  • 25