Rename a MySql database
This morning I needed to rename my database and found these three commands I’m going to show you:
mysqldump -u username -p -v olddatabase > olddbdump.sql
mysqladmin -u username -p create newdatabase
mysql -u username -p newdatabase < olddbdump.sql
[ source: stackoverflow.com ]
Tags: database, dump, mysql, restore
This entry was posted
on Sunday, January 10th, 2010 at 2:17 PM and is filed under tips & triks.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.