Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Beta Releases
Reload this Page MySQL Database Backup/Restore Hack Ver. 1.0
FAQ Community Calendar Today's Posts Search

Reply
Page 6 of 16 « First 45 6 78 Last »
 
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
  #52  
Old 04-26-2002, 12:19 AM
ZiRu$'s Avatar
ZiRu$ ZiRu$ is offline
 
Join Date: Jan 2002
Location: Manitoba, Canada
Posts: 520
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally posted by Austin Dea


That doesn't look like your whole root directory. Upload root.php and see what it calls up.
thanks thats what the problem was! It's NOW FIXED

But I'm having 1 more problem.....

When i go to ftp client and look at the "backup" file! The download is only 958k and has a file called "error.txt" with no content!

What's up wit dis?
Reply With Quote
  #53  
Old 04-26-2002, 05:16 AM
Birdie501's Avatar
Birdie501 Birdie501 is offline
 
Join Date: Dec 2001
Location: Germany
Posts: 272
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
If the error.txt is empty dont care about it!
Do you wonder why your file is that small? Be happy :-)
If you use the restore function the file will be uncompressed! Then you can see how big it normally would be without compressing.
Reply With Quote
  #54  
Old 04-26-2002, 12:14 PM
skyline2002 skyline2002 is offline
 
Join Date: Dec 2001
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally posted by Dark_Wizard


Hostrocket does support the MySQL commands and gzip....get in touch with me via ICQ and I will help you out. BTW I just tested this and I'm on hostrocket and it works fine...nice hack!
Dark_Wizard

please publish your solution here . help us!!

by the way , i couldnt find your icq # in anywhere!!

thanks in advance!!!
Reply With Quote
  #55  
Old 04-26-2002, 03:26 PM
ZiRu$'s Avatar
ZiRu$ ZiRu$ is offline
 
Join Date: Jan 2002
Location: Manitoba, Canada
Posts: 520
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally posted by skyline2002


Dark_Wizard

please publish your solution here . help us!!

by the way , i couldnt find your icq # in anywhere!!

thanks in advance!!!
the problem is you dont have the full path in

run root.php and everything will work perfectly
Reply With Quote
  #56  
Old 04-26-2002, 07:21 PM
Psychdrone Psychdrone is offline
 
Join Date: Nov 2001
Posts: 525
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
so I am screwed??

Help
Reply With Quote
  #57  
Old 04-26-2002, 07:26 PM
212rikanmofo 212rikanmofo is offline
 
Join Date: Nov 2001
Location: paris
Posts: 151
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
doesn't vb 2.2.5 already have an option to backup database under the admin cp? i thought i saw it?
Reply With Quote
  #58  
Old 04-26-2002, 07:46 PM
212rikanmofo 212rikanmofo is offline
 
Join Date: Nov 2001
Location: paris
Posts: 151
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
i'm not sure if this is spose to work with windows, but i get the following:

Start MySQL Dump:
Warning: Unable to fork [mysqldump -l --add-drop-table -h localhost -uadmin -pgeddy vbulletin 2>h:/apache/htdocs/forum/admin/backup/error.txt >h:/apache/htdocs/forum/admin/backup/1019853638.sql] in h:\apache\htdocs\forum\admin\template.php on line 753
done!
compress file:
Warning: Unable to fork [gzip -c h:/apache/htdocs/forum/admin/backup/1019853638.sql > h:/apache/htdocs/forum/admin/backup/1019853638.sql.gz] in h:\apache\htdocs\forum\admin\template.php on line 757
done!
delete not compressed file:
Warning: Unable to fork [rm h:/apache/htdocs/forum/admin/backup/1019853638.sql] in h:\apache\htdocs\forum\admin\template.php on line 761
done!
Before you can restore this file, you have to rename to backp.sql.gz:
Download File
Reply With Quote
  #59  
Old 04-27-2002, 06:12 AM
ZiRu$'s Avatar
ZiRu$ ZiRu$ is offline
 
Join Date: Jan 2002
Location: Manitoba, Canada
Posts: 520
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally posted by 212rikanmofo
doesn't vb 2.2.5 already have an option to backup database under the admin cp? i thought i saw it?
Dont use that cause if you back it up you need to import it through telnet!

I just got it working PERFECTLY....I backed up my database and imported it WITH no problems.....Picture Perfect.

You have made my day. This should come out of beta testing since it works. If it dosent its your host or your screw up
Reply With Quote
  #60  
Old 04-27-2002, 07:03 AM
Birdie501's Avatar
Birdie501 Birdie501 is offline
 
Join Date: Dec 2001
Location: Germany
Posts: 272
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
@psychdrone

if you installed the way you have to and it doesn't work there is something wrong with your hoster. Maybe you have the same hoster like Hot Dogg but another package where the mysql dumps for example is not includede or something else! You have to talk to them!

@Hot Dogg
Well maybe i will make it out of beta but probably i will release some new features, so be patient. :-)
Reply With Quote
  #61  
Old 04-27-2002, 08:14 AM
skyline2002 skyline2002 is offline
 
Join Date: Dec 2001
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally posted by Hot Dogg


the problem is you dont have the full path in

run root.php and everything will work perfectly
i dont think so it is the full path problem.
i didnt get any error message and i can see *.sql in my backup folder. but sql file is 0kb. and got a error.txt says:
"mysqldump command not find!!!"

sad!!!!
Reply With Quote
Reply
Page 6 of 16 « First 45 6 78 Last »

« 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 11:47 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05019 seconds
  • Memory Usage 2,305KB
  • 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
  • (5)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