En cours

Repair MySQL database for import into new site

I have a client site that i'm migrating and ran into a MySQL error when importing the DB. The table "wpxu_commentmeta" already exists but this error is persisting.

Upon request I will send the MySQL file.

Here is the complete error I receive on import via MySQL:


SQL query:

CREATE TABLE IF NOT EXISTS `wpxu_commentmeta` (

`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',

`meta_key` varchar(255) DEFAULT NULL,

`meta_value` longtext,

PRIMARY KEY (`meta_id`),

KEY `comment_id` (`comment_id`),

KEY `meta_key` (`meta_key`(191))


MySQL said: Documentation

#1064 - 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 'TYPE=InnoDB AUTO_INCREMENT=11' at line 9

Compétences : Administration de Bases de données, MySQL, PHP, WordPress

Voir plus : import database mysql phprunner, import database mysql virtuemart, import database mysql oscommerce, import database mysql webserver, import database mysql wordpress, mysql database locked repair, mysql import database, import database mysql

Concernant l'employeur :
( 7 commentaires ) United States

N° du projet : #12631399

Décerné à :


Please send the mysql file, It it fixable. No problem............................................................................

20 $ USD en 1 jour
(154 Commentaires)

13 freelance ont fait une offre moyenne de 34 $ pour ce travail


ready to fix this issue right away, I look forward to your response and will reply soon once I hear from you. Regards, Codinglogics

25 $ USD en 1 jour
(382 Commentaires)

Hi there, I can fix the issue with the database sql file And import it succesfully Thank you, Syed

25 $ USD en 0 jours
(483 Commentaires)

Hello Sir, We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us this Plus

210 $ USD en 10 jours
(7 Commentaires)

hy sir i am professional freelancer.I did more than 95 projects in last few months with 5 stars rating you can visit my profile i always give quality work on time so please contact with me i can handle this job for sur Plus

13 $ USD en 1 jour
(70 Commentaires)

Hi, Good day. This is Prabhu, from Marvel Technologies, Expertise in web design and development with successful and excellent track record of more than 6 years. We don't simply design and develop, we create desig Plus

25 $ USD en 1 jour
(5 Commentaires)

A proposal has not yet been provided

15 $ USD en 1 jour
(5 Commentaires)

>We are a team of 5 developers for web application and many more services and provide assurity for work completion on Defined time. >We have already worked on many projects as individuals. But now we established a Plus

25 $ USD en 1 jour
(2 Commentaires)

Hi, I am 100% sure I can solve this within 5-20 minutes. I have dealt with some very complex SQL code and database errors.

15 $ USD en 1 jour
(2 Commentaires)

Hi sir I am a professional web developer i will help you with solvin this mysql problem say Hi on the chat and lets get it done thank you

10 $ USD en 1 jour
(1 Commentaire)

Hi! I have encountered same error several times when carrying out installations that has to do with importing of database, the interesting part is that, I have always been able to fix these problems. Can still give Plus

15 $ USD en 1 jour
(0 Commentaires)

Autoincrement=1. .. Not Autoincrement=11 That should fix your issue.

15 $ USD en 1 jour
(0 Commentaires)

Hi, I’m dedicated professional Web and Desktop Programmer & Developer and freelancer only. I have been working with challenge and hope to improve future plan with good network every client. If any client want to get Plus

25 $ USD en 1 jour
(0 Commentaires)

A proposal has not yet been provided

30 $ USD en 1 jour
(0 Commentaires)

A proposal has not yet been provided

15 $ USD en 1 jour
(0 Commentaires)