Solved

Importing Wordpress db to new site causes wp_commentmeta error

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Do you think that WordPress is just for blogs?  Think again!  WordPress is really a fantastic all around platform that you can use to develop websites on.  Integrated into its basic functionality is the ability to create pages using your choice of a…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

791 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