Page 1 of 1

mysql import problems...

Posted: Mon May 29, 2006 4:56 pm
by silent assassin
ok, so I have a file full of email addresses. There's literally one address per line. Thats it. No delimiters, no other punctuation, nothing.

I need to get it into mysql and have absolutely no idea how to do it. Seriously, this is the layout of the file...


email@emailaddress1.com
email@emailaddress2.com
email@emailaddress3.com
email@emailaddress4.com

etc, etc....


phpmyadmin wont let me import it, says there's an invalid field count in the first line (where there's an email address).

Any ideas guys? I'll take anything at this point....

Posted: Mon May 29, 2006 5:25 pm
by hawleyjr
The reason phpmyadmin won't import it is because your table prob. has a int primary key. (Which is good)

Try importing it with a unique number and a comma

Code: Select all

1,email@emailaddress1.com
2,email@emailaddress2.com
3,email@emailaddress3.com
4,email@emailaddress4.com