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

tourajamAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sohel RanaCommented:
Hi:

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

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

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

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

rsdn
tourajamAuthor Commented:
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
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

tourajamAuthor Commented:
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
tourajamAuthor Commented:
my OLD Forum is : 3.5.3 now i want install 3.6.0 !!!

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

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

rsdn
tourajamAuthor Commented:
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 !!!

:)
Sohel RanaCommented:
Hi:

Before you do anything, be sure that you backup your all files including mysql database. You can try in this way:

- Clean Install of Vbulletin NEW version
- From phpmyadmin remove the database with all tables
- Upload the old database in phpmyadmin
- Run the update.php files which is included in Vbulletin NEW version

rsdn

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tourajamAuthor Commented:
where is it ?
-Run the update.php files which is included in Vbulletin NEW version

Thanks
Sohel RanaCommented:
Thanks for the grade.

rsdn
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.