MySQL Database Backup/Restore Hack Ver. 1.0

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

[Boofo]

Today at 06:55 PM laycomp said this in Post #129
mmm... I tried going to the whole thread too to point out the changes, but sorry, maybe I didn't look good enough, anyways, I made the change in my install file and attached it, if you use it you shouldn't go wrong -at least I didn't.

Compare mine with the original install txt file and when you see the difference then you can search for the text and find the original posts that talks about the change in code. This I suggest you do.

I'd wish that whenever changes were made, developers took the time to upload the new files, so many people's time is plain wasted

Is this the wrong file you attached?

[laycomp]

Today at 01:09 AM Boofo said this in Post #131


Is this the wrong file you attached?

You mean I didn't attach file!? Sorry, here it is again.

[partang2]

Nope, I can't get it to work. It says that all is ok but no restore is done.... Anyone found a way to do this?

[jackyhow]

03-30-03 at 08:53 AM partang2 said this in Post #133
Nope, I can't get it to work. It says that all is ok but no restore is done.... Anyone found a way to do this?

i have the same problem, buddy

[jackyhow]

there is a lot of problems with this hack,,,,,.....................maybe dont use it

[Boofo]

Can't you restore it through phpmyadamin if you need to, if the restore feature doesn't work?

[Yuber]

I tried to restore and it said:

decompress backup: done!
restore file to database: done!

But nothing changed, my old database wasn't restored? and it was called backup.sql.gz

[Strider Xero]

This worked for the older versions of vB. I really wish someone would continue with this script because I think it's a good idea. If there's a backup feature, there should always be a restore feature as well.

[sajjid]

03-18-03 at 01:55 AM laycomp said this in Post #129
mmm... I tried going to the whole thread too to point out the changes, but sorry, maybe I didn't look good enough, anyways, I made the change in my install file and attached it, if you use it you shouldn't go wrong -at least I didn't.
Compare mine with the original install txt file and when you see the difference then you can search for the text and find the original posts that talks about the change in code. This I suggest you do.
I'd wish that whenever changes were made, developers took the time to upload the new files, so many people's time is plain wasted

03-18-03 at 05:55 PM laycomp said this in Post #132
You mean I didn't attach file!? Sorry, here it is again.

i still fail to make connection as to what you are saying i looked through the whole of the thread and didnt see code change niether in you file its same as Birdie501.
as matter of fact you really have confused the me as the first attchment has nothing to do with the hack

[iggy123]

I am using 2.30 and it worked fine for me - my db was screwed, I back it up every other day - and delete the old one,and I restored it using this hack and it worked a dream. I only lost 1 days posts (approx 300) so I was well happy!


update since moving the forums to a new folder I am having real problems.....

I have altered the templete.php to show

$pfad="home/virtual/site97/fst/var/www/html/forums/admin/backup";
$download_url="http://XXXX.net/forums/admin/backup/";

everything appears to be fine - i get the message "db backed up" etc
but when i down load the db - it tells me that the file is corrupt.
I have checked the folder permissions etc and everything appears to be fine?