469,645 Members | 1,984 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

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

Apr 29 '06 #1
2 36590
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.
Apr 29 '06 #2
Many thanks to you :)

Apr 30 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jerry T | last post: by
7 posts views Thread by Adam Smith | last post: by
reply views Thread by Adam Smith | last post: by
reply views Thread by mcstayinskool | last post: by
1 post views Thread by Rajesh Kapur | last post: by
6 posts views Thread by Robert Blackwell | last post: by
5 posts views Thread by Richard | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.