I've been searching and searching my sql database in phpmyadmin but I can't seem to find where custom menus are stored in the database. Anyone know where it's stored? I have a large menu basically that takes forever to create. I'm in development now and rather than recreating it in production I want to try and copy the sql over to see if it works. Thanks!
I hate to bump a old thread. But if anyone runs into this like I did searching for the answer, as of WP 3.2 the post_type for menu is now called nav_menu_item in the wp_posts table. They didn't have that on the wp page, they just had nav_menu. Which I couldn't find.
Each menu item are saved in posts table and menu hierarchy/options/urls etc. belonging to these items are stored in postmeta table. In postmeta table you can see post_id column belonging to posts table items.