Problem in Rename Database in Mysql

Question

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

paul daniel · Answer

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