CSV file to Mysql

$30-100 USD

Completed

Posted

about 17 years ago

$30-100 USD

Paid on delivery

I have a large .csv file (155-MB) from [login to view URL] 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 < [login to view URL] 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.

Linux

Project ID: 143001

About the project

21 proposals

Remote project

Active 17 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@aryhdesign

Please see PM for details.

$30 USD in 1 day

5.0

(1 review)

1.0

21 freelancers are bidding on average $54 USD for this job

@NickolaS

Hi, please, check your PM

$100 USD in 0 day

5.0

(17 reviews)

4.5

@VSmartTech

Hello. Please check PM. Thanks.

$75 USD in 0 day

5.0

(4 reviews)

3.9

@CreativeB24

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

$65 USD in 0 day

4.9

(3 reviews)

3.6

@NishantBamb

Hello, please refer your PMB. Thankyou.

$100 USD in 3 days

5.0

(3 reviews)

3.7

@bclz

I can help u, please check the PMB.

$50 USD in 0 day

5.0

(2 reviews)

2.9

@srajabather

Kindly check your PM

$60 USD in 1 day

5.0

(2 reviews)

2.2

@kampasoft

Please check PM for details. Regards

$50 USD in 1 day

5.0

(1 review)

2.4

@robinbowes

This is a 5 minute job.

$30 USD in 1 day

5.0

(1 review)

2.0

@jesse0202

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.

$30 USD in 0 day

5.0

(1 review)

1.2

@mhwse

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

$50 USD in 5 days