Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using MySQL Workbench 5.2 CE, and I try to figure out how to populate or restore a


file uploaded to the root of my domain (./mysql_dump.sql).

Since the file is a little bit big (700MG) I wanted to restore it in a fast way, rather than using phpMyAdmin or Ozerov's BigDump.

I have shell access to the server through SSH, and I can connect to it using putty. But is there an easier way to do it using workbench? I'm not a super advanced database admin, just a beginner who trying to learn something ;)

share|improve this question
up vote 0 down vote accepted

If the database doesn't exist yet on the server create it in MySQL Workbench. Then run this command in the shell:

mysql -u #username# -p #database# < #dump_file#

It will prompt you for your database user password.

share|improve this answer
thank you citadelgrad, I accomplished this using putty and SHH. still didn't find a way to do it on workbench. – numediaweb Jul 11 '10 at 18:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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