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

Answered Moving A Site / Database Question

    • 32678
    • 290 Posts
    wpicotte Reply #1, 9 years, 2 months ago
    I'm moving a local site to a subdomain -- actually I'm overwriting the site on the subdomain with the local site, the latter being a more developed iteration of the former.

    When importing the database, I run in an sql 'table already exists error'. Obviously I have the wrong idea about this process -- I thought I simply could overwrite the existing database. I swear that's what I've done in the past.

    What is the correct process? Obviously I don't want to create a new database each time I upload a new site version?

    This question has been answered by BobRay. See the first response.

    • discuss.answer
      • 3749
      • 24,544 Posts
      BobRay Reply #2, 9 years, 2 months ago
      When you export from the DB to SQL, scroll down and check the "Drop Table if Exists" option. Then it will overwrite any existing tables. That option is off by default.
        Did I help you? Buy me a beer
        Get my Book: MODX:The Official Guide
        MODX info for everyone: http://bobsguides.com/modx.html
        My MODX Extras
        Bob's Guides is now hosted at A2 MODX Hosting
        • 32678
        • 290 Posts
        wpicotte Reply #3, 9 years, 1 month ago
        Quote from: BobRay at Mar 03, 2015, 05:44 AM
        When you export from the DB to SQL, scroll down and check the "Drop Table if Exists" option. Then it will overwrite any existing tables. That option is off by default.
        Thanks.