We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

copying in elements by importing db tables

    • 14883 ☆ A M B ☆
    • 450 Posts
    jrotering Reply #1, 14 years, 6 months ago
    In the past I have managed to brute-force sync my elements between MODX installations by exporting database tables, emptying the table in the target MODX installation, and importing.

    Going from a 2.1.3 installation to a 2.2.0 installation, this worked with my plugins. But when I copied in snippets, templates, and TVs, I have been unable to see them in the tree.

    It might have something to do with categories... I also copied the categories and categories_closure tables. I can see the trees under templates, TVs and snippets contains all of the right categories it should... just none of the elements are showing up.

    Is there something new/different in 2.2 that I have to do?
      • 14883 ☆ A M B ☆
      • 450 Posts
      jrotering Reply #2, 14 years, 6 months ago
      I figured out why this was happening. The table structure has changed for several of the element tables in version 2.2.0. My export/import method ruined the new table structure and borked my installation. Need to reinstall from scratch, or at least restore the proper table structure to the tables I mucked up.

      (**kids, don't try this at home.**)