Link to home
Start Free TrialLog in
Avatar of tourajam
tourajam

asked on

How to Restore VBULLETIN ?

Hello Guys,

today i get BACKUP from my VBULLETIN, now i want RESTORE it !!! i dont know how, please assistance me step by step ..

my Backup Name : forumbackup-09-07-2006-34316

Thanks

Avatar of Sohel Rana
Sohel Rana
Flag of Australia image

Hi:

Backing Up & Restoring a MySQL Database using phpMyAdmin / SSH:

http://www.vbulletin.com/forum/showthread.php?t=136166

rsdn
Also check the vbulletin manual for Backup / Restore Options :

http://www.vbulletin.com/docs/onepage#item48

rsdn
Avatar of tourajam
tourajam

ASKER

Database error in vBulletin 3.5.3:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('0ea06487dc1772a8e4d7420cd5616cd7', 0, '69.197.161.164', '6d79b64115c5538d57ac4c7cc56a1646', 1157668967, '/forum/index.php', 0, 0, 0, 0, 0, 0, 2, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)', 0, 0);

MySQL Error  : Unknown column 'profileupdate' in 'field list'
Error Number : 1054
Date         : Friday, September 8th 2006 @ 03:12:47 AM
Script       : http://www.persianpet.org/forum/index.php
Referrer     : http://persianpet.org/en/us.html
IP Address   : 69.197.161.164
Username     : ثبت Ù?اÙ. Ù?شدÙ?
Classname    : vb_database
Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'error'
AND varname = 'cant_set_cookies' AND languageid IN (-1, 0, 0);

MySQL Error  : Unknown column 'special' in 'field list'
Error Number : 1054
Date         : Friday, September 8th 2006 @ 01:44:51 AM
Script       : http://www.persianpet.org/forum/index.php
Referrer     :
IP Address   : 85.198.21.155
Username     :
Classname    : vb_database
my OLD Forum is : 3.5.3 now i want install 3.6.0 !!!

thats the problem !
Did you follow the upgrade instructions  which are included in the vbulletin 3.6.0 ?

rsdn
Is there any hacks installed in your old vb version?

rsdn
1 ) i remove my OLD SQL DB, i cant remember it .. ( but im not remove my OLD FORUM files ) that mean my old forum not work now for upgrade !
but before removing SQL i get FULL Back up

and no im not still any HACKS !!!

:)
ASKER CERTIFIED SOLUTION
Avatar of Sohel Rana
Sohel Rana
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
where is it ?
-Run the update.php files which is included in Vbulletin NEW version

Thanks
Thanks for the grade.

rsdn