I am in the process of moving my site from another host. I have a *.sql file backup of the db that I need to restore. I created a db using the control panel, and then I've tried using the mysql workbench to restore, but it doesn't seem to give me the option to choose which db to restore to, and it errors. So what is the best way to restore my db from the old host into Winhost? Thanks
You may want to take a look at phpMyAdmin to restore your database to our environment. We have a forum post with instructions on how to set this up.
Try using mySqldump.exe http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html Very simple command line tool!!!