The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed.
This is used to mass data loading usually.
If you are in our shared hosting servers most probably you will not be able to run this comand.
Instead try using "LOAD DATA LOCAL".
The difference between the two commands is that without the LOCAL keyword the command requests the server to find the file and load data from it. With the LOCAL keyword, the MySQL client (your script, phpmyadmin, connecting from ssh, etc.) is what does the loading and then passes the data to MysSQL. As such, there is no special permissions needed for customers to do a "LOAD DATA LOCAL".
There are some alternatives to this:
LOAD DATA INFILE ALTERNATIVE FROM SSH:
$ echo "source databasefile.sql" | mysql -u user -ppassword dbasename
LOAD DATA OUTFILE ALTERNATIVE FROM SSH:
$ mysql -u user -ppassword dbasename > outputfile.sql
For further information please check the following link:
- 0 Users Found This Useful
How can i change the MySQL characters encoding to UTF8?
By default the encoding is latin1 but you could try to workaround your code. To change the...Oscommerce is showing a blank page in the categories pages
If you made no changes in your account or oscommerce script and this happened suddenly then there...I have the register_globals disabled server wide, how can i enable it in my account?
This option is available in all our shared cPanel hosting accounts.Please note if your script is...How could i change the PHP encoding in my scripts?
You could try changing it sending the headers in your php code, i.e.: header('Vary:...How do i parse .html files as .shtml (SSI)?
You can add the following line in your .htaccess file: AddHandler server-parsed .html or...