Solved

Importing Wordpress db to new site causes wp_commentmeta error

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
element on site jumps 4 47
Send current WordPress page in a URL parameter 3 48
reset email that plugins send alerts to 1 35
Custom Form Design to Match this example 1 14
What's this? As a volunteer Page Editor for Experts-Exchange.com, I have noticed that many authors also have blogs, and pull articles from their blogs to post at Experts-Exchange. I appreciate each author sharing their blog content with our site …
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…
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

929 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

16 Experts available now in Live!

Get 1:1 Help Now