On Jan 24, 2008 1:46 PM, daphonz <[EMAIL PROTECTED]> wrote: > > I may not understand the LOAD DATA LOCAL INFILE fully, but doesn't > that require special security access?
If you have shell access to the database you can use this command to load the data into a table. One needs to have the "FILE privilege" unless "LOCAL" is used. See here for all the dirty details: http://dev.mysql.com/doc/refman/5.0/en/load-data.html Alternatively (because i'm not entirely sure what you have in your file--raw data or SQL statements) you can connect to mysql from a shell and use this syntax: \. /path/to/your/file > I'm trying to get this system > to work off of a generic apache server out-of-the-box. > I realise that. What i mean is, can the statements in the file be run against a database without errors when doing so directly (ie. without PHP)? If you can't get shell access, can you load the contents of the file using PHPMyAdmin? The point is to ensure that your SQL syntax is ok to begin with. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
