Cloned forum/database changing bburl of one affects both - what's going on?

[SToP_GAP]

So to sum up for anyone else in the same situation, this is what I did to clone the database:

Switch off the forum from the admin panel->options->Turn Your vBulletin On and Off

use mysqldump to copy out the existing database:

mysqldump -h [server_ip_here] -u [user] -p[password] [database_name_here] > liveforumdump.sql

(for most people, server_ip_here will just need to be localhost however if you are connecting to a database on a remote machine via an IP address this will need to go here)

copy the entire forum root folder, including owner and groups

cp -a /pathtosourcefolder /pathtodestfolder

If you forget to use the -a (archive) option then you may need to chown the files to the apache/lighttpd/(whichever webserver user) account on your system.

Next create a new database to house the duplicate in:
log in to mysql as root (or other suitably privileged user):

mysql -u root -p

From the mysql command prompt:

CREATE DATABASE cloned_forum_db_name;

Next give this account a new user:

GRANT ALL PRIVILEGES ON cloned_forum_db_name.* TO clone_user@localhost IDENTIFIED BY 'password_here';

Exit mysql prompt

quit

Now restore the liveforum.sql to the new database:

mysql -u root -p cloned_forum_db_name < liveforumdump.sql

Next you must edit clonedforumfolder/includes/config.php

Make sure that you change the following lines to match the user, database and passwords which you have used in the previous steps:

$config['Database']['dbname'] = 'cloned_forum_db_name';
$config['MasterServer']['username'] = 'clone_user';
$config['MasterServer']['password'] = 'password_here';

You may also need to alter:

$config['Misc']['forumpath'] = 'forum_root_path_here';
$config['Misc']['cookieprefix'] = 'cookie_prefix_here';
$config['Datastore']['class'] = 'vB_Datastore_Filecache';
$config['Datastore']['prefix'] = 'datastore_prefix_here';

It is possible that you will need to alter the cache type - if XCache was selected for example then both forums will be trying to share the same cache files and you will get the same conflicts that I wrote about earlier in this thread. In theory, simply changing the cache prefix should be sufficient to fix this.

You may also need to change the settings under:
admin->settings->options->Site Name / URL / Contact Details
if they don't automatically reflect the new path etc. that you enter in config.php

Finally, if you want to put this new copy in development mode you can set:

$config['Misc']['debug'] = true;

A reboot may be required but that should be all that you need to get your forum cloned to run as a development copy. I hope this helps someone else too.

Don't forget to switch your main forum back on afterwards!