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?

Comments

  • 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!

Categories

In this Discussion