renaming database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
pleigh
Forum Contributor
Posts: 445
Joined: Wed Jan 19, 2005 4:26 am

renaming database

Post by pleigh »

hi there,

i would like to know if it is possible for me to rename a database in mysql??if yes, how can i rename it?

thanks

pleigh
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

not in one quick motion... it requires making an export of the tables in the database, dropping the database, creating a new one and finally importing the database's table information.

I don't see any other way.
User avatar
pleigh
Forum Contributor
Posts: 445
Joined: Wed Jan 19, 2005 4:26 am

Post by pleigh »

yah, that's what i thought so....i am using a mysql control center and i don't see anythiing that can modufy or rename the database. but thanks feyd for the reply :lol:
MrKnight
Forum Newbie
Posts: 22
Joined: Fri Jan 28, 2005 8:54 am
Location: Another Planet

Post by MrKnight »

try phpMyAdmin, it does exactly what feyd said
Post Reply