• I imported a database from a backup from a different site. I can see the posts in the DB but when installing WP, they don´t appear. In fact, none of the pages, images or information stored in the DB appears. Help please!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Hi katykatdg,
    Actually I don’t know that if you know how to import a database of other website.

    Please open the database with a editor like notepad. and then replace all the previous domain name like http://www.olddomain.com to new domain like http:www.newdomain.com

    and then you can import to your new website.

    If you need more help please inform me.

    Regards

    There’s a second table to contend with called the wp_postmeta table. Both of those tables are needed for WordPress to recognize a database entry as a post.

    You probably should read up on the tables and working with them as this could possibly break your website.

    Most people use the WordPress Export/Import capabilities to deal with copying posts around from one site to another. Simpler and safer…

    Except sometimes the output file is too big. There are chunker/splitters out there that can divide a big output file if needed.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    @abir43tee You wrote “Please open the database with a editor like notepad. and then replace all the previous domain name like http://www.olddomain.com to new domain like http:www.newdomain.com”

    THAT IS WRONG.

    Never do that to fix a DB. Use a plugin like “better search replace” or the wp-cli command search-replace. The method you suggested will corrupt data fields that hold serialized data.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Posts in database don´t appear on wordpress’ is closed to new replies.