Go Back   vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-18-2004, 04:12 PM
o0stephane0o's Avatar
o0stephane0o o0stephane0o is offline
 
Join Date: Feb 2002
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MySQL Database Backup/Restore Hack

Hi, I used to make my backups/restore with this wonderfull hack. You could backup or restore your whole database, despite the size of it and it allways worked fine.
I think this hack was probably the most interesting one but what a deception to see that it´s not compatible anymore with VB3.
I updated my forums and run vb3 now but cannot make the backups like I used to. In the thread of the hack, it looks like many, many people are requestiing the modification too.
Would a nice hacker help us?
Here is the .rar with all the files for VB2.
Thanks in advance.
Attached Files
File Type: zip mysql database backuprestore hack ver[1]. 1.0.zip (45.2 KB, 27 views)
Reply With Quote
  #2  
Old 07-18-2004, 10:30 PM
Merjawy's Avatar
Merjawy Merjawy is offline
 
Join Date: Sep 2002
Location: USA
Posts: 505
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have seen one I beleive by Erwin ( I could be wrong ) that works on vB3. just do search and you will find it ..
Reply With Quote
  #3  
Old 07-18-2004, 11:56 PM
o0stephane0o's Avatar
o0stephane0o o0stephane0o is offline
 
Join Date: Feb 2002
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I´ve checked all his posts but he had never posted something similar...
Thanks anyway...
Reply With Quote
  #4  
Old 08-01-2004, 01:59 AM
o0stephane0o's Avatar
o0stephane0o o0stephane0o is offline
 
Join Date: Feb 2002
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I cannot believe nobody can make it...
I´m sure it would take 2 minutes for a real hacker to do it..
It was so usefull for vb2, hundreds of people answered the thread. How come nobody wants to spend five minutes to update it?
Reply With Quote
  #5  
Old 08-01-2004, 04:37 AM
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 o0stephane0o
I cannot believe nobody can make it...
I?m sure it would take 2 minutes for a real hacker to do it..
It was so usefull for vb2, hundreds of people answered the thread. How come nobody wants to spend five minutes to update it?
Its not that we cannot make it, I am sure any good coder could, but there is no real reason to have a standard database restore function built into vB, or a hack really, this function is better suited to an external program (which ive seen a few around that do a decent job on big databases) or directly though the shell

If the database is dead, and you cant login to the admincp to use the hack, what good is it?


There is already a backup application in the vB ACP under Import and Mateincese.
Reply With Quote
  #6  
Old 08-01-2004, 05:39 PM
o0stephane0o's Avatar
o0stephane0o o0stephane0o is offline
 
Join Date: Feb 2002
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This one bugs a lot and if you want to restore the database, you only need to reinstall a new vb and put the database on it. It takes 2 minutes and works with very large DB...
By the way, excellent your VB IRC
Reply With Quote
  #7  
Old 08-02-2004, 02:08 AM
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 o0stephane0o
This one bugs a lot and if you want to restore the database, you only need to reinstall a new vb and put the database on it. It takes 2 minutes and works with very large DB...
By the way, excellent your VB IRC
IMO it would still be MUCH simpiler to use phpmyadmin or direct SSH access...
Reply With Quote
  #8  
Old 08-02-2004, 02:23 AM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

mysql -uuser -p database < backup.sql via SSH seems to be the easiest way to restore a database dump.
Reply With Quote
  #9  
Old 08-02-2004, 08:13 PM
o0stephane0o's Avatar
o0stephane0o o0stephane0o is offline
 
Join Date: Feb 2002
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Through php myadmin, what would be the correct way to backup sql?
Which box do I have to tick?
Reply With Quote
  #10  
Old 08-02-2004, 08:31 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 o0stephane0o
Through php myadmin, what would be the correct way to backup sql?
Which box do I have to tick?
For backing up, use vb's function or SSH
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 10:03 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.05559 seconds
  • Memory Usage 2,268KB
  • Queries Executed 14 (?)
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
  • (3)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
  • (1)postbit_attachment
  • (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_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete