Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
Reload this Page Anyone know of a way to recover a dropped database??
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 03-01-2004, 02:41 PM
Tigga's Avatar
Tigga Tigga is offline
 
Join Date: Dec 2001
Location: Atlanta
Posts: 1,061
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Anyone know of a way to recover a dropped database??
Well I just did something REALLY stupid... I was trying to drop a single table on one of my databases, but instead I accidentally dropped the entire database. There was some pretty important stuff in there that I had been working on (Mostly templates... The rest isn't a big deal) that it would be great if I could somehow recover. It was on my local machine running Windows XP Home, and the database was dropped using phpMyAdmin. I realize that everything is probably lost for good, but I figured I'd check here to see if anyone knows of a way that this stuff can be recovered before I start everything over from scratch.
Reply With Quote
  #2  
Old 03-01-2004, 02:45 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
If it's on your local machine, try an undelete program. As long as you haven't overwritten anything, it still should be there.
Reply With Quote
  #3  
Old 03-01-2004, 05:21 PM
FleaBag's Avatar
FleaBag FleaBag is offline
 
Join Date: Dec 2001
Posts: 1,674
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Ah Tigga I feel for you, I used to run a site called GamerForums, I dropped the 200 meg database by accident. The server admins wouldn't supply me with a backup even though they had them. Seriously sucks.
Reply With Quote
  #4  
Old 03-01-2004, 05:22 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by FleaBag
Ah Tigga I feel for you, I used to run a site called GamerForums, I dropped the 200 meg database by accident. The server admins wouldn't supply me with a backup even though they had them. Seriously sucks.
Them admins seem like arseholes :/
Reply With Quote
  #5  
Old 03-01-2004, 05:26 PM
FleaBag's Avatar
FleaBag FleaBag is offline
 
Join Date: Dec 2001
Posts: 1,674
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Yeah tell me about it, they changed the FTP server my site [GamerForums] was on once, and it took them a month to reply to my emails to tell me which one it was on. I can't really complain that much though, I did have unlimited resources for free, but still as you say, it's common courtesy.
Reply With Quote
  #6  
Old 03-01-2004, 05:45 PM
Tigga's Avatar
Tigga Tigga is offline
 
Join Date: Dec 2001
Location: Atlanta
Posts: 1,061
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thanks for the tip Boofo. I think I may have found a program that will work... None I've tried have been able to find the database, but one did at least find a backup of the database that I made (and apparently deleted) a week ago. It will still be a pain to go through the templates and re-apply the changes I've made since then, but that's definitely better than having to start completely from scratch on them.
Reply With Quote
  #7  
Old 03-01-2004, 06:16 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
No problem.

What program did you find that you think will work? There are a lot of them out there, but only a few worth a damn.
Reply With Quote
  #8  
Old 03-01-2004, 07:17 PM
Tigga's Avatar
Tigga Tigga is offline
 
Join Date: Dec 2001
Location: Atlanta
Posts: 1,061
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
It's a program called Active@ Undelete. It found a few things that some of the other programs didn't. It figures though, I just bought the program so I could restore a larger file only to find out that file didn't have anything useful.
Reply With Quote
  #9  
Old 03-01-2004, 07:25 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Isn't that the way it usually goes?

Your db files should be a bunch of small ones though in the db dir, right?
Reply With Quote
  #10  
Old 03-02-2004, 01:48 PM
Tigga's Avatar
Tigga Tigga is offline
 
Join Date: Dec 2001
Location: Atlanta
Posts: 1,061
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Yup, that's usually about the way my luck is.
I'm pretty sure I searched for the individual tables as well... I guess it wouldn't hurt to try one last time though and go through everything with a fine tooth comb before I start over again.
Reply With Quote
Reply

« Previous Thread | Next Thread »

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
Forum Jump


All times are GMT. The time now is 06:33 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04191 seconds
  • Memory Usage 2,252KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete