Posts Not Showing After Importing Database

  • anne29

    (@anne29)


    12 years, 7 months ago

    Hello, I’ve been looking through the forum for a solution to my problem and found a lot of similar threads but none that really help me solve my problem.

    I have two web hosts, I wanted to move one WordPress site to my second host so I exported my database using phpMyAdmin and zipped the root folder where the addon domain was.

    I then moved the WordPress files onto the second web host’s server root, created a new database, created a username and added it to that database then imported the sql file that was generated by phpMyAdmin after exporting previously.

    I edited wp-config.php so that it would use the new SQL database and username / password and it connected just fine.

    The website displays but only the home page is there, none of the content that was in the “Posts” section is there.

    I checked the database through phpMyAdmin on the second host where the sql file was imported and had a look at wp_posts and all the posts that should be there are listed and contain the correct information, only they’re not showing on WordPress or the website.

    Does anyone have experience with this and knows what could be going wrong?

Viewing 2 replies - 1 through 2 (of 2 total)
  • esmi

    (@esmi)

    12 years, 7 months ago

    Have you reviewed Moving_WordPress?

    Thread Starter anne29

    (@anne29)

    12 years, 7 months ago

    Hello, yes I have. The only part I wasn’t completely sure about was where it says “If you had any kind of rewrites (permalinks) setup you must disable .htaccess and reconfigure permalinks when it goes live.”

    I did have permalinks set up, I removed .htaccess , tried modifying it but it still comes up without posts showing.

    Should I have disabled permalinks before exporting the old database and then enable them again after importing? Could that be the problem?

    [Moderator Note: No bumping. If it’s that urgent, consider hiring someone.]

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

The topic ‘Posts Not Showing After Importing Database’ is closed to new replies.