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)