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 ---

Taidot: MySQL, PHP, WordPress, SQL, HTML

Tietoa asiakkaasta:
( 1 arvostelu ) Wamuran, Australia

Projektin tunnus: #32687128

Myönnetty käyttäjälle:


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

$60 AUD 1 päivässä
(77 Arvostelua)

13 freelanceria on tarjonnut keskimäärin $115 tähän työhön

(2040 arvostelua)
(312 arvostelua)

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

$30 AUD 7 päivässä
(115 arvostelua)

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 Lisää

$200 AUD 7 päivässä
(58 arvostelua)
(40 arvostelua)
(27 arvostelua)
(23 arvostelua)

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.

$155 AUD 3 päivässä
(9 arvostelua)

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 Lisää

$140 AUD 7 päivässä
(2 arvostelua)

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,

$140 AUD 2 päivässä
(3 arvostelua)

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 Lisää

$160 AUD 5 päivässä
(1 arvostelu)

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 Lisää

$150 AUD 7 päivässä
(1 arvostelu)