how to rename an existing database in MySQL localhost

3

2

I would like to know how to rename an existing DB locally.
I use XAMPP and myPHPyadmin as the MySQL.

tintincutes

Posted 2011-05-17T13:05:48.233

Reputation: 1 087

Answers

1

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.

laurent

Posted 2011-05-17T13:05:48.233

Reputation: 4 166

4

PHPMyAdmin has an option to rename a database:

enter image description here

Linker3000

Posted 2011-05-17T13:05:48.233

Reputation: 25 670

Asked: 2011-05-17T13:05:48.233

Viewed: 11 658 times

Active: 2011-08-17T05:10:12.413