Is it possible to quickly rename (schema name) a mysql database?

Can someone please explain me how to rename the schema name of a MySQL database?


  • You can use the following set of commands.

    mysqldump -u username -p -v olddatabase > olddbdump.sql
    mysqladmin -u username -p create newdatabase
    mysql -u username -p newdatabase < olddbdump.sql
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


In this Discussion