Loading

Problem in Rename Database in Mysql

Naeem Khan

hello friends,
well i have very big proble do you have any idea how can i rename database using mysql 5.1 .. i really dont have any idea how can i rename database... so please tell me i need ur help..
thanks in Advance

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

paul daniel16y ago
The RENAME DATABASE statement was found to be dangerously erratic and was removed in MySQL 5.1.23. Do not use it in any earlier versions in which it is present, as using it could result in loss of the database contents. Either backup
the DB and then re-import it, or you can try the command:

ALTER DATABASE db_name UPGRADE
DATA DIRECTORY NAME

for more details click here
0