the Problem is, i want to use the "restore from sql dump" option, but when i try to execute it on the query i get the following errormessage:

Error occured at:2008-02-17 12:56:07
Line no.:0
Error Code: 1049 - Unknown database 'character'

Query:
Unable to issue `use` statement

What does this mean? how can i fix that?

thx very much!
Kobraha

P.S: Sorry my (written) english is very bad :-(

1)
One possibility: this DUMP does not contain the CREATE DATABASE statement. Did you check this option when exporting?

It looks like the 'use' option was checked but the 'create database' option was not. See attached image (6.16 export dialogue)

Click to view attachment

Try creating the database `character`manually before running the script.




2)
If there is not supposed to be a database named `character` at all, then to reply to this we will need more information:

>> What program was used for generating the DUMP file? SQLyog or something else? If SQLyog what version - if something else what then?

>> Server versions where you export and import.

>> Could you zip and attach a small example DUMP that throws this error?