Import excel table directly into mysql

Asked

Viewed 65 times

1

I’m using the following code to try to import 30,000 csv records into a comic on the hostgator server 

load data local infile 'public_html/empresa.csv' into table empresa
fields terminated by ';'
lines terminated by '\r\n'
(id_empresa,cnpj, empresa);

But make the following mistake:

#2027 - Malformed Packet

I’ve tried the panel in importing data, I have tried other commands, everything and I can’t. Can anyone help me? If you wish, step password and user to see what happens .

mysql database csv importing
  • 1

    MYSQL: ERROR 2027 (HY000): Malformed Packet

  • Unfortunately, I’m not going to be able to come up with the right answer, because there are all kinds of situations where that happens, just things that might help. First I saw that it is quite common to receive this error when using the LOAD DATA INFILE, you can try updating libmysql.dll, or how you are using the hostgator server to talk to them directly. I also recommend looking at this discussion can help a lot: https://dba.stackexchange.com/questions/102567/sql-error-2027-malformed-packet

  • If not even the HOSTGATOR this responding my request is a sign that I fucked up. Vlw , thanks

No answers

Browser other questions tagged mysql database csv importing

You are not signed in. Login or sign up in order to post.