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
精彩评论