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.

Update for critical security issue in PHPMailer included in release Vanilla 2.3.1
Please upgrade to 2.3 here. The 2.2 and earlier branches are no longer being updated.

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

edited March 2012 in Vanilla 2.0 - 2.2

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.