Database Help – Where is the nav menu stored?

  • Resolved wyndom

    (@wyndom)


    13 years, 10 months ago

    I’m locked out of my nav menu because of a bug that I’m trying to sort out. In the meantime I’d like to edit my nav menu through the database. I’m guessing this is stored in wp_options, but I’m not sure what the table name is.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Phil

    (@owendevelopment)

    Navigation menu’s are pulled from page and category names.

    Check the post_types table. Nav menu items are a kind of custom post type.

    Thread Starter wyndom

    (@wyndom)

    Wow, wouldn’t have guessed that mordauk. Looks like the names for the menus are stored in the wp_terms table. Thanks again!

    Hey, along the same lines does anyone know where in the databases one of the menus listed in wp_terms is selected for use as the primary navigation menu? I.e. how does wordpress know which menu to use for primary navigation? Thanks a lot!

    I’m not sure on that one, sorry.

    ytsmith2: with my theme, the information on primary and secondary menu is stored in a wp_option field called theme_mods_[plugin-name]. you should be able to find it with a query like this:
    SELECT * FROM wp_options WHERE option_name LIKE "theme_mods_%"

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Database Help – Where is the nav menu stored?’ is closed to new replies.