Howdy, Stranger!

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

Categories

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

Damian99Damian99 USAMember Posts: 116

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

Tagged:

Comments

  • DavidMDavidM USAMember Posts: 342

    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.