i just want to know how to rename mysql database name in mysql ... if u know than let me know its too urgent....
thanks in advance
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Naeem KhanPosted Jan 23, 2010, 12:55 AM
thanks in Advance
Kirtan PatelPosted Jan 16, 2010, 10:19 AM
Earlier version of mYsql having syntax
rename database db_name newname but its removed in new versions .as it has some problems with my sql so simply follow below 3 commandsRun this 3 commands at cmd
mysqldump -u username -p -v olddatabase > olddbdump.sqlmysqladmin -u username -p create newdatabasemysql -u username -p newdatabase < olddbdump.sql
if my answer helps you then please check "do you like this answer" check box :-)
Lalit MPosted Jan 16, 2010, 2:39 AM
One suggestion I encountered is to stop MySQL, locate the directory that holds your data (on my system, this is /var/lib/mysql/
more info