test board how should i do it ?

[eva2000]

well i have read so many of you all have a test forum to test hacks etc :D i neglected to do that when i installed my forum... now i have installed a test forum (private of course :)) with a separate database...

i want to use this forum to test all hacks and do a full customisation of the html and layout without worry about stuffing it up :rolleyes:

now i have created a new database called 'testforums' and installed 1.1.3 beta 3 in a new directory

i have my working vbulletin's latest mysql dump .sql file and want to import it into the test forum and continue my customisation through that and install hacks.

do i just do a import

mysql -u mysqlusername -p testforum < /home/user/htdocs/sql/backup.sql

[Martin]

yup, that should do it:)

[eva2000]

thanks... what about the php files that were edited on my working version ? i will have to copy them over the test forum's php files right ?

[eva2000]

well i tried an import of my sql file to the test database but it said error 1054, announcement table already exists... so i just created a 2nd test database and imported to that one...

problems now are
1. all the threads and forum urls in the test forum point to my real forum ?
2. on importing to the test version, all 248 members info was imported and i can see in the test version the active users listed... would this affect anything if i am hacking the tes version ?

[Martin]

yes

any hacks you have in your current board I assume you would want in the test board, too.

[eva2000]

Originally posted by eva2000
well i tried an import of my sql file to the test database but it said error 1054, announcement table already exists... so i just created a 2nd test database and imported to that one...

problems now are
1. all the threads and forum urls in the test forum point to my real forum ?
2. on importing to the test version, all 248 members info was imported and i can see in the test version the active users listed... would this affect anything if i am hacking the tes version ? so shoul di just update threads, search index and stuff to fix that ?

[Martin]

you need to delete the forum you have set up for your test board. you can't import over an existing forum.

[eva2000]

huh i am confused now, so does mean a test forum can not have data from my current working public forum ?

all i really need is the templates i made from my working version in my test version ?

so how do i delete ? the test forum now ? just remove the database and reupload original php files ?

[Martin]

um

lemme see if I can explain this simply...

delete your current database "testforums" from the mysql shell like this:

DROP database testforums

or you can just do a drop using phpMyAdmin

and do your import like this:

mysql -u mysqlusername -p testforum < /home/user/htdocs/sql/backup.sql

if you have already copied your hacked proggie files over there is no need to do anything to them

an import like you're trying to do will not overwrite an existing database, that's why you have to delete the one you have.

trust me. been there, done that:)

[eva2000]

darn... i did that first time round and it displayed all the links to my working forum :( so i deleted testforum database and redid the install to a new database named test2forum

i have uploaded the edited php files, updated all the stuff and now have all hacks installed... but the templates are the default ones from installation... oh well :rolleyes:

i thinking i am going to try every hack available now hehe... PM hack here we come ... :D

[Martin]

crap

I forgot you would need to change config.php to the new db info...

sorry...

[eva2000]

that's okay... i am going to dig into the old hack release threads now... so expect some of them to be bumped up if i stuff up :D