mysqldump restore db syntax

Hi!

I succesfully exported my locally stored db using the following syntax:
mysqldump -u root --password=111 finance > sqlbk.dump

Now I created another empty db finance2 (on the same Mysql server) and
try to restore their my finance db:

mysqldump -u root --password=111 finance2 < sqlbk.dump

Restore begins to run. I get all the "SET" lines printed, but nothing
is imported.

What am I doing worng?

Thanks a lot in advance!
Vadim

Re: mysqldump restore db syntax

Vadim wrote:

> I succesfully exported my locally stored db using the following syntax:
> mysqldump -u root --password=111 finance > sqlbk.dump
>
> Now I created another empty db finance2 (on the same Mysql server) and
> try to restore their my finance db:
>
> mysqldump -u root --password=111 finance2 < sqlbk.dump

mysql -u root --password=111 finance2 < sqlbk.dump

mysqldump is only for creating dumbs. For restoring the dump, use mysql.

Re: mysqldump restore db syntax

Many thanks to you :)