emergency....... need help ASAP

[Brad]

Originally Posted by wreck

ive got it.. i run the query and it worked... thanks alot, really really appreciate it

No problem, just make sure you get rid of him before it happens again, you might want to have all of your staff change their passwords aswell.

vB3 is alot better when it comes to the admin cp as you can restrict admins to certain area's of it and prevent them from editing other admin acounts. Good luck, hope he did'nt do anything like prune all of your posts.

[wreck]

argh he deleted alll the posts

[Brad]

You have a backup of the database right? Restore it

[LostStyles]

yes, we have a backup...but everytime i try to restore it...my browser seems to crash...i try through the cpanel..that i get from my host...is there any other way? or is that the only way?

thanx

[Brad]

Ah, its to big to upload in one shot, do you have telnet access?

If not use this script, it'll restore it in sections to prevent the timeout errors.

http://www.vbulletin.com/forum/attac...achmentid=8933

Make sure you configure it as so:

PHP Code:

// THIS SCRIPT IS PROVIDED AS IS, NO RESPONSIBILITY FOR ANYTHING

// USAGE:

// 1. Adjust the database configuration in this file
// 2. Drop the old tables on the target database if your dump doesn't contain "DROP TABLE"
// 3. Create the working directory (e.g. dump) on your web-server 
// 4. Give the scripts writing permissions on the working directory (set permissions to 777 on a Linux
//    based system) if you want to upload the dump files from the web-browser
// 5. Upload bigdump.php and your dump files (.sql, .gz) via FTP to the working directory
// 6. Run the bigdump.php from your browser via URL like http://www.yourdomain.com/dump/bigdump.php
// 7. BigDump will start the next import session automatically if you enable the JavaScript
// 8. Wait for the script to finish
// 9. Remove your dump files from the web-server

// If Timeout errors still occure you may need to adjust the $linepersession setting in this file

// Database configuration

$db_server="localhost";
$db_name="";
$db_username="";
$db_password="";


// Other Settings

$filename="";              // Specify the dump filename to suppress the file selection dialog
$linespersession=3000;     // Lines to be executed per one import session
$delaypersession=0;        // You can specify a sleep time in milliseconds after each session
                           // Works only if JavaScript is activated. Use to reduce server overrun 


[LostStyles]

i see, so basically, what i do is change things like db_name: what it is... etc..

but the $filename=""; Is that the filename of what the database is called yes?

and where do i upload this file to to run it from?

[Brad]

Upload it to anywhere on your webserver, I recomend making a new folder for it.

Make this folder in your public_html directory:

/mysqldump/

Upload the configured bigdump.php file and your .sql backup to that folder. You'll set $filename to the name of the .sql file, for example $filename="dump.sql";

Yes you need to configure the $db vars as you did when you installed vBulletin.

[Brad]

Also I don't know why but your licensed status just changed...


LostStyles,

You are currently showing up as unlicensed. To be able to download hacks and/or receive support here at vBulletin.org, we ask you to please click here (vB-germany users click here) and enter your email address, to show us that you are licensed.

You will need to use your customer number and password (which will be in the email you got when you paid for your license) to access that page. Please note that your email is case sensitive. The update of your account may take up to one hour.

Thank you.

[wreck]

^^^yeah lol he just changed his email addresse forgetting he needs to keep that email in order to keep the licensed status

[wreck]

lol (this is loststyles) i cant find my activation code ...and i changed my email so now i cant change it back