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!

[Birdie501]

You're welcome! I am happy that it works for you.

[linuxfreaky]

hi Birdie501

guess what man i payed for vbultin just to download ur hack lol
man i swear iam not ++++ing u i have diffrant forums and our hosting servers dont alow ssh or tel net
i have aproblem iam not geting any errors at all
every thing is cool the back up but in restore it says every thing restored
you go to the forum and boof nothing restored i did that over
4 times hosting on free bsd and all is cool as i told u no erros
just that the restore goes ok but in real it wont restore any thing
any idea will be so much happy 2 hear it
regards :glasses:

[Strider Xero]

does this work with 2.2.9 and 2.3.0??

[ZiRu$]

Originally posted by TheSaint-AeD
hmm...

my backup worked perfectly, but the restore doesn't work at all. I wanted to move servers using this, uploaded the compressed sql-file to my admin/backup directory on the new server, changed the variables, and clicked restore.

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

is the answer, but actually the db isn't restored.

yah same here and with almost everyone

[Drowned]

It doesn't create any file. I triple checked everything, and yes, my host can do dumps. Backup folder is still empty.

BTW, thanks for you "great" support... hehe, yeah right... :disappointed:

[laycomp]

Hello Birdie501,

I am unable to restore db.

I feel something is wrong in the $programm variable:

// ###################### Start Dorestore #######################

if ($HTTP_POST_VARS['action']=="dorestore") {

if(file_exists($pfad."/backup.sql.gz")==1):
$programm="c:/usr/mysql/bin/mysqldump";
$parameter="--host=".$db_host." --user=".$db_username." --password=".$db_passwort." --database=".$db_name." <".$pfad."/backup.sql";

What should go in the $programm variable line please?

by the way, I am using Apache on Windows and using v2.3 and all is so far working fine, thanks for this useful hack!

[laycomp]

never mind, I discovered the problem was a mistake in the hack code that wasn't even updated in the original instruction file, so if you're going to install be sure to read all the post and look for the area of the code that needs to be changed.

[Boofo]

Today at 01:52 AM laycomp said this in Post #127
never mind, I discovered the problem was a mistake in the hack code that wasn't even updated in the original instruction file, so if you're going to install be sure to read all the post and look for the area of the code that needs to be changed.

I read the whole thread and I must have missed the code change you were talking about. Can you point me to it, please?

[laycomp]

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

[laycomp]

02-17-03 at 09:13 PM Strider Xero said this in Post #123
does this work with 2.2.9 and 2.3.0??

I am using 2.3.0 and yes, it did work fine.