Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 05 Oct 2020, 09:16
Dr.CustUmz's Avatar
Dr.CustUmz Dr.CustUmz is offline
Join Date: Aug 2013
Real name: Ryan
Talking Reset DB Automagically (Timed Base)

So this was an idea that just popped in my head, I find myself re-installing vB ALOT. I have made a default test environment and SQL backup that I re-import every time that has preset users, forums and posts. What I was wondering though, is there a way to do this via a cron? Lets say I want my test board to go back to default every night at midnight.

Is there a script that exist on here? (I tried searching but my terms are returning too many results and I have yet to find anything.)

Or maybe I can create a script that drops all tables then reinstalls my backup (idk brainstorming here)

cron based (if option on)
push button to reset (confirmation msg)

So I read up a little on this
What I'm getting is the easiest way to do this is a server side cron, which would literally be as easy as adding my SQL to a cron and setting a time:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

that wouldn't let me control anything via vB admin though.

So more brainstorming here:
Fresh install on a new DB (add ALL desired content I.E. Users, Forums, Settings, Threads, Posts, ect.)(DO NOT INSTALL ANY PRODUCTS!) - This is to be a clean DB to copy DB info from.

Create a product that drops all default vB tables
Create and inset every row (could steal from install script?)
Insert default data (users, forums, threads, posts)
Insert data for the product we created (This will need to be "installed" with the "Fresh install" EVERYTIME so lets include it in our base install.)

Options in the CP (would this even be possible if were droping all tables?)

and thinking all of this, now has me thinking .....just use the install script.
If you need custom work done please use Dirt RIF CustUmz
Owner of vBTeam
vBulletin 3.8.14 DRC Edition PHP 7.4 Compatible- NOT a null, NOT complete files Requires a legit copy of vBulletin 3.8.11.

Last edited by Dr.CustUmz; 05 Oct 2020 at 16:27.
Reply With Quote

cron, database, demo, reset, time

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 21:34.

Layout Options | Width: Wide Color: