Solved

Importing Wordpress db to new site causes wp_commentmeta error

Posted on 2015-01-14
3
477 Views
Last Modified: 2015-01-28
Hi Everyone,

I am having issues importing a wordpress db into my new hosting site.

I did import a non-wordpress db just fine so I know the user has permission.  Yesterday I imported a wordpress db into another website on the same hosting just fine after I edited the db with the correct name of the new db and character set.  

I read on a related post on this site that since wp_commentmeta is at the beginning seems the whole script is failing.  

Looking at the error message:
USE `mar3a_dawordpress;

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

--
-- Table structure for table `wp_commentmeta`
--

DROP TABLE IF EXISTS `wp_commentmeta`;
CREATE TABLE IF NOT EXISTS `wp_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`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2163 ;

--
-- Dumping data for table `wp_commentmeta`
--

INSERT INTO `wp_commentmeta` (`meta_id`, `comment_id`, `meta_key`, `meta_value`) VALUES
(2010, 595, 'akismet_pro_tip', 'discard'),
(2011, 596, 'akismet_result', 'true'),
(2012, 596, 'akismet_history', 'a:4:{s:4:"time";
MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'wp_commentmeta`
--

DROP TABLE IF EXISTS `wp_commentmeta`;
CREATE TABLE IF NOT E' at line 1

I am wondering if the askimet entries are giving me problems as the wordpress db I imported yesterday did that have those, much smaller wordpress site,  I need to deactivate the plugins before I export.

Thanks for your assistance.
0
Comment
Question by:dloj
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Accepted Solution

by:
dloj earned 0 total points
ID: 40550287
Upon working with the new hosting sites support we realized the wordpress db I was using was corrupt.  I exported a new one from the old hosting site and it imported fine.
0
 
LVL 11

Expert Comment

by:Ovid Burke
ID: 40553762
Glad you solved that problem. :)
0
 

Author Closing Comment

by:dloj
ID: 40574800
Because I solved the problem
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

WordPress is constantly evolving, and with each evolution appears to get better and better.  One of the big drawbacks prior to version 3 was that there was no way to be able to set up a custom menu from the backend. The Old Way Adding menus is…
In this blog, I will share you some basic tips for content marketing and to rank your website on Google.
This video teaches users how to migrate an existing Wordpress website to a new domain.
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question