Posts in database don′t appear on wordpress

  • 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 https://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 https://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.