Re: Re-Importing .CSV file into Database
| From: | Thomas Edison Jr. | Date: | Wed, 13 Feb 2002 17:02:32 +0000 |
| Subject: | Re: Re-Importing .CSV file into Database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-84600@lists.php.net to get a copy of this message | ||
DL Neil,
OK buddy, let me be more than frank with you.. i don't
think i've been quite as confused and having the
expression "what the hell are you tryin 2 say" on my
lips in a while, as i had when i read your mail.
Hmm.. i do hope u can help me though..
T. Edison jr.
> Further to David's comment - the "mysql data
> directory" (without pathname) is the database's own
> directory (cf
> the directory of databases - if that makes any
> sense) - and any relative pathnames (obviously)
> lead on from
> there, so full pathnames are not necessarily
> necessary.
>
> Also, when I did an import last night:
> 1 it was not necessary to escape the double quote
> field delimiters (it is within single quotes)
> 2 because of the vagaries of Windows boxes, it was
> necessary to ensure the record terminators were
> treated
> consistently - either build the export file with
> only LF or instruct MySQL to use CRLF (as Jason put
> it to "be
> readable to the MySQL server daemon process thingy")
>
> Regards,
> =dn
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
=====
Rahul S. Johari (Director)
******************************************
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : abraxastech@yahoo.com
Tel : 91-4546512/4522124
*******************************************
__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com