Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 04-01-2007, 07:08 PM
Daja Daja is offline
 
Join Date: Jun 2006
Location: London (UK)
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Help with db plz

For some reasent my database on my server was delited and the forum is not working now, but i still have some database backup folders saved on my ftp which i guess i can opload them on server data base and the forum would bee fine with just few post missing because will go back few days.
Can anyone tell me what should i do to make this right plz
Reply With Quote
  #2  
Old 04-01-2007, 07:15 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

How where these backups created?
Reply With Quote
  #3  
Old 04-01-2007, 07:24 PM
Daja Daja is offline
 
Join Date: Jun 2006
Location: London (UK)
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well i guess i must have had any addons instaled on vb because there is a folder in forum folder named backups and there is a backup folder saved for each day since november last year
Reply With Quote
  #4  
Old 04-01-2007, 08:12 PM
Xplorer4x4 Xplorer4x4 is offline
 
Join Date: Apr 2005
Posts: 938
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Go to phpmyadmin in you server control pannel(is you have cpanel go to "MySQL Databases" and scroll towards the bottom and there should be a link to phpmyadmin). Once in phpmyadmin click import and select the db file you want to up.
Reply With Quote
  #5  
Old 04-01-2007, 08:14 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What are the filenames of those backups?

PS It would be really helpfull if you knew how they where created.
Reply With Quote
  #6  
Old 04-01-2007, 09:01 PM
Daja Daja is offline
 
Join Date: Jun 2006
Location: London (UK)
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Xplorer4x4

I tryed that early on but there are so many files on the backup foulder to upload and it will take me such a long time to do it, is there any other way to do it qiuker like to upload the file with everything that has in it, not going inside the folder and up one by one.

Marco the backup folder its based inside the forum folder where includes,admincp images etc are, inside thise folder u got other folders named by dates like this 2007-03-27
Like i sad this backups start it a while ago but at that time a friend was maintanin the forum and i dont know if there was a addon add it in forum or what.
Reply With Quote
  #7  
Old 04-02-2007, 08:21 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Still my original question stands: What are the filenames of the backup?

Go into those directories until you find the actually backup fienames.
Reply With Quote
  #8  
Old 04-02-2007, 04:53 PM
Daja Daja is offline
 
Join Date: Jun 2006
Location: London (UK)
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Marco file names inside the foulder are as below with an extention SQL File, there are hundreds of them.

Live-2007-03-27-access
Live-2007-03-27-cms_poll_check
Live-2007-03-27-customavatar
Live-2007-03-27-editlog
Live-2007-03-27-forumread
Reply With Quote
  #9  
Old 04-02-2007, 05:16 PM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Are you on dedicated server, what OS?
You have only those above listed names, repeated hundreds of times each?
If yes, then you are screwed.

Contact your webhost and see if they have a full database dump. Some hosters will do a monthly site dump, just in case.
Reply With Quote
  #10  
Old 04-02-2007, 06:45 PM
Daja Daja is offline
 
Join Date: Jun 2006
Location: London (UK)
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No man there must be around 1000 different file names none of them its the same but i only coped those file names just to show whats we are talking about because couldnt copy all of them.
I imported about 120 files on database and i can tell that this files are part of the forum,im sure of this, but uploading 1000 files one by one is not easy and u may mis one then whats the point.
What i'm asking is, is there any way that can upload the backup folder its self not files inside one by one, also anything else that will help me to bring the forum back the way it was.
I did cantact my webhost about this but they only have a database saved which they can restore it back on 04/01/2007 wich is long time ego and i will loose alot users posts etc etc
Reply With Quote
Reply


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 09:27 AM.


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.04499 seconds
  • Memory Usage 2,242KB
  • Queries Executed 11 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (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_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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete