I’ve tried that, but I get an error.
Error
SQL query:
—
— Dumping data for table wp_ak_twitter
—
— ——————————————————–
—
— Table structure for table wp_commentmeta
—
CREATE TABLE 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 =176;
MySQL said:
#1050 – Table ‘wp_commentmeta’ already exists
Is there for instance any way I can just import the tables for posts, comments, etc?
Hi Tom,
There is at least one plugin that will allow you to import (WP-DBManager) but it may not work on all web hosts. The most reliable way to restore your SQL backup is by using phpMyAdmin, instructions can be found here:
http://codex.wordpress.org/Restoring_Your_Database_From_Backup
Hope this helps!
Are you trying to import this into an old WordPress database? Try importing it into a new blank database.
I’ve just emptied the database and then tried to import from my backup, as per the instructions on that link. But now I’m getting a “page cannot be found” error from my ISP.
Hi Tom,
From the error you are receiving, the wp_commentmeta table has already been created. If this was in error and that table doesn’t already have your data, you will need to drop the that table. You can drop tables within phpMyAdmin.
But now I’m getting a “page cannot be found” error from my ISP.
Where are you getting this error? When in phpmyadmin? wp-admin? frontend of your website?
@keesiemeijer: Getting that from the front end of my site.
Check if al the database information is still correct in wp-config.php
It’s gone really weird now. It displays my homepage, but seemingly without CSS and a lot of the content. Clicking any further brings up an ISP error like the one I was getting from the homepage earlier.
Try setting your site url to the correct url with the functions.php method:
http://codex.wordpress.org/Changing_The_Site_URL#Edit_functions.php