Re: LOAD INFILE

John Boy wrote: > Hi > > I want to upload a .csv file from my local pc to a mysql server. My local > machine is XP2. I have used the following but the file does not upload. When > using php MyAdmin it returns the error 'file not found'. Can anyone help? > > <?php > // Include our login information > include('db_login_master.php'); > // Connect - note: 'false' is 'no new link use existing' parameter and > '128' > enables LOAD DATA > $connection = mysql_connect($db_host, $db_username, $db_password,false,128); > if (!$connection){ > die ("Could not connect to the database: > <br />". mysql_error()); > } > // Select the database > $db_select=mysql_select_db($db_database); > if (!$db_select) > { > die ("Could not select the database: > <br />". mysql_error()); > } > // Import new avaiability data from local CSV file > $sql2 = 'LOAD DATA LOCAL INFILE \'C:\\\\EXPORT.CSV\' INTO TABLE > availability > FIELDS TERMINATED BY \';\' ENCLOSED BY \'"\' ESCAPED BY > \'\\\\\' > LINES TERMINATED BY \'\\r\\n\''; > // echo $sql2; > mysql_query($sql2); > echo '<p align="center"><font face="Verdana" > color="#0000FF">'; > mysql_query($sql0); > printf("Records added: %d\n", mysql_affected_rows()); > > echo '<p align="center"><B>UPDATE > COMPLETE</B></p>'; > > ?> > > Are you only passing the path to the "C:\\\\EXPORT.CSV" local file inside the query? You first need to upload the file. Either through a form or bu using FTP, SSH or something similar. More info about uploading files with PHP: http://php.net/manual/en/features.file-upload.php