Back to MySQL command line after a long time

Its been a long while since i have actually used the mysql command line client..

Thanks to phpmyadmin which i have been using for the past 2 years.

phpMyadmin does many things without troubling me.

I had a problem renaming a database and I found out that mysql does not have rename database statement until MySQL 5.1.7.

so what to do ?

mysqldump came to the rescue as usual. I had to generate a dump of the current database.

Then create a new database with the desired name, and then import back the dump into the

new database , and then drop the old database.