Fork me on GitHub
Please upgrade to 2.1.x here. The 2.0 branch is no longer being updated.
Important security fix: 2.1.10, released 4 May.

Is this a proper way to change Vanilla Forums database table prefix?

edited March 2012 in Vanilla 2.0 Help

Are the following steps correct?

  • First install Vanilla Forums by following this doc.

  • Rename the 32 main tables in the DB from gdn_tablename to customprefix_tablename. For example, you would rename gdn_activity to op2mro445_activity.

The SQL command to be used in phpMyAdmin would be:

Rename table wp_commentmeta to op2mro445_commentmeta;

  • Now open /conf/config.php inside the Vanilla Forums' root directory and add this:

$Configuration['Database']['DatabasePrefix'] = 'op2mro445_'; (as per the example)

right after this:
$Configuration['Database']['Password'] = 'samsak123';

My forum seems to be running fine after this. But I would still like to confirm — is it all?

Best Answer


Sign In or Register to comment.