I had this exact same problem. First of all I had to upgrade to the latest version of mysql as a bug was fixed in earlier MySQL4 versions which made this time out.
Move the .sql file into your MySQL/bin folder (wherever you installed MySQL)
Then go to Start > Run > type 'cmd' > press enter
Now i'm going to assume you know your way around DOS and command prompt so navigate to the MySQL/bin directory (wherever you installed MySQL) and then type:
Quote:
mysql -uroot -p databasenameonlocalhost < filename.sql
It should prompt you for a password. If you have a global mysql password on localhost then enter it. Otherwise just press enter when it asks. It took me about 30mins IIRC to import a 200mb DB
07-28-2004, 10:16 AM
Threaded Mode