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!

[Psychdrone]

all man so I am screwed???

[Austin Dea]

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.

[ZiRu$]

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:

PHP Code:

$pfad="/public_html/test/admin/backup";
$download_url="http://www.hotdoggssite.com/admin/backup"; 


Can I get some help?

[Psychdrone]

Whats wrong with me

[Birdie501]

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:

PHP Code:

$pfad="/public_html/test/admin/backup";
$download_url="http://www.hotdoggssite.com/admin/backup"; 


Can I get some help?

Hi,

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

use this:

PHP Code:

$pfad="/public_html/test/admin/backup";
$download_url="http://www.hotdoggssite.com/admin/backup/"; 


[ZiRu$]

Originally posted by Birdie501


Hi,

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

use this:

PHP Code:

$pfad="/public_html/test/admin/backup";
$download_url="http://www.hotdoggssite.com/admin/backup/"; 


ok i did do that but it still dont work! It dosent create a file?

what else can i do?

[Birdie501]

Then please contact your hoster and ask if he provide mysql dumps etc. like discussed above!

[Dark_Wizard]

Originally posted by Hot Dogg


ok i did do that but it still dont work! It dosent create a file?

what else can i do?

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!

[Birdie501]

Hi Dark_wizard,

would be nice if you can publish your solution here in this thread so that also other user can use the hack :-)

Thanks.
:cheeky:

[Austin Dea]

Originally posted by Hot Dogg


ok i did do that but it still dont work! It dosent create a file?

what else can i do?

That doesn't look like your whole root directory. Upload root.php and see what it calls up.