What kind of backup do you have? MySQL backup or did you do an export from the WP Tools menu?
Simple enough then. In your SQL file, you want to look for this
-- --------------------------------------------------------
--
-- Table structure for table 'wp_options'
--
CREATE TABLE IF NOT EXISTS 'wp_options' (
Everytime there is a new “Table Structure for…” heading, this is the start of a new database table. Find the ones you want, and delete everything else. Don’t delete anything in between the “Table structure for…” heading of the table you want to keep, and the next “Table structure for…”. This means don’t delete matching section like below
--
-- Dumping data for table 'wp_options'
--
You should be good after that.
Excellent. I’ll give it a go right now. Thank You!
Well, I tried. Issue is tons of syntax errors interrupting the works. Think I’m done for.
Thing I don’t understand, though, is when I imported the whole works (that crashed my new install) it accepted the import just fine. Now that I’ve left just the comments and posts, I get the syntax prob. Hmmm.
You have to make sure that the tables you want to import are either non-existent or empty, otherwise they will not import. I don’t know what syntax errors you’re getting, but I would start there, and see what happens.
Thanks, man. I’ll get after it. BTW, here’s the error message (one of many I’m sure). I understand your previous suggestion and will try it. Just wanted to see if the error message made any diff in strategy.
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Table: wp_posts
CREATE TABLE wp_posts
(
ID
bigint(20) unsigned NOT ‘ at line 1
Yeah… what I told you isn’t going to fix that, most likely. You’re possibly missing a comma, or have an extra one somewhere around
Table: wp_posts
CREATE TABLE wp_posts (
ID bigint(20) unsigned NOT
at line 1