开发者

mysql dump runs, but does nothing

开发者 https://www.devze.com 2023-02-14 23:55 出处:网络
I am trying to restore a database using mysqldump, but nothing seems to happen.I get some output on the screen, but the program stops before it imports anything and does not report any errors.

I am trying to restore a database using mysqldump, but nothing seems to happen. I get some output on the screen, but the program stops before it imports anything and does not report any errors.

I am trying to restore a dump using the syntax

mysqldump --log-error=/root/dumplog --verbose --user=myuser mydatabasename < /root/dump.sql

I get no entries in the My开发者_如何学编程SQL log, and in dumplog, all I get is this:

-- Connecting to localhost...
-- Disconnecting from localhost...

The dump file is like 15mb


You don't use mysqldump to restore. To restore you would do:

mysql -uUser -p dbname < /path/to/file.sql
0

精彩评论

暂无评论...
验证码 换一张
取 消