Page 1 of 1
renaming database
Posted: Thu Feb 10, 2005 2:02 am
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
Posted: Thu Feb 10, 2005 2:13 am
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.
Posted: Thu Feb 10, 2005 2:15 am
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

Posted: Thu Feb 10, 2005 6:12 am
by MrKnight
try phpMyAdmin, it does exactly what feyd said