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!

[Austin Dea]

Originally posted by SoliduS_cF
When i click on the do backup, it progress's to the next screen as normal, but when i goto rename the file to backp.sql.gz there is no such file on the server, i have followed the included instructions, share any light on this buddy ?

I had this problem.

Be sure your pfad variable is

your root(as called by root.php)/forums/admin/backup

So you have to have the root deal, plus the path to the backup directory (without the slash at the end)

then your
download_url=www.yourdomain.com/forums/admin/backup/


Also, you don't have to rename it when you back it up (unless your changing it to the date (what i do)). You only need to make it backup.sql.gz when you are restoring from a backup =P.

[Birdie501]

Hey Austin Dea,

thanks for the support :-)))

[Psychdrone]

ok what am I doing wrong??? (this is a grate hack by the way, if I can get it to work!!!!)

I cencered my sites url, by replacing it with Mysite for privacy

OK heres what I got, when I click on the download button I get thi

http://www.mysite.com/forum/admin/ba...9426678.sql.gz
and its a blank page


heres what I put in for my root path
home/myusername/public_html/forum/admin/backup

and heres what I put in for the download link
http://www.mysite.net/forum/admin/backup/

What am I doing wrong, please help!!

[Austin Dea]

Is home/myusername/public_html/ what the root.php calls?

[212rikanmofo]

you said this hack on works on unix? so i guess it wont work under windows?

[Birdie501]

Originally posted by 212rikanmofo
you said this hack on works on unix? so i guess it wont work under windows?

Hi,
well my hoster has a unix server so i am not sure if it works with windows. Maybe someone should try and confirm.

[Birdie501]

mmmhh,

i just wondering that the zip file has been downloaded for (up to now) 45 times! Where are these guys! Would like to hear if there are bugs....

Thanks!

[Psychdrone]

Heres what it says
// $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $ // $$ call this file to see your root path $$ // $$ Birdie501 $$ // $$ contact via PM on vbulletin.org $$ // $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $ /home/mysitesname/public_html

Please help me, and tell me what to fill in

[Birdie501]

Originally posted by Psychdrone
Heres what it says
// $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $ // $$ call this file to see your root path $$ // $$ Birdie501 $$ // $$ contact via PM on vbulletin.org $$ // $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $ /home/mysitesname/public_html

Please help me, and tell me what to fill in

Here we go :-)

In the line of the root path, just fill in the root path plus the folders to your backup folder. In your example.

home/mysitesname/public_html/forums/admin/backup

your download url must be:

http://www.yoursite.com/forums/admin/backup/

thats all!

[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.