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!

[Slynderdale]

If you have shell access you can use it to take a backup .sql. like made by this hack and esily restore it just have the backup on the server where you wanna restore the backup to and then open shell and type

mysql -uUSERNAME -p dbname < /path/to/dump.sql

and it should restore the database.


If you dont have a site that has shell i think www.fatcake.com gives out free accounts with shell, you also get 3 url's in case you dont like the fatcake one, you get a joker.net and so on one too.

[wolfe]

what if GZIP is desabled is here another way around it with no zip

[Mithan]

Hello, I am having problems with the restore feature.

It says "ok" for everything, but it doesn't actually restore anything.

The backup works fine.

Any idea what may cause this?

Thanks.

[XtremeVigilante]

I am having the exact same problem. The backup works perfectly and everything is there. But when I restore it says OK for everything but nothing is really restored.

[XtremeVigilante]

Well never mind. Birdie this hack is great I was just retarded and didn't hack the backup going intot he right folder.

[Dark Shogun]

When I click the download link it shows text. If you right click it and choose save as then it downloads but do you know how I can make it download by just regularly clicking on it?

Dark Shogun

[Dark Shogun]

Cancel the part about right clicking. My database is only 938kb and when I downloaded the zip file it was over 2mb's. When I downloaded it with DAP it downloaded 123.7kb which is probably right. Do you know what is wrong?

Dark Shogun

[refertech]

I keep getting:

mysqldump: Got error: 1045: Access denied for user:
'user@mysiteIPaddress (Using password: YES) when trying to connect

I know im using the right pass and user? I have email my host and they say i support all the requirements. But i keep getting this error text in my backup directory> Could it be because they require me to log in using ssh and not telnet?

Any help would be appreicated. This is a great hack.

Thanks,

Mark

[XtremeVigilante]

Help ASAP Please!!!!


$db_host="localhost";
$db_username="ldeacon";
$db_passwort="XXXX";
$db_name="ldeacon";
$pfad="/usr/local/apache/htdocs/public_html/upload/admin/backup"; // root without / at the end
// If you don't know the root, just upload root.php on your server and call it!
$download_url="http://cgi-bin.spaceports.com/~ldeacon/upload/admin/backup/"; // http://... with / at the end
$dateiname=date('U'); // not to change!. Unique filename will be used


Get: File apache/htdocs/public_html/upload/admin/backup/backup.sql.gz not found!

What's wrong??

[XtremeVigilante]

Can anyone help??