CSV file to Mysql

$30-100 USD

Завершено

Опублікований

about 17 years ago

$30-100 USD

Оплачується при отриманні

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

ID проекту: 143001

Про проект

21 пропозицій(-ї)

Дистанційний проект

Активність 17 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@aryhdesign

Please see PM for details.

$30 USD за 1 день

5,0

(1 відгук)

1,0

21 фрілансерів(-и) готові виконати цю роботу у середньому за $54 USD

@NickolaS

Hi, please, check your PM

$100 USD за 0 день

5,0

(17 відгуки(-ів))

4,5

@VSmartTech

Hello. Please check PM. Thanks.

$75 USD за 0 день

5,0

(4 відгуки(-ів))

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 за 0 день

4,9

(3 відгуки(-ів))

3,6

@NishantBamb

Hello, please refer your PMB. Thankyou.

$100 USD за 3 дні(-в)

5,0

(3 відгуки(-ів))

3,7

@bclz

I can help u, please check the PMB.

$50 USD за 0 день

5,0

(2 відгуки(-ів))

2,9

@srajabather

Kindly check your PM

$60 USD за 1 день

5,0

(2 відгуки(-ів))

2,2

@kampasoft

Please check PM for details. Regards

$50 USD за 1 день

5,0

(1 відгук)

2,4

@robinbowes

This is a 5 minute job.

$30 USD за 1 день

5,0

(1 відгук)

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 за 0 день

5,0

(1 відгук)

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 за 5 дні(-в)