Thanks for this Paul. I will be back to it in a few days and with your advice and the that from other wdvl-ers I should be able to see what I have failed to do. I will come back with notes of what I have done; it should help any others treading this path.
Joseph > Have a look at mysqlimport. This prog will import data from a flatfile > into a named table. Also check the > LOAD DATA INFILE command that may be of some help. > > What may be bogging you is the delimiters in the text file. > > 1. Check that every field is separated by a comma/space/tab - though > comma is better (You can create an 'export file' directly from excel by > saving as csv) > 2. Check that every field is enclosed in a pair of doublequotes - > recommended. What you NEED to verify at this stage is that NO field > contains a double quote itself as this would mean the end of the field > and throw the whole thing up. If you ever have double quotes in you > field, escape each double quote by \ - ex. > > "link 1", "<a href="http://www.link1.com";>", "this is a useful link" > > -- would become -- > "link1", "<a href=\"http://www.link1.com\";>", "this is a useful link" > > Then, in at the MySQL prompt run > > LOAD DATA INFILE 'myfile.txt' INTO table_name FIELDS TERMINATED BY , > ENCLOSED BY " ESCAPED BY \\ LINES TERMINATING BY \n > > Note that this assumes that myfile.txt is found in the database folder. > You could also specify the whole path. > > For more information on 'LOAD DATA INFILE' check section 6.4.8 of the > MySQL Manual > > Paul > > | -----Original Message----- > | From: Joseph, Smile Poet [mailto:[EMAIL PROTECTED] > | Sent: Sunday, January 11, 2004 8:07 AM > | To: [EMAIL PROTECTED] > | Subject: [wdvltalk] Re: entering data in MySql > | > | > | Bj, > | > | Easy is a ready-made combination of all the elements (php, MySql, > | Apache and whatever else goes into this particular pot). It > | installs very easily, but the documentation is a development or two > | behind and very dense. As I know no coding (having just tickled at > | it 20 years ago) I couldn't make out why I was failing to > | enter the data as all else seemed to have worked. > | > | I suspect I have a change to make in a config file (as David has > | guided me towards) and I'll follow up on that next. My 56 modem > | demands a local server for development; should my broadband day come > | and I crashed another server I should think it would send me > | to hide in a cave for years ;-). > | > | I have found the tutorials difficult because they are largely aimed at > | those with some knowledge though I have learned a bit from them. I > | now have a couple of tutorials which look about my level. Looking > | forward to working on them. > | > | Joseph > | > ----- Original Message ----- > | > From: "Joseph, Smile Poet" > | > > | > > I have spent five hours that I hoped would send me > | > > far up the learning curve trying to solve this. Has > | > > anyone a suggestion of where I might look for the > | > > answer. > | > > | > Start again properly? I have no idea what "EasyPHP" is about except > | that I > | > bet it ain't easy. I am running the Microsoft Personal Web Server > | that > | > comes on the Win98 CD as a local Web server for development/testing, > | along > | > with php which I got from PHP itself (www.php.net 'downloads' ), > | which was > | > pretty easy to install and run, and the mySQL I got from mySQL > | > (www.mysql.com) > | > > | > I think there's a distribution some others here use where you get > | Apache, > | > mySQL and php all in one? > | > > | > Of course having a local Web server is a bit less of an issue since > | I got > | > cable, as I can do devlopment and testing on the live site just > | about as > | > quickly as locally... although code errors that crash the server are > | just a > | > *little* more embarassing :o) > | > | > | > | ____ . The WDVL Discussion List from WDVL.COM . ____ > | To Join wdvltalk, Send An Email To: > | mailto:[EMAIL PROTECTED] > | Send Your Posts > | To: [EMAIL PROTECTED] > | To set a personal password send an email to > | [EMAIL PROTECTED] with the words: "set WDVLTALK > | pw=yourpassword" in the body of the email. To change > | subscription settings to the wdvltalk digest version: > | http://wdvl.internet.com/WDVL/Forum/#sub > | > | ________________ http://www.wdvl.com _______________________ > | > | You are currently subscribed to wdvltalk as: > | [EMAIL PROTECTED] To unsubscribe send a blank email to > | %%email.unsub%% > | > | To unsubscribe via postal mail, please contact us at: > | Jupitermedia Corp. > | Attn: Discussion List Management > | 475 Park Avenue South > | New York, NY 10016 > | > | Please include the email address which you have been contacted with. > | > | > | > > > ____ . The WDVL Discussion List from WDVL.COM . ____ > To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] > Send Your Posts To: [EMAIL PROTECTED] > To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. > To change subscription settings to the wdvltalk digest version: > http://wdvl.internet.com/WDVL/Forum/#sub > > ________________ http://www.wdvl.com _______________________ > > You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > > To unsubscribe via postal mail, please contact us at: > Jupitermedia Corp. > Attn: Discussion List Management > 475 Park Avenue South > New York, NY 10016 > > Please include the email address which you have been contacted with. > ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
