If one has some nav menu items created from the admin panel like:
Where does one find this in the database?
mysql> select * from wproot_123_term_taxonomy; +------------------+---------+---------------+-------------+--------+-------+ | term_taxonomy_id | term_id | taxonomy | description | parent | count | +------------------+---------+---------------+-------------+--------+-------+ | 1 | 1 | category | | 0 | 10 | | 2 | 2 | link_category | | 0 | 7 | | 3 | 3 | category | | 0 | 0 | | 4 | 4 | category | | 0 | 4 | | 5 | 5 | category | | 0 | 7 | | 6 | 6 | category | | 0 | 0 | | 7 | 7 | category | | 0 | 14 | | 8 | 8 | category | | 0 | 12 | | 25 | 24 | category | | 0 | 1 | | 11 | 11 | category | | 0 | 0 | | 12 | 12 | category | | 0 | 0 | | 13 | 13 | category | | 0 | 0 | | 14 | 14 | category | | 0 | 12 | | 15 | 15 | category | | 0 | 2 | | 16 | 16 | category | | 0 | 0 | | 17 | 17 | category | | 0 | 0 | | 18 | 18 | category | | 0 | 1 | | 19 | 19 | category | | 0 | 0 | | 20 | 20 | category | | 0 | 1 | | 21 | 21 | category | | 0 | 10 | | 22 | 8 | post_tag | | 0 | 0 | | 23 | 22 | category | | 0 | 11 | | 24 | 23 | post_tag | | 0 | 0 | | 26 | 25 | category | | 0 | 1 | | 27 | 26 | nav_menu | | 0 | 1 | +------------------+---------+---------------+-------------+--------+-------+ 25 rows in set (0.00 sec) mysql> select * from wproot_123_terms; +---------+-------------------------+-------------------------+------------+ | term_id | name | slug | term_group | +---------+-------------------------+-------------------------+------------+ | 1 | Uncategorized | uncategorized | 0 | | 2 | Blogroll | blogroll | 0 | | 3 | ACCAP | accap | 0 | | 4 | AUTC | autc | 0 | | 5 | CEM | cem | 0 | | 6 | Finished Web Work | finished-web-work | 0 | | 7 | INE | ine | 0 | | 8 | INE Server Log | ine-server-log | 0 | | 25 | btop | btop | 0 | | 24 | IDT | idt | 0 | | 11 | PETE | pete | 0 | | 12 | policies and legalities | policies-and-legalities | 0 | | 13 | Pubs Database | pubsdatabase | 0 | | 14 | Research | research | 0 | | 15 | Roxen Pages | cem-roxen-pages | 0 | | 16 | smallTest | smalltest | 0 | | 17 | spec2 | spec2 | 0 | | 18 | Tech | tech | 0 | | 19 | To Do | to-do | 0 | | 20 | Training | training | 0 | | 21 | WERC | werc | 0 | | 22 | CDE | cde | 0 | | 23 | nulla quisque diam | nulla-quisque-diam | 0 | | 26 | My Stupid Menu | my-stupid-menu | 0 | +---------+-------------------------+-------------------------+------------+ 24 rows in set (0.00 sec) mysql> select * from wproot_123_term_taxonomy where taxonomy = 'nav_menu'; +------------------+---------+----------+-------------+--------+-------+ | term_taxonomy_id | term_id | taxonomy | description | parent | count | +------------------+---------+----------+-------------+--------+-------+ | 27 | 26 | nav_menu | | 0 | 1 | +------------------+---------+----------+-------------+--------+-------+ 1 row in set (0.00 sec) mysql> select * from wproot_123_term_relationships where term_taxonomy_id = '27'; +-----------+------------------+------------+ | object_id | term_taxonomy_id | term_order | +-----------+------------------+------------+ | 1933 | 27 | 0 | +-----------+------------------+------------+ 1 row in set (0.00 sec) mysql> select ID, post_type from wproot_123_posts where id = 1933; +------+---------------+ | ID | post_type | +------+---------------+ | 1933 | nav_menu_item | +------+---------------+ 1 row in set (0.00 sec) mysql> select * from wproot_123_postmeta where post_id=1933; +---------+---------+-----------------------------+-------------------------------+ | meta_id | post_id | meta_key | meta_value | +---------+---------+-----------------------------+-------------------------------+ | 995 | 1933 | _menu_item_menu_item_parent | 0 | | 1001 | 1933 | _menu_item_url | | | 1000 | 1933 | _menu_item_xfn | | | 999 | 1933 | _menu_item_classes | a:1:{i:0;s:11:"cdecategory";} | | 996 | 1933 | _menu_item_object_id | 22 | | 994 | 1933 | _menu_item_type | taxonomy | | 998 | 1933 | _menu_item_target | | | 997 | 1933 | _menu_item_object | category | +---------+---------+-----------------------------+-------------------------------+ 8 rows in set (0.00 sec)
