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

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>