rename mysql schema

How can you rename a mysql Schema?


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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.