Mysql Database Error You have an error in your SQL syntax

$30-250 USD

Closed

Posted

about 6 years ago

$30-250 USD

Paid on delivery

Hi Everyone, i have an error importing my MysQl database. I was using VestaCP and i exported the Database via PHPmyadmin then i reinstalled my server and installed vestaCP. But now when i try to import back that database i get this error ERROR 1064 (42000) at line 31734: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''C:24:"WPSEO_Sitemap_Cache_Data":152414:{a:2:{s:6:"status";s:2:"ok";s:3:"xml";s:' at line 2 Please help me out fix this.

Database Administration

Project ID: 16599279

About the project

17 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

17 freelancers are bidding on average $101 USD for this job

@octopus823

How are you? I am very interested in your project. I have much experiences about database, especially mysql rds. I will wait for your positive response. Best regard. Alex.

$155 USD in 1 day

5.0

(252 reviews)

9.2

@tlchung

I can fix the mysql database import issue for you. I am a skilled server admin with over 10 years experience.

$111 USD in 1 day

5.0

(498 reviews)

7.4

@dizajnerweb

Hello there. What is the size of your base? Is it big? Errors can occur when the database is large. then it's the only way to split it into more parts. Thanks, Marko

$155 USD in 3 days

5.0

(276 reviews)

7.3

@bjrupani

hello hiring member i am bhavika i have done this types job in my past i can make it sense so please give me chance to serve you thanks in advance

$250 USD in 3 days

5.0

(152 reviews)

6.7

@raisdhaka

Hello, I can import your sql file to your new host. Not sure on vistacp, but I am able to fix the issues at import sql. This issue occurs mainly due to difference on php version. Maybe your target and old host dont use same version of php. Let's me IN. Rais

$70 USD in 0 day

4.8

(218 reviews)

6.9

@mvaqasuddin

hi there, could you please share the FTP details along with cPanel so I will investigate right away in order to fix this issue. Thanks

$155 USD in 3 days

4.8

(219 reviews)

6.6

@thewebscraper

Hi, I can help you in your Database error. For sure it will be done in a few hours. Let me know and we can start right away! Time is very important for you and your business.

$60 USD in 1 day

5.0

(47 reviews)

6.1

@softcarve

Hi, I would like to fix the error you are getting in importing your sql file. Available to start now. please get in touch to discuss more. Regards, Manish

$30 USD in 3 days

4.9

(128 reviews)

6.3

@kripanidhi

I will fix your database error your with all the features and functionalities that you mentioned above. Completely frontend + secured backend + Fully Restful Want to discuss more in chat . Thanks

$150 USD in 1 day

4.9

(55 reviews)

5.8

@rehmatsayany

I am professional web developer and web designer . New to Freelance platform but very from programming. I have complete alot of local projects on laravel and WordPress. Now i want to do international projects, I have vast experience with HTML, Javascript, CSS, PHP and bootstrap and new to python programming. I can complete all your task on given time. Best Regards Rehmat Ali Sayany

$30 USD in 3 days

4.8

(16 reviews)

4.0

@chanPHP

I can do this job for you mate, I'm having 10 years of extensive experience for the same with mysql, phpmyadmin and database administration. please consider me for this project, I assure you for 100% job satisfaction. Ping me for further discussion.

$30 USD in 3 days

5.0

(11 reviews)

3.1

@yousefgehad97

let's go solve it...

$55 USD in 1 day

5.0

(2 reviews)

2.2

@isabelcnd

hi im working with mysql, postgresql and the corresponde app web for about 3 years, where you are working to see that database. Im pretty sure i can resolve that issue.

$55 USD in 1 day