Tamamlanmış

CSV file to Mysql

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

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.

Beceriler: Linux

Daha fazlasını gör: insert file csv mysql command line linux, upload csv mysql, mysql ip2location import csv, csv file mysql php large size data fastly, upload large csv mysql, import csv directly mysql, large csv mysql, php script upload csv file mysql, uploading csv file speed, import csv mysql ssh, packet, mysql error, mysql 4, MB , file, file server, csv, csv php, csv file, apache large file, php upload file csv, tried, run linux command php, run command linux, php mysql dump csv

İşveren Hakkında:
( 178 değerlendirme ) Knoxville, United States

Proje NO: #143001

Seçilen:

aryhdesign

Please see PM for details.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(1 Yorum)
1.0

Bu iş için 22 freelancer ortalamada $53 teklif veriyor

NickolaS

Hi, please, check your PM

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(16 Değerlendirme)
4.5
VSmartTech

Hello. Please check PM. Thanks.

in %bids___i_period_sub_35% gün içinde75%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
3.9
NishantBamb

Hello, please refer your PMB. Thankyou.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
3.7
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

in %bids___i_period_sub_35% gün içinde65%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
3.6
bclz

I can help u, please check the PMB.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
2.9
kampasoft

Please check PM for details. Regards

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
2.4
srajabather

Kindly check your PM

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
2.2
robinbowes

This is a 5 minute job.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
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.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
1.0
wgromek

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
0.7
wit55

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
rawgrj

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

in %bids___i_period_sub_35% gün içinde65%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
kokosharov

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

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
yogeshjoshi1981

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 [login to view URL] it will take 2 to 3 days. My charge is 15 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
Ellemer

Hello, Please check PM. Thanks

in %bids___i_period_sub_35% gün içinde33%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
aneeshjoseph

Hello, Pls chk your PM Best Regards

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
rage0821

Please check pmb. thanks.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
dreamcorner

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

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
admont

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0