Page 1 of 1
mySQL dump
Posted: Fri Jan 10, 2003 6:49 am
by AGI1122
Would anyone with a message board(preferably YaBBSE but any board should do) with alot of members and posts be willing to do a mysql dump of the members, messages, topics, boards, and categories tables of their boards that way I can do some testing with
CBB. I need this that way I can test out how well CBB works with a fully populated board, and to get the speed results for it.
Re:mySQL dump
Posted: Fri Jan 10, 2003 8:31 am
by jrfritz
So you can have their passwords?
Re:mySQL dump
Posted: Fri Jan 10, 2003 8:45 am
by AGI1122
No I will not be able to get people's passwords because they use a 1 way encryption. In other words, passwords cannot be decrypted once they are encrypted(just about ALL message boards including mine use 1 way encryption to protect users passwords).
Re:mySQL dump
Posted: Fri Jan 10, 2003 1:40 pm
by df
email me priv. i have a dump of my board from when I looked at converting to phpBB
passwords are one way so nobody has to worry.
i wont dump private messages tho, just members + boards.
Re:mySQL dump
Posted: Fri Jan 10, 2003 4:18 pm
by AGI1122
The messages table is the posts, not the instant messages, I beleive the instant messages are stored in a table called instant_messages or something like that.
Emailing.
Re:mySQL dump
Posted: Tue Jan 14, 2003 3:38 pm
by AGI1122
Well the conversion went pretty good(a few glitches due to the converter but should be easy to fix) the posts from YaBBSE where 12MB in size, after converted to CBB they where 10MB so that is a very good difference.
The CBB total size is about 10 or 11MB while YaBBSE's was 14 MB. I consider this to be very successfull.
Now I know that CBB works well with a full board, the tests where done on a 1.7 Ghz pentium 4 processor and the speed was clocked at around 0.9 seconds on the boardindex, and compared to invisionboard, it had 0.9 seconds on it's empty board... so I guess that is pretty good.
Re:mySQL dump
Posted: Tue Jan 14, 2003 4:09 pm
by df
I want to install CBB and play with it (not go live or public).
I'm not worried about installers or setting it up with templates, etc. id just like to put it up where I can get a feel for it, give you some feedback, testing, etc
i've got a few ideas I want to mull over too....
Re:mySQL dump
Posted: Tue Jan 14, 2003 7:22 pm
by AGI1122
Sent you a pm through the board.