Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product

Ready to contribute?

Amazing! Sign our contributors' agreement and then join us on GitHub.

Please upgrade to 2.1.x here. The 2.0 branch is no longer being updated.
Current version is 2.1.11, released 12 June.

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

Answers

Sign In or Register to comment.