rename mysql schema

November 15, 2011

How can you rename a mysql Schema?

easy!

Create the new schema

In this example the new schema is called my_new_schema

mysqladmin -u root -p create my_new_schema

Dump the old schema and pipe in to new schema

mysqldump -u root -p old_schema | mysql -u root -p my_new_schema