Recovering menu from database backup

  • I’m attempting to recover a menu that was lost when we moved servers. It wasn’t exported along with the pages/media/etc. As there was no option to do so.

    I’m looking in the database at the menu in question, but it’s missing data that I can’t seem to find.

    I found a site that helped a little here https://pinakin.me.uk/how-to-find-the-menu-data-in-the-wordpress-database/ but I’ve kind of hit a wall at this point.

    SELECT p.*
    FROM wp_posts AS p
    LEFT JOIN wp_term_relationships AS tr ON tr.object_id = p.ID
    LEFT JOIN wp_term_taxonomy AS tt ON tt.term_taxonomy_id = tr.term_taxonomy_id
    WHERE p.post_type = ‘nav_menu_item’
    AND tt.term_id = /*your menu ID*/;
    Running the above, modified to the ID of the menu & wp_siteid of the site I’m looking at. Produces the following.

    View post on imgur.com

    The post_names are just ID’s, I tried looking at the posts in Post and post meta but neither of them tell me the name of the dumb thing!

    How can I recover the names of the menu items?

    • This topic was modified 3 years, 1 month ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Recovering menu from database backup’ is closed to new replies.