I may not understand the LOAD DATA LOCAL INFILE fully, but doesn't that require special security access? I'm trying to get this system to work off of a generic apache server out-of-the-box.
On Jan 24, 12:26 pm, "b logica" <[EMAIL PROTECTED]> wrote: > On Jan 24, 2008 11:14 AM, daphonz <[EMAIL PROTECTED]> wrote: > > > > > > > Hi Folks, > > > I'm trying to create a self-install routine for my web app, part of > > which requires it to create multiple tables with some pre-set content. > > > I use a system similar to that mentioned by Cakebaker, (http:// > > cakebaker.42dh.com/2007/04/16/writing-an-installer-for-your-cakephp- > > application/), which, for the most part, works fine. > > > The problem arises when I'm trying to load the SQL data into the > > database. The tables will load just fine, but there are content rows > > that contain serialized information. When it comes to executing those > > lines of code, (using the rawQuery routine, I get an MySQL syntax > > error. > > > Here's what I'm currently doing: > > > $statements = > > file_get_contents($fileNameOfSQLDump,'FILE_TEXT'); > > $db->rawQuery($statements); > > > I'm reasonably sure that the problem comes in on the first line of > > content that includes a serialized data string. Also, I've used this > > same SQL data to import through other programs such as PHPMyAdmin, so > > I know it's not a fundamental problem with the data itself. > > Can you execute the same statements using LOAD DATA LOCAL INFILE? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
