By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

mysqldump restore db syntax

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
Many thanks to you :)

Apr 30 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.