So you want to export your MySQL database then import it on the same server with a new name.
I tried this several times and using the SOURCE command inside MySQL or just mysql -p < db.sql both resulted in the database re-importing over the original name.
To fix that run:
sed -i 's/OLDDATABASENAME/NEWDBNAME/g' mysqldumpFile.sql
No need for a semicolon on the last line.
Then check the success by:
If you’re unfamiliar with MySQL you may be following a guide which instructs you to log in as root without actually telling you how; use the following:
mysql -u root -p
This logs you in as the root user (-u signifying which user you want to log in as) and -p signifies that you are logging in with a password, which you will be prompted for after you enter the command. The MySQL root password is set when you install MySQL server.
To create a simple database (e.g. if you need to create one for a WordPress or Wiki install) use the following after logging in to MySQL as the root user:
create database [nameOfDatabase];
Don’t forget the ; at the end, or you’ll end up on a new line consisting of a > prompt waiting for more input. You can put the ; in then if you forgot to complete the command. An example of the above would be:
create database wikiDB;
…which would create the database named wikiDB. You should see the following on a successful command:
Query OK, 1 row affected (0.04 sec)
If that is all you had to do you can now exit MySQL by typing:
…and you’re done!
If you need to change the MySQL root user’s password use the following from a command prompt:
mysqladmin -u root -p password NEWPASSWORD
Enter the current root password when prompted and replace NEWPASSWORD with the desired password. This should return you to the command prompt, and you can test whether it was successful by logging in:
mysql -u root -p