Correction of error (1064): Syntax error when downloading a .sql file
6 USD 
The most common type of error - (1064): Syntax error
The problem occurs when you download two .sql files, one 66 MB (250 thousand lines) and the other 25 MB (100 thousand lines).
The result of the download with errors is that less than half of the data from each file is uploaded to the database.
Purpose: 1) a list of errors (with explanations), after which correction will miss the downloading errors and the files will be 100% downloaded. Correction of errors and downloading two files into the database
To test the executor will be provided both the files and access to the database.
Client's review of cooperation with freelancer
Correction of error (1064): Syntax error when downloading a .sql fileThe work is done very professionally and in time.
Freelancer's review of cooperation with Viktor Litvin
Correction of error (1064): Syntax error when downloading a .sql fileI was happy to work with Victor again. Always in contact, clearly. I recommend !
-
Посмотрите кодировку базы, в которую переносите и из которой, видимо различны, та и всё
-
Или неэкранированных символов напхали.
-
я так же подумал, но вряд ли
ибо база откуда то переносится же, а как можно перенести изначально с ошибкой?) -
А ХЗ.
1. Первое и главное - неизвестно как ее экспортировали (напрямую из субд или это какая-то контруктора склеивала запросы).
2. Настройки самих субд. Можно настроить как угодно.
Например: " -
Не спорю, ваши аргументы очень логичны и я с ними согласен
Просто не кажется, что очень заковыристая проблема....скорее всего какая то банальность -
Согласен. скорее всего, да.
Но у меня обычно на ум приходи весь букет - дабы потом не было мучительно обидно за провтык. ))) -
Current freelance projects in the category Data Parsing
Parsing the YouControl website (Yukontrol)
27 USD
It is necessary to scrape companies from certain categories on the Yukontrol website, including 1) name 2) EDRPOU 3) manager 4) phone All this data is open. Data Parsing ∙ 40 minutes back ∙ 10 proposals |
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 4 days 3 hours back ∙ 18 proposals |
Creation of an Excel file for uploading products to the websites of other partners.I am interested in creating an Excel table with all parameters. Here is the website - https://heiztechnik.com.ua/ And the positions I am interested in to be transferred: Manual boilers: 1) TIS UNI 15-95 kW (10) pcs 2)TIS HARD 150-500 kW (7) pcs Pellet boilers: 1)TIS PELLET… Data Parsing ∙ 4 days 7 hours back ∙ 36 proposals |
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 4 days 10 hours back ∙ 41 proposals |
Find a product feed (Google Merchant XML) for a website on OpenCart
16 USD
It is necessary to find a direct link to the active product feed (XML) of a competitor for Google Merchant Center Platform (CMS): OpenCart / ocStore Find the original feedRequirements for the result: Working link to the XML file Python, Data Parsing ∙ 4 days 15 hours back ∙ 25 proposals |
Praha