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

Here is the DB table:

-- Table structure for table `wpxu_commentmeta`
--

DROP TABLE IF EXISTS `wpxu_commentmeta`;
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 ;

--
-- Dumping data for table `wpxu_commentmeta`
--

INSERT INTO `wpxu_commentmeta` (`meta_id`, `comment_id`, `meta_key`, `meta_value`) VALUES
(1, 1, '_wp_trash_meta_status', '0'),
(2, 1, '_wp_trash_meta_time', '1480116105'),
(3, 3, '_wp_trash_meta_status', '0'),
(4, 3, '_wp_trash_meta_time', '1480481593'),
(7, 5, '_wp_trash_meta_status', '0'),
(8, 5, '_wp_trash_meta_time', '1482080986'),
(9, 2, '_wp_trash_meta_status', '1'),
(10, 2, '_wp_trash_meta_time', '1482080986');

-- --------------------------------------------------------

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

Voir plus : import database mysql phprunner, import database mysql virtuemart, script php export import database mysql, upload xml import database mysql script, import manage mysql database via joomla site, import database mysql oscommerce, import database mysql using ssh, import database mysql database, import database mysql webserver, import database mysql wordpress, import mysql database mysql database, mysql howto import database ssql, mysql database locked repair, mysql import database, import database mysql

Concernant l'employeur :
( 8 commentaires ) St. Johnsbury, United States

N° du projet : #12631399

Décerné à :

WebInfoSolutions

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

20 $ USD en 1 jour
(171 Commentaires)
7.7

11 freelance ont fait une offre moyenne de 37 $ pour ce travail

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
(583 Commentaires)
7.3
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
(422 Commentaires)
7.4
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
(131 Commentaires)
6.3
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.1
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
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
(6 Commentaires)
2.6
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
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