loadData () error

[Slesh654321]

hi.
i can't seem to make the loadData() method work.
can u post an example of csv file?
i have a table with this structure:
id( autoincrement), a,b,c,d

and my csv looks like this:
"a";"b";"c";"d"

but when i try to load it i get an error:
Fatal error: Uncaught exception 'Exception' with message 'Unprepared Query Failed, ERRNO: 1045 (Access denied for user '####'@'localhost' (using password: YES))' in /home/admin/web/localhost.example.com/public_html/assets/db/MysqliDb.php:501 Stack trace: #0 /home/admin/web/localhost.example.com/public_html/assets/db/MysqliDb.php(1089): MysqliDb->queryUnprepared('LOAD DATA INFI...') #1 /home/admin/web/localhost.example.com/public_html/assets/csv.php(15): MysqliDb->loadData('test', 'Book1.csv', Array) #2 {main} thrown in /home/admin/web/localhost.example.com/public_html/assets/db/MysqliDb.php on line 501

the code looks like this:

$db = new MysqliDb ($dblogin); //initiate db object	
	$path_to_file = "Book1.csv";
	$options = Array(
	"fieldChar" => ';', 	// Char which separates the data
	"lineChar" => '\r\n', 	// Char which separates the lines
	"linesToIgnore" => 1	// Amount of lines to ignore at the beginning of the import
);
	$db->loadData("test", $path_to_file, $options);

thanks!

[VeNoMouS]

add the following to your options array...

'loadDataLocal' => true

Otherwise , you require FILE permissions on that user, and the file to be on the mysql server....

The LOCAL keyword affects where the file is expected to be found:

If LOCAL is specified, the file is read by the client program on the client host and sent to the server. The file can be given as a full path name to specify its exact location. If given as a relative path name, the name is interpreted relative to the directory in which the client program was started.

When using LOCAL with LOAD DATA, a copy of the file is created in the server's temporary directory. This is not the directory determined by the value of tmpdir or slave_load_tmpdir, but rather the operating system's temporary directory, and is not configurable in the MySQL Server. (Typically the system temporary directory is /tmp on Linux systems and C:\WINDOWS\TEMP on Windows.) Lack of sufficient space for the copy in this directory can cause the LOAD DATA LOCAL statement to fail.

If LOCAL is not specified, the file must be located on the server host and is read directly by the server. The server uses the following rules to locate the file:

• If the file name is an absolute path name, the server uses it as given.

• If the file name is a relative path name with one or more leading components, the server searches for the file relative to the server's data directory.

• If a file name with no leading components is given, the server looks for the file in the database directory of the default database.

In the non-LOCAL case, these rules mean that a file named as ./myfile.txt is read from the server's data directory, whereas the file named as myfile.txt is read from the database directory of the default database. For example, if db1 is the default database, the following LOAD DATA statement reads the file data.txt from the database directory for db1, even though the statement explicitly loads the file into a table in the db2 database:

$db = new MysqliDb ($dblogin);
$db->loadData(
    'test', 
    'Book1.csv',
    [
        'fieldChar' => ';',
        'lineChar' => '\r\n',
        'linesToIgnore" => 1,
        'loadDataLocal' => true
    ]
);