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:

Error

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

) TYPE=InnoDB AUTO_INCREMENT=11 ;

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é à :

WebInfoSolutions

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

20 $ USD en 1 jour
(154 Commentaires)
7.6

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

codinglogics

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)
7.3
usuf001

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)
7.0
machexport

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)
6.0
professional1248

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)
4.9
marveltech

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)
2.9
SynthFX

A proposal has not yet been provided

15 $ USD en 1 jour
(5 Commentaires)
1.5
greenusys

>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)
1.1
valtersbaumanis

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)
0.5
boladevelop

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)
0.0
eaikore

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)
0.0
dustinboike

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

15 $ USD en 1 jour
(0 Commentaires)
0.0
Mahmud6

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)
0.0
anggyariefin

A proposal has not yet been provided

30 $ USD en 1 jour
(0 Commentaires)
0.0
devalphp

A proposal has not yet been provided

15 $ USD en 1 jour
(0 Commentaires)
0.0