I would like to know how to rename an existing DB locally.
I use XAMPP and myPHPyadmin as the MySQL.
| ||||
|
feedback
|
|
Using SQLyog, there is an option to copy the database to another host/database, not sure in myphpadmin but anyways you can dump the database to sql scripts, edit the scripts to change the name of the database, create the new database and load the scripts. | |||
|
feedback
|
|
PHPMyAdmin has an option to rename a database:
| |||
|
feedback
|
