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 :cool:

just updated the instructions for the root path!
zip file updated!

This is how it looks like!

Screen 2:

Screen 3

and screen 4

Thanks man!

I needed something like this, and now I have it =)

Wow, what an awesome idea :D.

what url do we put there?

Question:Why are the edits in template.php? Shouldn't they be in backup.php or something o_O?

Hi Austin Dea,

you should put the url where your backup folder is!

example: http://www.test.de/forums/admin/backup/


Well you are right, first i had an backp.php, but i think it is better in template.php because it is easier to install and the design fits better to the admin cp!

But the most important thing is: It works :classic: :D

I get a 404 File not found when i click download file:'(...

when you put the mouse over the link, what url do you see?

<a href="http://www.razael-central.com/forums/admin/backup/1019329010.sql.gz" target="_blank">http://www.razael-central.com/forums...9329010.sql.gz</a>

in variable declaration , did you forget to put a / at the end in download url?

If you have a look to you forum via ftp, where is the sql.gz file saved to?

in admin folder?

It's not saved anywhere I don't think...

Yeah I don't see it anywhere...like it's not even saving..

please try to put the exact url to the root path:

root/forums/admin/backup

o_O

Is what I have not right?

Edit: K, me and Birdie501 worked it out over pm's. Great hack!

great hack

when doing the restore i had a problem but the name you specified to rename the db was wrong it should be backup.sql.gz
not backp.sql.gz

Great hack though

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 ?

Simply Sweet!!

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.

Hey Austin Dea,

thanks for the support :-)))

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

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

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.

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!

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!

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.

:D

you're right! Keep watching! :-)

It should be better if i don't spend too much time in fron of the computer :D

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

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:(

I was lookin forward to this hack but i think i'll wait till everyone gets there problems solved

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.

ok thx, man i just sent a email to my web hoster!!

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

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

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?

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