Database backup type thing

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • DWZ
    Senior Member
    • Jan 2002
    • 985
    • 2.2.9

    Database backup type thing

    We wont to make a backup of our database so we can make a test board and play around with settings and stuff.

    Now, the problem is the database is at around 150mb and there isn't room to have another 150mb database.

    So I figure it would be good if we could do a backup of everything except posts (as thats what's taking up the most room). I guess the database will be around 15mb then.

    So, my question is, how do I do a database of everything (including members) without posts?

    I want all forums to be copied over, just no posts in them.

    Is this even possible?
  • Cary
    Senior Member
    • Apr 2002
    • 4433
    • 3.6.x

    #2
    Try following the steps at http://www.vbulletin.com/manual/movingservers.html to backup your database.

    Before you restore it, open up the .sql file and remove all of the 'INSERT into POST' commands. Since your file will be 150MB, it'll probably take a while to open up that file...

    You want want to consider doing this to the attachments table also...

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...