mysqldump restore db syntax

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

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!

Re: mysqldump restore db syntax

Vadim wrote:

Quoted text here. Click to load it

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 :)

Site Timeline