Anyone know what the command is to load an external document into mysql? I have the script.sql that I spent quite a while typing up but can't remember how to get that to run.
Thanks for answering...I am just using the localhost. I can't even open mysql from the dos command prompt. I can open it from the actual sql on the start menu. I am not using a gui to interface right now. Got any ideas?? I have put the path in my computer to the mysql file and bin...c:\mysql\bin...I don't know what else to do. HELP!!
If I type in the path that you gave, it gives me an error of "mysql is not recognized as an internal or external command, operable program, or batch file.
I have no problem using mysql, I just am having a problem being able to load a script and I think that it has to do with not being able to open it from the command line.
Unfortunately, 99% of the time, I'm running mysql from the command line via an SSH session, so I rarely run it on Windows. You might want to confirm that the mysql.exe executable exists.
Other than that, try out MySQLCC. It's a nice product.