Solved

Importing Wordpress db to new site causes wp_commentmeta error

Posted on 2015-01-14
3
413 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
  • 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

An earlier version of this article was originally posted on my personal blog at: ​http://www.brianjmatis.com/2014/07/07/enabling-nextprevious-post-links-in-wordpress/ Introduction In most blogs, a fairly common navigational element is to have li…
With Wordpress gaining more and more popularity not only as blogging platform but as a shopping or CMS solution, it's worth to know which plugins are the first ones to grab and integrate with your website. We will briefly go over the most useful plu…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

770 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