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

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/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (38 reviews)

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.

Report Violation

Job Type

Linux

See more: apache, csv, dedicated, error, file, linux, linux server, mysql, php, server, ssh, type, upload, uploading

Messages Posted:0

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

PMB

100

0 days

05-04-2007 01:34 EDT

9.9898/10
(393 reviews)

Hi, please, check your PM

NishantBamb

100

3 days

05-04-2007 08:27 EDT

9.9239/10
(184 reviews)

Hello, please refer your PMB. Thankyou.

CreativeB24

0 days

05-04-2007 05:43 EDT

9.8438/10
(32 reviews)

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

VSmartTech

0 days

05-04-2007 05:04 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(31 reviews)

Hello. Please check PM. Thanks.

dreamcorner

0 days

05-04-2007 03:49 EDT

9.9655/10
(29 reviews)

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

jesse0202

0 days

05-04-2007 04:01 EDT

9.5238/10
(21 reviews)

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.

bclz

0 days

05-04-2007 03:46 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(12 reviews)

I can help u, please check the PMB.

Ellemer

0 days

05-04-2007 05:40 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(11 reviews)

Hello, Please check PM. Thanks

kokosharov

0 days

05-04-2007 02:29 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(6 reviews)

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

aryhdesign

1 day

05-04-2007 10:39 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(6 reviews)

Please see PM for details.

mhwse

5 days

05-04-2007 05:09 EDT

9.1667/10
(6 reviews)

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

kampasoft

1 day

05-04-2007 04:24 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(5 reviews)

Please check PM for details. Regards

robinbowes

1 day

05-04-2007 04:06 EDT

9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10 9.75/10
(4 reviews)

This is a 5 minute job.

wit55

1 day

05-04-2007 03:57 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(3 reviews)

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

rage0821

1 day

05-04-2007 07:48 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(2 reviews)

Please check pmb. thanks.

admont

1 day

05-04-2007 08:35 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(2 reviews)

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.

wgromek

1 day

05-04-2007 04:49 EDT

9/10 9/10 9/10 9/10 9/10 9/10 9/10 9/10 9/10 9/10
(2 reviews)

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

srajabather

1 day

05-04-2007 03:56 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Kindly check your PM

rawgrj

0 days

05-04-2007 04:02 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

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

tomkus

2 days

05-04-2007 10:33 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Hello, Please look into your PM. Thanks and regards

aneeshjoseph

1 day

05-04-2007 03:54 EDT

(No Feedback Yet)

Hello, Pls chk your PM Best Regards

yogeshjoshi1981

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$.

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.