Well it's not working for me, and I have my full root path and full URL path entered.

I get the messages...

But the file does not exist. And yes, my backup directory is chmodded 777.

Any ideas?

show me your variables!

Done, but I still don't understand why it would tell me it's done the various steps of the backup, then give me a link to the backup file, if you say my host may not support one of the variables?

I get the

sh: mysqldump: command not found

Thing to in my error.txt file but the zip file is the correct file size but i never restored yet because i don't want to take the chance of screwing everything up. But i will restore when i need to but I am still lost in what i have to do to get this error out of the way or does it not matter?

Hold on a sec the zip file is 35 bytes but the sql file inside is 0 byties with nothing inside of it ++++. What shoul i do? And also what is wrong with the database back up that 2.2.5 has already? I don't understand. I used that one before and that one works great for me

The 2.2.5 database backup always times out for me :(

I got this :

Start MySQL Dump:
Warning: Unable to fork [mysqldump -l --add-drop-table -h localhost -uroot -p bd_plongeur 2>forums/admin/backup/error.txt
...


what is the problem ?

oops... sorry !

wasn't working on the Windows test platform !

Now it's on the linux one, but the ISP has disabled the exec() function 8(

I must change ;)

Help, i get the

Parse error: parse error, unexpected '/' in /home/lovaboy/public_html/wf/admin/template.php on line 842

whats wrong?

Hi there

Thanks for a great hack Birdie501.

***************************
***************************
Some of you guys have the backup folder UNPROTECTED ..

at least PROTECT that folder with .htaccess ..

This is serious stuff .. so take it seriousley.
***************************
***************************

could someone explain how this works, i made a backup of my database and am moving to a new one (server) but where do i put the database before i click "restore"??

Well I tried using skyline's suggestion of changing the path to the mysqldump command, and still no luck.

I can't use the default backup as it times out for me, and I can't use this because although it tells me it did the backup, there's no file!

I DESPERATELY need to back up my database. Can anyone help?!?!?

all i can say is:
Ask your hoster!

Sorry :)

So much for support for this hack, then.

Time to uninstall it.

Hey, i dont know what functions your hoster provide!
The script works!!!!

So the reason has to be at your hoster! I am not your hoster so i don't know any details.

Why dont you ask your hoster first before posting that ++++?

I HAVE asked my host. mysqldump IS installed on my server. But your hack is NOT working!

I tried to install the hack aswell but for some reason I can't acces the screen itself, ones I click the backup/restore tab it just gives a 404 error file not found can someone help me out here?

Why When I downloaded it is .txt rather than .gz?

OK I am kinda angery about this also. I have a dabase I moved I saw this hack and was like WOOPI but I try to work it I upload my previous database from other host and on my new one I see that acceptance that it all went though right BUT I dont have my templates or anything back no style no nothin. any help?

Does this work for 2.2.6?

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

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

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.

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

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.

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?

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.

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

Hi,

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

work with any version???

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.