Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question

2 Answers 2

up vote 1 down vote accepted

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.

share|improve this answer

PHPMyAdmin has an option to rename a database:

enter image description here

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.