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.
|