Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
MySQL Database Backup/Restore Hack Ver. 1.0 Details »
MySQL Database Backup/Restore Hack Ver. 1.0
Mod Version: 1.00, by Birdie501 (Member) Birdie501 is offline
Developer Last Online: Feb 2011 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 2.2.x Rating: (2 votes - 5.00 average) Installs: 57
Released: 20 Apr 2002 Last Update: Never Downloads: 27
Not Supported Is in Beta Stage  

#################################################################
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!

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
  #31  
Old 23 Apr 2002, 08:10
Birdie501's Avatar
Birdie501 Birdie501 is offline
 
Join Date: Dec 2001
Originally posted by Austin Dea
Except it should be

"/home/mysitesname/public_html/forum/admin/backup"

and

"http://www.yoursite.com/forum/admin/backup/"

You forgot the first slash, and he has just forum for his directory, not forums.

you're right! Keep watching! :-)

It should be better if i don't spend too much time in fron of the computer
Reply With Quote
  #32  
Old 23 Apr 2002, 20:40
skyline2002 skyline2002 is offline
 
Join Date: Dec 2001
Re: MySQL Database Backup/Restore Hack Ver. 1.0

Originally posted by Birdie501
#################################################################
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!
it is a nice hack, man!!
but i got a error message when i try to backup my forum database!

here is the message:
-----------------------------------
sh: mysqldump: command not found.
-----------------------------------

so what can i do with it ??

hope you can fix the problem. my web hoster is from www.Siteturn.com!!!
thank you so much!!!
Reply With Quote
  #33  
Old 23 Apr 2002, 21:17
Psychdrone Psychdrone is offline
 
Join Date: Nov 2001
Damn I new this [better wash my mouth][better wash my mouth][better wash my mouth][better wash my mouth] was too good to be true!!

I get an invalid arch file when I try to open the zip
Reply With Quote
  #34  
Old 24 Apr 2002, 05:19
ZiRu$'s Avatar
ZiRu$ ZiRu$ is offline
 
Join Date: Jan 2002
I was lookin forward to this hack but i think i'll wait till everyone gets there problems solved
Reply With Quote
  #35  
Old 24 Apr 2002, 06:34
Austin Dea's Avatar
Austin Dea Austin Dea is offline
 
Join Date: Dec 2001
Real name: Austin ;)
There are no problems for me...works fine .

@skylinw2002-You might want to talk to your host bout that...

I don't know what Psychdrone's problem is, the zip is working fine for me.
Reply With Quote
  #36  
Old 24 Apr 2002, 07:13
skyline2002 skyline2002 is offline
 
Join Date: Dec 2001
ok thx, man i just sent a email to my web hoster!!
Reply With Quote
  #37  
Old 24 Apr 2002, 08:44
proton242 proton242 is offline
 
Join Date: Nov 2001
when i click on download i have this message:

# MySQL dump 8.16
#
# Host: localhost Database: mydatabase
#--------------------------------------------------------
# Server version 3.23.45

and my backup folder are empty...
Reply With Quote
  #38  
Old 24 Apr 2002, 10:42
Birdie501's Avatar
Birdie501 Birdie501 is offline
 
Join Date: Dec 2001
@skyline2002

Hi, i am sure that this is a problem with your host! Maybe he doesn't support mysql dumps!!!

@proton
so you try this with your local server, what server do you use?
Here is the part of my file:
Server version 3.23.47-Max-log

Maybe it doesn't work with your older version?

@HotDogg
Well this isn't really a problem! If your hoster support all the needed functions it will work fine! Just have a try, you cant destroy anything!
Reply With Quote
  #39  
Old 24 Apr 2002, 16:29
ZiRu$'s Avatar
ZiRu$ ZiRu$ is offline
 
Join Date: Jan 2002
Originally posted by Birdie501

@HotDogg
Well this isn't really a problem! If your hoster support all the needed functions it will work fine! Just have a try, you cant destroy anything!
ok thanks! i will try it when i get home!!!

I will test it on 2.2.4

I am running on hostrocket as a server. Has anyone had any problems/or even tried this hack on hostrocket?

Does this eliminate if you were switching servers you wouldn't have to use telnet?
Reply With Quote
  #40  
Old 24 Apr 2002, 19:52
Cell Block Cell Block is offline
 
Join Date: Apr 2002
Let me get this right, with this hack i can restore my database if it had messed up, or if i've moved to a new server i can install the board and hack and then restore the board this way rather than using telnet or SSH?

I don't know but i may have mis-understood
Reply With Quote
  #41  
Old 24 Apr 2002, 22:27
Psychdrone Psychdrone is offline
 
Join Date: Nov 2001
all man so I am screwed???
Reply With Quote
  #42  
Old 25 Apr 2002, 00:49
Austin Dea's Avatar
Austin Dea Austin Dea is offline
 
Join Date: Dec 2001
Real name: Austin ;)
Originally posted by Cell Block
Let me get this right, with this hack i can restore my database if it had messed up, or if i've moved to a new server i can install the board and hack and then restore the board this way rather than using telnet or SSH?

I don't know but i may have mis-understood
This hack can make a backup of your database for you to download, or you can restore your database from a backup you downloaded previously.
Reply With Quote
  #43  
Old 25 Apr 2002, 01:24
ZiRu$'s Avatar
ZiRu$ ZiRu$ is offline
 
Join Date: Jan 2002
I get the regular:

------------------------
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 My admin/backup.php is empty...and when i click the download file it has

/admin/backup1019693643.sql.gz

its supposed to be
/admin/backup/backup1019693643.sql.gz


---------------------------------
Here's My Variables:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Can I get some help?
Reply With Quote
  #44  
Old 25 Apr 2002, 04:03
Psychdrone Psychdrone is offline
 
Join Date: Nov 2001
Whats wrong with me
Reply With Quote
  #45  
Old 25 Apr 2002, 11:13
Birdie501's Avatar
Birdie501 Birdie501 is offline
 
Join Date: Dec 2001
Originally posted by Hot Dogg
I get the regular:

------------------------
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 My admin/backup.php is empty...and when i click the download file it has

/admin/backup1019693643.sql.gz

its supposed to be
/admin/backup/backup1019693643.sql.gz


---------------------------------
Here's My Variables:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Can I get some help?
Hi,

you forgot to add a slash " / " at the end of the download url!

use this:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

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


New To Site? Need Help?

All times are GMT. The time now is 17:55.

Layout Options | Width: Wide Color: