We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 47308
    • 68 Posts
    I'm trying to export my local database so I can move it to my server. But, I've been working with Modx for months now and I've managed to confuse myself with the multiple databases I have on my local MAMP server.

    In my core/config/config.inc.php file, I have the following entries:

    $dbase = 'modx';
    $table_prefix = 'revosandbox';

    When I go to PHPmyAdmin, I have:


    • modx
    • revosandbox

    When I open revosandbox, it has no tables. When I open modx, it appears to be the active database.

    I thought that if you specify a table prefix, the name of the database would be prepended by that name. So it should read:


    • revosandbox
    - modx

    Instead, I find that some of the tables have "revosandbox" in front of the name. For instance: revosandboxaccess_actiondom

    Now, if I back up the database and restore on my server, the "revosandbox" prefix is retained in the database and I really don't want "sandbox" to be part of a production database.

    How do I fix this? [ed. note: hhk222 last edited this post 9 years, 8 months ago.]