CSV import to mySql

Hi,

I have this data given below as sample. Trying to import to mySQL is failing
everytime. There are more than 100 rows of data but when I follow the
procedure of phpMyadmin > databasename > tablename > click import tab from
top >choose the file (csv file) > Click on the CSV radio button on "Format
of imported file" area > put Fields terminated by ",", Fields enclosed by ",
fields escaped by "\" and Lines terminated by by "auto" (do not mention
anything in Column text box.

Doing the above first of all gives me errors "Invalid field count in CSV
input on line 7.". The number of rows is exactly the same in the table and
in csv. It does import but only 4-5 rows of data than all 100. Please
advice.

Also, what does it mean about "Overhead" in mySQL. Its size is increasing
and its showing in red.

Sample:

"Unistar Estates","Commercial","Property Dealers","Mall","NULL","Ground
Floor","NULL"
"Space and Finance","Commercial","Property Dealers","Mall"," Level 1","NULL"

Thanks in advace.
Chris
--
View this message in context: http://www.nabble.com/CSV-import-to-mySql-tf2766023.html#a77 13284
Sent from the Php - Database mailing list archive at Nabble.com.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: CSV import to mySql

Chris Carter wrote:
> Hi,
>
> I have this data given below as sample. Trying to import to mySQL is failing
> everytime. There are more than 100 rows of data but when I follow the
> procedure of phpMyadmin > databasename > tablename > click import tab from
> top >choose the file (csv file) > Click on the CSV radio button on "Format
> of imported file" area > put Fields terminated by ",", Fields enclosed by ",
> fields escaped by "\" and Lines terminated by by "auto" (do not mention
> anything in Column text box.

Sounds like something for the phpmyadmin guys to me.

http://sourceforge.net/mail/?group_id=23067

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: CSV import to mySql

Hi

Your example data does have an "invalid field count" The first row has has
7 fields, the other 6.

So if you took them from your actual data that's your problem

Niel

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php