wordpress does not show me the pages that are in the database.

  • Since I made a hosting migration, and I migrated back to the previous hosting because the web was not working, WordPress does not show me the pages that are in the database. In the backend of wordpress I only see three pages, and in the database from phpadmin I see all of them. What can I do to see all the pages on my website in wordpress admin? only the home page is shown, the menu is broken and the pages do not appear even if I look for them by url.

    The page I need help with: [log in to see the link]

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

  • Sounds like a failed migration.

    How did you do the migration? Have you an earlier backup?

    Hello, ?how are you?, I’m Sebastian i will try to assist you to my best.
    Do you have a full backup from your previous hosting? it seems like you might need to do it all over again. But first, check if you have two wp_posts databases, in some cases the installation of wordpress ends up with different table prefixes, like wp4j_posts, this means that in such a case, you have a TABLE with 3 pages, and another one from your backup that has all the info that you had. Check if you have duplicate tables.

    Make a full backup of everything before following any instruction from internet.
    Once you broke your site, it’s easier to try and restore from a backup.

    This is how i export/import databases from wordpress:
    1_I go into phpmyadmin of the source i want to backup
    2_Then i select the database i need.
    3_Then i go into the upper menu and click export.
    4_I select everything default, and press go
    5_That file is downloaded as .sql, which i open with any text editor(sublime, atom) i search and replace all table prefixes, database name, for the new ones, and URL too if necessary.
    6_Finally in a new wordpress installation, you go into phpmyadmin, select the database and press import.

    I have to add, that if you don’t fully understand this, you should search for an easier solution like for example a plugin or php-script, because if you fail, you’ll end up with your site totally broken. I suggest you try and search for a tutorial in youtube.
    Regards-

    Thread Starter afreixedes

    (@afreixedes)

    Hi,
    I don’t have an earlier backup.

    In my phpadmin I only see one wp-post database.. so I think this is not duplicated. I don’t know what to do, because it seems that the conection of the database with the wordpress is broken, but I don’t know if I can fix it, or not…

    In the database it appears all the pages, but then inside wordpress doesn’t.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘wordpress does not show me the pages that are in the database.’ is closed to new replies.