Hi guys -
I know little to nothing about MySQL (all of what I know is dedicated to Microsoft...). I have a MySQL export file though that someone made me that's 91mb that won't open in workbench. (I downloaded the free windows client and database).
Workbench just freezes..crashes and then wants me to input a bug request. But I know the problem is because the file is too big since that's what would happen in MS SQL if I tried to open a 91mb sql file.
It's just a bunch of create/insert sql commands to create and load a database. I can open it in WordPad just fine.
I went here: http://www.experts-exchange.com/Database/MySQL/Q_24816755.html?sfQueryTermInfo=1+10+30+command+file+import+line+mysql
and I tried that but I have no clue where to type in those commands to make it work. I tried command prompt (Start > Run > cmd). And then I tried the MySQL command client. And then the shell inside Workbench and none of those imported the file.
In command prompt I just got "mysql is unsupported" and then there were syntax errors in the MySQL tools.
So .. how do I infact import this file?
Any help (stupid simple line by line since this is alien technology) would be super appreciated!
Thanks so much!