Solved

Importing Wordpress db to new site causes wp_commentmeta error

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Wordpress Horizontal Drop-Down Menu In this tutorial I will show you had to add a WordPress horizontal navigation menu to your theme. I have searched and searched for a good tutorial on creating a WordPress nav menu without adding a plug-in or us…
Nowadays, it is so easy to get started with a website and all thanks to the Content Management Systems (CMS) like WordPress, Drupal, Joomla, and many others like them. However, if we talk about the reliability and ratings, WordPress definitely rules…
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…
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…

759 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now