Fix MySQL file syntax error + adapt to MySQL 5.7

Here is the issue we have the sql database file we're trying to connect to this WordPress site. This has been supplied by our hosting provider:

--- start of host's communication ---

We reviewed the case and attempted to import the provided .SQL file ([login to view URL]) into a new database (db97vgmrg1lrjr). The import process itself failed returning a syntax error.

The error message suggests that the issue is due to the formatting of the MySQL file and its syntax. The exact issue appears on line 25039 and it is best that the issue is reviewed and corrected by an experienced MySQL specialist who knows how to adapt the database to work on this MySQL server. Keep in mind that we use MySQL version 5.7, so the .SQL file will have to be adapted accordingly. Unfortunately, we will not be able to assist you on this any further as the issue is specific to the MySQL code which is not something we can correct on our end."

--- start of host's communication ---

Compétences : MySQL, PHP, WordPress, SQL, HTML

Concernant l'employeur :
( 1 commentaire ) Wamuran, Australia

Nº du projet : #32687128

Décerné à:


Hi there im software eng and system administrator i know this issue its a version issue i can fix it right now contact me

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% AUD en 1 jour
(77 Commentaires)

13 freelances font une offre moyenne de 115 $ pour ce travail

(2040 Commentaires)
(312 Commentaires)

I have some queries regarding the specifications of the project. Could we please have a word? My Skills: WordPress, SQL, MySQL, PHP and HTML

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(115 Commentaires)

Hi, I have checked your project requirement regarding that you need to fix MySQL file syntax error + adapt to MySQL 5.7. I have more than 6+ years of experience in web development and design. I'm an expert in Wordpress Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(58 Commentaires)
(40 Commentaires)
(27 Commentaires)
(23 Commentaires)

Hi there. I've gone through your post. I am very proficient in doing HTML, CSS, javascript, jquery, PHP, MySQL. I have many years experience in WordPress migration. Thank you. Luis Carlos.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(9 Commentaires)

I am a well-experienced db query maker. I have read your project description with great interests, so that I feel 100% sure on it. I promise A+. I can get started right now and keep your timeline. I hope your kind mess Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(2 Commentaires)

Hi, Client. As web developer, I have many experiences with MYSQL and PHP for 10+ years. I can complete your task perfectly. Please contact me and share your more details. Regards,

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(3 Commentaires)

Hi, We will Fix MySQL file syntax error + adapt to MySQL 5.7 ) into a new database (db97vgmrg1lrjr). We are the team of senior web developer with extensive development background. We have more than 10 years of develop Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(1 Évaluation)

Hello dear, I am not a MySQL specialist, I am a web developer. I have encounter such error before, while importing a backed up database from pc, and I believe with the same way I was able to solve the issue, I will so Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(1 Évaluation)