We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 33238
    • 388 Posts
    Hello.

    i just need to copy the site structure and content from one page to other that is all, but i don want move anything more.

    the page with the content has several pages and subpages and i just neet replicate all the pages and content in a new site.

    i.m using Evo 1.0.4

    and i have an idea about the database but i dont know how to do that exactly.

    some ideas?

    thank you!!! grin
      --
      ysanmiguel.com
      • 33997
      • 150 Posts
      No settings or anything else? You want to get a copy of the ’site_content’ table of your database, by going into the backup manager. If your new site doesn’t have any content in it yet, then click the ’Create drop table statements’ part. If it already has content, then you want just the database table, but you’ll have to go in and change the ID numbers, which should be the first field. Start your first content entry with the number after your highest current database entry. But first, backup everything on both sites. If you use the MODX meta tags or anything like that you’ll need to grab those tables as well. You may want to make a copy of the ’site_templates’ table and the ’site_tmplvars’ tables as well, and maybe the ’site_tmplvars_access’, ’site_tmplvars_contentvalues’, ’site_tmplvars_templates’ tables also. Play around with it. If you aren’t sure about the syntax, google SQL queries.
        "Great spirits have always encountered violent opposition from mediocre minds." -Albert Einstein
        • 33238
        • 388 Posts
        my friend thanks for the long answer grin grin grin
        i will try that and i will thell you if that works.

        just one thing, were i can find the ’Create drop table statements’ huh undecided

        any way. thank you Very much!!! grin grin grin
          --
          ysanmiguel.com
          • 18373 ☆ A M B ☆
          • 3,141 Posts
          "Create drop table statements" is an option in PhpMyAdmin - a popular tool to access your database tables.

            Mark Hamstra • Developer spending his days working on Premium Extras and a MODX Site Dashboard with the ability to remotely upgrade MODX and extras to make the MODX world a little better.

            Tweet me @mark_hamstra, check my infrequent blog at markhamstra.com, my slightly more frequent ramblings at MODX.today or see code at Github.
            • 33238
            • 388 Posts
            i had problems :S

            ok... i copy every table that you told me.

            ’site_templates’ table and the ’site_tmplvars’ tables as well, and maybe the ’site_tmplvars_access’, ’site_tmplvars_contentvalues’, ’site_tmplvars_templates’ tables also.


            and is working because i can see the pages inside the manager, but not in the page, the page still has the default pages HOME-BLOG-FEATURES etc... and is not showing the pages that i see inside the manager, and the links are broken.

            thank you!
              --
              ysanmiguel.com
              • 33997
              • 150 Posts
              Try clearing the cache. Also, for future reference, Evo has a backup tool within itself, under ’Tools’, and that should have a check box that says something to the effect of create drop table statements.
                "Great spirits have always encountered violent opposition from mediocre minds." -Albert Einstein
                • 33238
                • 388 Posts
                Mate thank you very much!!!

                to resume the process.

                is just from MyPhpAdmin, export the tables:

                site_content
                site_content_metatags (i think this is optional)
                site_templates
                site_tmplvar
                site_tmplvar_access
                site_tmplvar_contentvalues
                site_tmplvar_templates

                - See attach image -

                Import this tables to the new modx, and clear cache from manager menu.

                That is all, this proces going to export all the content but NOT the snippets, chunks or plugins.

                and WORKS. grin grin grin

                Special thanks to: goonz
                  --
                  ysanmiguel.com
                  • 33997
                  • 150 Posts
                  You may not need all those tables the next time you do this, and if you ever notice that you are missing certain information, you may need to grab another table or two. But glad to hear you got it working! Nice going!
                    "Great spirits have always encountered violent opposition from mediocre minds." -Albert Einstein