I have a 56mb file on my web server, and I would like to (I think) use INFILE to load a filename.SQL file into mysql.
I don't really want to upload it because that will just take too long, but I would like to just use the local file on the system to import into mysql. The file contains the table creation instructions already so I don't need to specify the target, just execute the SQL as is in the file.
解决方案
The easiest way is to pass it in as a stream from the command prompt. Something like this:
mysql -u theuser -D thedatabase < filename.SQL