We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 18913
    • 654 Posts
    Hi,
    I’m trying to backup an Evolution website to a local XAMPP install using the steps outlined here
    http://www.codeistry.com/help/uploading-downloading-and-backing-up-modx-sites

    But rather than just copy everything blindly over, I did a fresh unpack of Evolution 1.0.0
    into XAMPP, pointed to "install" and selected the advanced option. I had already created a new database in MYSQL and poured the backed-up MODX database into it (successfully).

    Specifying localhost, username and password and then selecting "test server connection" worked fine, bringing up the fields for the database. I made sure the database name, prefix, connection method and collation were the same as specified in the downloaded config.inc.php file from /manager/include (connection name only said "utf8" so I selected "utf8-general-ci").

    Testing the selection works fine, with the database passing. So I take the next page’s default recommendations of installing everything except the sample site and select "Install".

    Everything is okay up to the point where it is checking the table prefix. There, I get this message :
    Checking table prefix `modx_`: FAILED! - Table prefix does not exist in this database!
    
    Setup couldn't install into the selected database, as it does not contain existing tables with the prefix you specified to be upgraded. Please choose an existing table prefix, and run Setup again.


    Can anyone point out what I am doing wrong? Looking at the database structure in MySQL’s admin program shows 43 tables, with every one of them beginning "modx_". There were no reported errors in the creation, download or importing of the backup database and the website doesn’t have anything funky in it - it’s just a sandbox for testing out chunks, snippets, etc. (In other words, I’m not using the MODx database to also hold other non-MODx info ...)

    I did a search of the forums, but nothing came back that seemed relevant. Any help would be appreciated, as I’d like to have a relatively straightforward set of steps for transferring hosted <-> localhost.

    Thanks!
    Matt
      • 5340
      • 1,624 Posts
      Can you try with an empty DB?
        • 18913
        • 654 Posts
        That worked. So what I did was select new install, which obviously set up a new database and user. Then in MySQL I poured the old database in. (The assets folder had already been replaced).

        Not sure if this is relevant, but in the steps that *didn’t* work, I didn’t have a new user set up - I specified "root" and just a carriage return in the password field. That generated a successful test, bringing up the database fields as I noted. Then I was able to go to the next screen. But it didn’t bring up the fields to set up the admin user first, as happens when doing a new install.

        In any case, it seems to work. Thanks for the help...
        Matt
          • 22303 MODX Staff
          • 10,725 Posts
          You can’t run upgrade unless your existing config.inc.php file is already in place. The installer should not even let you select that option.
            • 18913
            • 654 Posts
            I think I had copied the old config.inc.php over to the new install, thinking that it would set up default values I could change during the install. In any case, while getting into the manager section works fine, just hitting the local version of the site doesn’t, giving me an error about not finding phx.parser.class.inc.php. It’s clear from the location it’s using, though, that I still have a reference - somewhere - to the old, hosted, location.

            I’ll dig through it a bit later...
            Matt