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:
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:
- 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.]