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

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 USAPosts: 116Member

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

Tagged:

Comments

  • DavidMDavidM USAPosts: 342Member

    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.