Project Detail

CSV file to Mysql  

CSV file to Mysql is project number 143001
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: aryhdesign

Budget: $30-100

Created: 05/04/2007 at 1:29 EDT

Bid Count: 22

Average Bid:
$ 53

05/09/2007 at 1:29 EDT

Project Creator: darkmediak
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (38 reviews)

Bid On This Project
 

Description

I have a large .csv file (155-MB) from ip2location.com that I need to upload to mysql. I have uploaded the file to my server and tried to SSH in and dump it into the DB, but have run into problems. After uploading the file, in SSH I typed in the command:

mysql -uusername -ppass domainname_com_-_ipstate < IP-COUNTRY-REGION-CITY.CSV

I then receive the error, ERROR 1153 (08S01) at line 1: Got a packet bigger than 'max_allowed_packet' bytes

Now I have tried breaking the .csv into smaller sections, importing the file directly into mysql, and converting the file into a dump file – but still cannot get this file loaded into the mysql. If anyone has experience with this type of problem I could greatly use your expertise.

I have a dedicated Linux server running Apache/Ensim with PHP Version 4.3.9, Apache 2.0 Handler, Mysql 4.1.20.

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

100

0 days

05-04-2007 01:34 EDT

Hi, please, check your PM

help

 

100

3 days

05-04-2007 08:27 EDT

Hello, please refer your PMB. Thankyou.

help

 

65

0 days

05-04-2007 05:43 EDT

Hello, We have gone through your requirement. This is a very simple job and the code is ready. So we can deliver it in next couple of hrs. Please see PMB for more details about us

help

 

75

0 days

05-04-2007 05:04 EDT

Hello. Please check PM. Thanks.

help

 

50

0 days

05-04-2007 03:49 EDT

i've done this kind of project before. and no problem, i can help you. please PMB

help

 

30

0 days

05-04-2007 04:01 EDT

I have done the same job satisfyingly for myself several months ago. So I'd like to do it for you in low wage with high speed.

help

 

50

0 days

05-04-2007 03:46 EDT

I can help u, please check the PMB.

help

 

33

0 days

05-04-2007 05:40 EDT

Hello, Please check PM. Thanks

help

 

80

0 days

05-04-2007 02:29 EDT

Have experience and can make this. Make this before and know whan must be does.

help

 

30

1 day

05-04-2007 10:39 EDT

Please see PM for details.

help

 

50

5 days

05-04-2007 05:09 EDT

normally convert the CSV into an insert file type; means each line is converted to an INSERT statement.. can say that here as it needs a little experience to do that .. and its very time consumnig so i assume 5 days for the solution mhwse

help

 

50

1 day

05-04-2007 04:24 EDT

Please check PM for details. Regards

help

 

30

1 day

05-04-2007 04:06 EDT

This is a 5 minute job.

help

 

40

1 day

05-04-2007 03:57 EDT

Hi. I know exactly how to do it correctly. Let's start right away.

help

 

30

1 day

05-04-2007 07:48 EDT

Please check pmb. thanks.

help

 

50

1 day

05-04-2007 08:35 EDT

No problem, I can help you. You can't use "mysql bla-bla-bla < file.CSV". I know how to import CSV data to MySQL database.

help

 

30

1 day

05-04-2007 04:49 EDT

Hi. I can help you very fast with import this data to mysql server. Regards

help

 

60

1 day

05-04-2007 03:56 EDT

Kindly check your PM

help

 

65

0 days

05-04-2007 04:02 EDT

I have dealt with large dataset uploads a number of times.

help

 

45

2 days

05-04-2007 10:33 EDT

Hello, Please look into your PM. Thanks and regards

help

 

80

1 day

05-04-2007 03:54 EDT

(No Feedback Yet)

Hello, Pls chk your PM Best Regards

help

 

30

1 day

05-04-2007 06:08 EDT

(No Feedback Yet)

I have face such type of problem many times. Then i have made a PHP script. I can customize my PHP script for uploading any CSV file to mysql. i will work on this 3 hr daily.so it will take 2 to 3 days. My charge is 15$/hr. But i can do it in total 40$.

help


    Bid on this Project