CREATE DATABASE /*!32312 IF NOT EXISTS*/ error when moving wordpress database

[Asmoday02]

Hi. I'm moving a wordpress website to another web host but when I try to import the database, I get this error message:

Error at the line 22: CREATE DATABASE /*!32312 IF NOT EXISTS*/ `WP_muammer_dogan` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

I've searched it on Google and found out that it is a hint to MySQL that the command only works in versions 3.23.12 or later but my mysql is much newer. Can you please tell me how I can fix this? I don't know anything about mysql and this is the first time that I'm moving a database. The website has cpanel. Thanks very much.

[jazzman1]

What db tool are you using to import the dump file?

[Asmoday02]

I've tried both phpmyadmin and bigdump. I got the same error message with both.

[jazzman1]

Open up the mysql command line and connect to the db server.

 

Then, execute a sql file using the "source" command.

// Example, If you're on unix environment

mysql> sorce /path/to/schema.sql;

// on windows 

mysql> SOURCE C:/path/to/schema.sql;