[Susan Mills]

Hi Steven

Transferred my entire customized Connections setup from test site to live site (GrandBendTourism.com) today and have issues with categories.

I realize the hierarchy of categories doesn’t make it through this process or any other – but I had thought that the categories themselves would make the migration.

Using PHPAdmin, I’ve exported the Connections tables and imported them over – done this a few times now without success.

When I go into the Categories area of the Connections WP-Admin, it says there are 68 items BUT it does not display 68 items, in fact it only lists 12 categories (although all the ones it lists are top level categories). So I’m confused. Connections seems to understand it has 68 categories, but only shows 12. The remaining categories are sub-categories. I thought in the migration all I’d have to do is edit them to place them under the top level categories to re-establish the hierarchy, but it looks like I have to re-create them!

Also – when you go to the Manage area to view the listings themselves, each one clearly shows an assignment to both a top-level category and one or more of the sub-categories – so they exist in the database.

Why are they not showing in the Categories admin area?

Is there another table I should be exporting?

Please advise

Thanks

[Steven Zahm]

@ Susan

Sounds like you are not exporting all the tables. Make sure you export the following:

{table-prefix}_connections
{table-prefix}_connections_address
{table-prefix}_connections_date
{table-prefix}_connections_email
{table-prefix}_connections_link
{table-prefix}_connections_messenger
{table-prefix}_connections_meta
{table-prefix}_connections_phone
{table-prefix}_connections_social
{table-prefix}_connections_terms
{table-prefix}_connections_term_meta
{table-prefix}_connections_term_relationships
{table-prefix}_connections_term_taxonomy

Using the quick export settings for the SQL file is all that is needed in phpMyAdmin.

Before you reimport, make sure you drop the existing tables otherwise the term parent/child relationships will not be maintained due to the autoincrementing of the term ID column.

Hope that helps!

[Author]

Posts