rename mysql schema

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

Leave a Reply

Your email address will not be published. Required fields are marked *

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