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!

[Breeze]

But I have telnet with them so it doesn't matter that much now. I have moved to a new server and need to restore without telnet (they don't allow it).

When I try running this hack on new server it saves an empty file with date.sql.gz it does not save the error file like it should.

Can someone tell me if this hack is trying to access mysql and maybe they are blocking it?
Is there some way to test what my new server will allow?

I am trying to learn this php / mysql stuff but my eyes keep blurring out on me

[NTLDR]

You may find that the script cannot connect, I've tried this one a server I didn't have SSH access to and it wouldn't restore at all. Check with your host and see if they allow you to use the exec command in PHP.

[Breeze]

Thank You for fast reply. I have been checking all over the net for the answer. I figured that exec() was going to be problem. Looks like they have it running in safe mode and using the /bin directory. I tried placing this in there:
<?
exec('mysqldump -u username -p password db_name > db_name.sql');
?>
It wouldn't allow me to do that so I tried cgi-bin and I got server error when I ran it.

Not that they will but if I ask them to turn on some feature of PHP what exactly would I say? So as not to sound too stupid.

Thanks again

[NTLDR]

You could try changing exec to system that may work. If not I suggest asking your host to import your database as they don't give you SSH access.

[Breeze]

Tried using system() as for the mysqldump it didn't work. Did get it to list a directory but that may be nothing.

I wonder if they can allow a mysqldump command without having to worry about security?

I noticed in the /bin folder there is a file named ls
When I tested this out:
<?php
system('ls / -l');
?>

It showed a list of files. Guess what I am trying to figure out is can my new host setup something that is secure to allow backingup/restore?

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

[ULTIMATESSJ]

i'm getting the same error as TheSaint-AeD, so any chance of getting any assistance with this, i need to get a backup on with this hack, since my host has a 2MB upload limit and the host won't upload the backup for us

[Birdie501]

Hi,

i am sorry. Unfortunately I don't know how to help you!

[AloneEagle]

work with any version???

[JHSoundZ]

THANK YOU!!! THANK YOU!!!

our database just blanked and we cud not restore the data til we used this. the other admin is willing to bear your children if you wish. your rock! just saved us bout a weeks work getting it all back up.

he told me to add this on
- using winrar, you can gunzip the existing backup files taken from vb.