Rename a MySQL database

Posted 8 years ago - updated 8 years ago mysql

You have to loop through all the tables and move them :(

Pre Mysql 5.1 you could write:

RENAME DATABASE x TO y

but this was removed so you have to loop through all the tables and rename each one individually.