Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .