LOAD DATA INFILE fatal error encountered
You don't use LOAD DATA INFILE for what you are trying to do.

LOAD DATA INFILE loads a delimited text file (such as CSV) full of raw data, that is sitting on the server, into a table.

What you have is a dump file, which is full of queries -- not raw data.

You have three basic options:


use phpmyadmin to apply the file
use the mysql command line client to load the file
open the file yourself in your code (however you'd open a normal text file for reading), read each line in, and execute each line as a query from your code.


A dump file contains the queries to recreate data structures, so its contents are simply executed as queries.  That's what phymyadmin is doing when you "load" it that way.

If the file contains DDL that drops and creates tables, you'll have to do a little more work, because you'll need to buffer what you read from the file, and only execute what you've collected so far each time you find a line ending with the ; delimiter -- or any other delimiter that may be specified in the dump file (a line beginning with DELIMITER changes the expected delimiter for subsequent statements until a subsequent DELIMITER statement is found).  

But using the mysql.exe command line client on your local machine would probably be the easiest.

C:\&gt;mysql [options] &lt; "E:\Macdata\20131228\atelier.sql"


With a file structured like this, you can't specify what table it goes into.  If the file contains USE statements to change to the appropriate database, that will happen when those statements are encountered.  If it doesn't, you'll need to add the name of your schema right before the &lt; in the command line.