Database Eror 21 about information schema

[pertagos]

I am trying to move my web site to any other web hosting firm. I coppy paste all folders to my new hosting account.

 

Somehow at the final step when I am trying to import my database to new server via BigDump (Staggered MySQL Dump Importer v0.35b) I am reciving the message follow. I can not solvee it.

 

 

Error at the line 21: CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Query: --

--

CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

MySQL: Access denied for user 'modancom_2'@'%' to database 'information_schema'

 

Do you have any idea?

 

Thanks

[PascalVG]

Hi Pertagos,

did you fix this already? Let us know before we spend some time on it. Thx.

(If you solved it, please tell quickly what you did, for educational purpose for others :-) )

 

Pascal.

[pertagos]

No i didn't solve it. Again same problem

[PascalVG]

Just a double check:

What value do you have for:

$db_server = ‘localhost’; <---- what do you have here??

 

And check (don't have to share, but check if correct!)

$db_name = ‘yourDBname’;

$db_username = ‘yourDBUsername’;

$db_password = ‘yourDBpass’

 

And make sure cAPiTAls etc are consistent .

 

 

Did you work with bigdump before? If so, did you got it to work fully at that time?

 

Looks like somewhere a configuaration setting, as import didn't even start yet...

[pertagos]

Thanks for your intrest Pascal I am trying it now.

[pertagos]

I have never tried to transfer any database before. I tried your suggest but, Unfortunatelly, Again I faced same error. The writer of bigdump sent me a message below:

 

Hello,

 

if your dump file contains multiple databases you can’t use Bigdump to restore it.

 

If it contains only one database you can configure Bigdump to ignore the CREATE DATABASE query by enabling this line in Bigdump.php. Just remove the heading double slash.

 

// $comment[]='CREATE DATABASE'; // Uncomment this line if your dump contains create database queries in order to ignore them

 

Alexey

 

And my database has got multiple databases, one is xxx, and other information_Schema

Edited April 28, 2013 by pertagos (see edit history)