Can someone please explain me how to rename the schema name of a MySQL database?
You can use the following set of commands.
mysqldump -u username -p -v olddatabase > olddbdump.sql
mysqladmin -u username -p create newdatabase
mysql -u username -p newdatabase < olddbdump.sql
It looks like you're new here. If you want to get involved, click one of these buttons!