Need Help - Sql needed?

[Chris M]

One of our admins accidentally deleted one of our forums...

What query would I run to retrieve the posts from forumid 2, and transfer them to forumid 42?

If it could be done...

Satan

[scsa20]

hmm....I think all the post are wriped out, not unless you have a back up of the database before it happen

[Chris M]

Somehow I doubt we do...

So there is no hope?:(

Satan

[scsa20]

sorry man, usualy whatever was posted in the forum goes with it :(

[Chris M]

Damn...

Is there nothing you can think of that I could try??

Satan

[scsa20]

if you remember your old forumid, then you can go into PHPMyAdmin and see if you can find any post that links to that number and change it :confused:

[Chris M]

I am searching, but no luck sofar...

Satan

[Logician]

unbelievable but all of your Site Admins do more harm than good in your board.. Even a hacker wouldnt cause so many damage in your board your Admins did in the last 2 week.. oh boy..

[Xenon]

you should be more careful choosing admins....

also you should make more backups...

[Chris M]

We do have alot of Problems:(

I tried to make a backup yesterday morning, but the damned thing kept cutting out...

:(

Satan

[feldon23]

Sorry to hear about your forum issues.

I back up when I remember to, which is, scarily, only about once a month.

NEVER use the vBulletin interface to backup your forum.

Telnet into your server and type:

mysqldump --opt -uUSER -pPASSWORD FORUMNAME > DIRECTORYbackup04-05-2002.sql

replacing USER with the username, PASSWORD for your password, FORUMNAME with the mysql database name and DIRECTORY with your home directory on your FTP.

For example

mysqldump --opt -uelvis -pgraceland elvisimpersonatorsforum > /home/elvisimp/backup04-05-2002.sql

And you don't need all these forum admins. Frankly, I don't see the need for more than 1 forum admin unless it's just an enormous server. It's better to make everyone a moderator but give your login and password to a friend "just in case".

[Chris M]

Well...

I dont own the site...

There would be at least 2 Admins...

I am trying to work on a hack that will load one Control panel for myself and the Owner, and another panel for other admins, with less options...

Satan

[Xenon]

shouldn't be that hard, i have made an extra cp for my supermods, so they have more rights than normal mods (like template changing or something) but not those rights to change usergroupperms...

ok, you have to edit some files, but most of the time you can copy your ACP files ;)