Export and Import WordPress 3 Menu Structure?

  • I have a theme that has the WordPress 3 Menu Structure Enabled. I have 3 servers (2 testing servers, and 1 live/production server). I was wondering if there’s a plugin that can capture WP-3 Menus within the export and import tool.

    Also, I’m having some trouble with importing and exporting widget content…

    Any ideas?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Alas, no. Not yet, anyway.

    What follows here is untested, theoretical advice. Use at your own risk!

    MAYBE you could do a database copy, though I’m not sure of the fields or the table, but logically wp_1_options (for example) will have some settings for menus. Copy that field to wp_2_options and it MIGHT work.

    Widget content an options are all stored in the options table.

    So, here at least is how I accomplished this:
    1. I logged into phpMyadmin
    2. Exported entire “wp_options” table in current working menu database
    3. Imported sql file into new database (rename original file if need be by clicking on operations)
    4. Rename newly uploaded sql file to match name of old “options” table

    Alah Peanut Butter Sandwiches! It worked!

    Hmmm… I am withdrawing my previous peanut butter sandwich…

    I did not realize that now every link is being redirected back to test site rather the real domain….

    Probably those of you with actual experience saw this fatal flaw coming… Dang…

    Hmmm, Snuffy says we forgot to mention the unspoken assumption of “look over that SQL and fix any links before you import it”.

    ??

    I’d raise the caution that changing links might cause you to lose data, depending on where those links are.

    If the links are within serialized data in the options table (widget data is serialized), doing a simple search and replace will corrupt data and cause some things to not display properly.

    Here’s a script I’ve been using to change links without breaking serialized data: https://spectacu.la/search-and-replace-for-wordpress-databases/. This has helped me move data tables from one server to another, or one table to another, successfully.

    @tim I usually do my search & replace in a text editor on a dump of the SQL. :-/

    Andrea: yeah, I usually do that too. We had a big launch at my university and a bunch of websites lost data. Come to find out, they were using text widgets, which store all of their data serially, and the search/replace I did caused the text widgets to go haywire. I hadn’t had problems previously, though.

    metaprinter

    (@metaprinter)

    one of the options table fields is the website url. change it to reflect your url.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Export and Import WordPress 3 Menu Structure?’ is closed to new replies.