Resetting board

[AaronB]

Is there an easy way to reset the threads, last post notices on front page, number of posts, views, etc etc?? Basically all the stuff but the templates/forums/categories/replacements/anything else that is not user added.

I want to mess around with boards and hacks on my server, but be able to reset it to a clean board with out all my "tests" all over the place when I go live with it.

Any thoughts?

[thetakerfan]

I don't know how any changes made to the DB can be reversed, but if you reupload the original scripts and replace the existing ones, then delete all posts from the boards via the CP, shouldn't that work?

[Martin]

you can do a mysqldump on the original templates then, when you're ready to restore it to the original, just copy the original scrips over those you've modified and import the dumped template tables and you're back to the original without losing the posts.

[thetakerfan]

can you please tell me how to restore the templates table via phpmyAdmin, I have had no success whatsoever

[Martin]

from what I understand phpmyadmin is severely lacking in importing. I use NT, so it's easy for me to log on to my server and use DOS command lines to do it, but they're the same as telnet commands.

I've learned thru trial and error that you cannot import over existing tables, so what you have to do is delete the tables you're importing over (after a dump, of course) and then use telnet import the original back into the database.

[eva2000]

thanks scary stuff... how you you guys keep up with backups and changes ? i mean i backup each time i add a hack and rename the back to remind me of what the hack was... and instead of overwriting the php files and make a copy and rename it as backup and add new hack code into the copy file...

so in essence i have several copies of php files in my directory ready for instant rename/overwrites... what a headache ! :(

[Martin]

I have a vB folder on my desktop. Every time I add hack, I add a subfolder and copy the lastest hacked version in there to work on it, that way I can back up easily to the older hack.

Of course, it will be for **** when John comes out with the next major version...

[eva2000]

thanks martin... great tip which i will use :D

[Mike Sullivan]

FYI, phpMyAdmin 2.1.0 is out, and I believe that fixes the import bug. Not sure though, haven't tested it.

[thetakerfan]

I'll be sure to check that out later Ed

[Mike Sullivan]

(BTW, it's not officially released. Only beta. You have to go into the phpMyAdmin forum to find it.)