grs blog

rename mysql database using command line

—

by

dm
in

mysqladmin -u username -p create NEW_DB_NAME
mysqldump -u root -pPASSWORD OLD_DB_NAME|mysql -u root -pPASSWORD NEW_DB_NAME

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *