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.

Published by

Varun Krish

Varun Krish has been dabbling with computers and websites for almost 2 decades. He has traveled to over 30 countries and hopes to visit every country on earth one day. He is currently the Editor-in-Chief of FoneArena.com and also advises startups and product companies on how to build better products. You can follow him on @varunkrish

Leave a Reply

Your email address will not be published.