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.

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

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.

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.

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

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

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

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

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

Can anyone help??