Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Beta Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
MySQL Database Backup/Restore Hack Ver. 1.0 Details »»
MySQL Database Backup/Restore Hack Ver. 1.0
Version: 1.00, by Birdie501 Birdie501 is offline
Developer Last Online: Feb 2011 Show Printable Version Email this Page

Version: 2.2.x Rating:
Released: 04-19-2002 Last Update: Never Installs: 57
Is in Beta Stage  
No support by the author.

################################################## ###############
MySQL Database Backup/Restore Hack Ver. 1.0
for all versions! tested with vb 2.2.5
Release Date: 20.04.2002
by Birdie501
Credits to: Jens Dutzi
################################################## ################

What this hack does:

You can backup and restore your mysql database via Admin CP!
Lot of people have problems to restore their database du to server timeouts!
With this hack you will never have any problems!
But anyhow you will use this hack with your own risk!

Requirements: Unix, GZIP, MySQL, MySQLDump

I am not a programmer! I just tried to implement this feature into my vbulletin and it works!
Maybe some of you, have the possibility to improve this hack! You are welcome!

Enjoy guys=))

Birdie501

just updated the instructions for the root path!
zip file updated!

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #82  
Old 06-15-2002, 12:48 PM
X-Fan's Avatar
X-Fan X-Fan is offline
 
Join Date: Jan 2002
Location: Adelaide, Australia
Posts: 496
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well it's not working for me, and I have my full root path and full URL path entered.

I get the messages...

Quote:
Start MySQL Dump: done!
compress file: done!
delete not compressed file: done!

Before you can restore this file, you have to rename to backp.sql.gz:

Download File
But the file does not exist. And yes, my backup directory is chmodded 777.

Any ideas?
Reply With Quote
  #83  
Old 06-15-2002, 01:22 PM
Birdie501's Avatar
Birdie501 Birdie501 is offline
 
Join Date: Dec 2001
Location: Germany
Posts: 272
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

show me your variables!
Reply With Quote
  #84  
Old 06-16-2002, 05:32 AM
X-Fan's Avatar
X-Fan X-Fan is offline
 
Join Date: Jan 2002
Location: Adelaide, Australia
Posts: 496
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Done, but I still don't understand why it would tell me it's done the various steps of the backup, then give me a link to the backup file, if you say my host may not support one of the variables?
Reply With Quote
  #85  
Old 06-18-2002, 11:43 AM
BigJohnson BigJohnson is offline
 
Join Date: Nov 2001
Posts: 535
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I get the

sh: mysqldump: command not found

Thing to in my error.txt file but the zip file is the correct file size but i never restored yet because i don't want to take the chance of screwing everything up. But i will restore when i need to but I am still lost in what i have to do to get this error out of the way or does it not matter?
Reply With Quote
  #86  
Old 06-18-2002, 11:46 AM
BigJohnson BigJohnson is offline
 
Join Date: Nov 2001
Posts: 535
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hold on a sec the zip file is 35 bytes but the sql file inside is 0 byties with nothing inside of it ++++. What shoul i do? And also what is wrong with the database back up that 2.2.5 has already? I don't understand. I used that one before and that one works great for me
Reply With Quote
  #87  
Old 06-18-2002, 12:13 PM
X-Fan's Avatar
X-Fan X-Fan is offline
 
Join Date: Jan 2002
Location: Adelaide, Australia
Posts: 496
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The 2.2.5 database backup always times out for me
Reply With Quote
  #88  
Old 06-20-2002, 07:01 PM
fabz fabz is offline
 
Join Date: Feb 2002
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I got this :

Start MySQL Dump:
Warning: Unable to fork [mysqldump -l --add-drop-table -h localhost -uroot -p bd_plongeur 2>forums/admin/backup/error.txt
...


what is the problem ?
Reply With Quote
  #89  
Old 06-20-2002, 07:59 PM
fabz fabz is offline
 
Join Date: Feb 2002
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

oops... sorry !

wasn't working on the Windows test platform !

Now it's on the linux one, but the ISP has disabled the exec() function 8(

I must change
Reply With Quote
  #90  
Old 06-27-2002, 02:38 AM
Lovaboye Lovaboye is offline
 
Join Date: Apr 2002
Posts: 46
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Help, i get the

Parse error: parse error, unexpected '/' in /home/lovaboy/public_html/wf/admin/template.php on line 842

whats wrong?
Reply With Quote
  #91  
Old 06-28-2002, 08:33 AM
MalaK_3araby MalaK_3araby is offline
 
Join Date: Dec 2001
Posts: 39
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi there

Thanks for a great hack Birdie501.

***************************
***************************
Some of you guys have the backup folder UNPROTECTED ..

at least PROTECT that folder with .htaccess ..

This is serious stuff .. so take it seriousley.
***************************
***************************
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 01:13 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.04887 seconds
  • Memory Usage 2,301KB
  • Queries Executed 25 (?)
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)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)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