I've been trying to restore a MySQL database for a while now

root@lsstreetwars1:/home# service mysql restart
mysql stop/waiting
mysql start/running, process 9609
root@lsstreetwars1:/home# mysql -u root -p forum > server.sql
Enter password:

It's just stuck here, and the database is only a few megabytes.

  • Do you have a backup of your server.sql file? The above command looks like it probably wiped it! Nov 29, 2016 at 23:01

1 Answer 1


you made a mistake by the direction of shell-redirect. Try this:

mysql -u root -p forum < server.sql
  • Hopefully he didn't already wipe the contents of his server.sql file by trying it the other way. Nov 29, 2016 at 23:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.