Go Back   vBulletin Setup > vBulletinSetup Information > vBulletin Questions


Please Register to get full access to the forums.
Post New Thread  Reply



#1   02-11-2008, 09:59 AM
Dan@TT will become famous soon enough Join Date: Feb 2007 Posts: 24
Help me restore by database


Hi

I had a major breakdown of the linux server 4 days ago , yesterday however I've managed with the guys from the hosting company to recover some data from the crashed hdd.

I basically got the entire httpdocs folder , including all the forum files + the complete forum database located in /var/lib/mysql/forumname

the files located in this folder /var/lib/mysql/forumname look like this:

access.frm
access.MYD
access.MYI
....

etc.

Now the server got a new HDD, everything was reinstalled from zero. I've set up the server again from Plesk CP, created a new mysql database with the same name like the old one, same username & password to access the mysql database.

After, I went to /var/lib/mysql/forumname and put back all the previously saved files and I hoped it will work.

It doesn't work. I got Database error when trying to access the forum.

What am I doing wrong ?

Daniel
Quote   |  



#2   02-11-2008, 10:29 AM
Send a message via Yahoo to Dave Dave is a jewel in the roughDave is a jewel in the rough Join Date: Jan 2008 Posts: 1,010 Location: Ohio
Re: Help me restore by database


Make sure you are using the exact same software versions as before (MySQL, Plesk, PHP yada yada).

Create the database and give it the same name it had before, and the same user/pass combo. Install vBulletin fresh. Then try to copy the .frm, .MYD and .MYI files into the MySQL folder location overrighting the new fresh ones.

See if that works better for ya
--------------------
David / vBulletin Setup Staff
Check out our Newsletter for the latest vB and SEO news.
Are you looking for vBulletin work to be done on your forums ?
Would you like to Help Support vBulletin Setup.
Check out my Webmaster Articles at the vBulletin Setup Blog!

Coming soon:
Affiliate Program Reviews
Digital Camera Reviews
Quote   |  



#3   02-11-2008, 10:49 AM
Dan@TT will become famous soon enough Join Date: Feb 2007 Posts: 24
Re: Help me restore by database


Every reinstalled software is the same as previous.

Has the same previous database name/username/password combo. Has the same directory structure.

I will try like you said. Fresh install & database files replacement.
Quote   |  



#4   02-11-2008, 11:13 AM
Dan@TT will become famous soon enough Join Date: Feb 2007 Posts: 24
Re: Help me restore by database


Doesn't work mate...
Quote   |  



#5   02-11-2008, 12:38 PM
Send a message via Yahoo to Dave Dave is a jewel in the roughDave is a jewel in the rough Join Date: Jan 2008 Posts: 1,010 Location: Ohio
Re: Help me restore by database


You'll probably need to get a 3rd party program to restore the .MYD .frm files into a usable .sql database then.

Then export that, and import it into your new one.
--------------------
David / vBulletin Setup Staff
Check out our Newsletter for the latest vB and SEO news.
Are you looking for vBulletin work to be done on your forums ?
Would you like to Help Support vBulletin Setup.
Check out my Webmaster Articles at the vBulletin Setup Blog!

Coming soon:
Affiliate Program Reviews
Digital Camera Reviews
Quote   |  



#6   02-11-2008, 01:10 PM
Dan@TT will become famous soon enough Join Date: Feb 2007 Posts: 24
Re: Help me restore by database


I really don't know where to look for such converter
Quote   |  



#7   02-11-2008, 01:32 PM
Send a message via Yahoo to Dave Dave is a jewel in the roughDave is a jewel in the rough Join Date: Jan 2008 Posts: 1,010 Location: Ohio
Re: Help me restore by database


Alden Bates' Weblog: Converting FRM/MYD/MYI database files to SQL

or just google "Restore MYD files" to see some other results
--------------------
David / vBulletin Setup Staff
Check out our Newsletter for the latest vB and SEO news.
Are you looking for vBulletin work to be done on your forums ?
Would you like to Help Support vBulletin Setup.
Check out my Webmaster Articles at the vBulletin Setup Blog!

Coming soon:
Affiliate Program Reviews
Digital Camera Reviews
Quote   |  



#8   02-11-2008, 02:56 PM
Dan@TT will become famous soon enough Join Date: Feb 2007 Posts: 24
Re: Help me restore by database


It doesn't work. Some of the files must be corupted or something but I can't figure it out how could they be corupt
Quote   |  



#9   02-11-2008, 04:54 PM
Send a message via Yahoo to Dave Dave is a jewel in the roughDave is a jewel in the rough Join Date: Jan 2008 Posts: 1,010 Location: Ohio
Re: Help me restore by database


You may indeed have corrupt files then. I remember when i did a bone headed move and did a backup with those files, but i could do what i originally posted and get a good .sql export to fix the problem
--------------------
David / vBulletin Setup Staff
Check out our Newsletter for the latest vB and SEO news.
Are you looking for vBulletin work to be done on your forums ?
Would you like to Help Support vBulletin Setup.
Check out my Webmaster Articles at the vBulletin Setup Blog!

Coming soon:
Affiliate Program Reviews
Digital Camera Reviews
Quote   |  
Post New Thread  Reply
vBulletin Setup > vBulletinSetup Information > vBulletin Questions


Tags
httpdocs folder, mysql database, restore database

Thread Tools
Display Modes

 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
vBRecipe Michael Biddle vBulletin Setup Announcements 53 07-30-2008 03:46 PM
db restore Brandon Feedback and Suggestions 11 11-26-2007 06:16 AM
Restore Problem (phpmyadmin) inamaze vBulletin Questions 8 01-22-2007 08:24 PM
[HOW-TO] Backup/restore using phpMyAdmin/SSH Brandon vBulletin Questions 0 08-22-2006 11:10 AM


All times are GMT -6. The time now is 12:50 AM.

vBulletin Setup, vBulletin Setup Forums, vBulletin Services, vBulletin Blogs, vBulletin SEO, vBulletin Questions, vBulletin Skins, Styles, Templates
vBulletin Hacks / Modifications, vBulletin Monetization, Blogs, vBulletin Link Directory,Quality Link Directory