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!

[ZiRu$]

PHP Code:

$pfad="d:/gearhost/hostingaccounts/lfgs/www/test/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://www.mysite.com/test/admin/backup/";                // [url]http://...[/url] with / at the end 


but thats not the real path........

this is
d:\gearhost\hostingaccounts\lfgs\www est\

see it has backslashes instead of forward slashes

[ZiRu$]

man please i need HELP!

[ZiRu$]

Here's what i think is wrong

PHP Code:

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

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

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

  echo("<b>decompress backup:</b> \n");
  exec("cd ".$pfad, $lines, $result);
  exec("gzip -d ".$pfad."/backup.sql.gz", $lines, $result);
  echo("done!<br>\n");

  echo("<b>restore file to database:</b> \n");
  exec($programm." ".$parameter, $lines, $result);
  echo("done!<br>\n");
else:
  echo("<b>File <font color='red'>".$pfad."/backup.sql.gz</font> not found!</b> \n");
endif;

} 


I tought for my host i need to switch all the "/" to "\"
But it still don't work! I changed all the "/" to "\" before backup.sql

and that never worked.....So is there any chance you could Re-Write the Dorestorecode for me so that It dosen't Have and "/" and instead on this line

PHP Code:

$pfad="d:\gearhost\hostingaccounts\lfgs\www\test\admin\backup";                           // root without / at the end 


i can put the \ at the end

Thanks in Advance...

[ZiRu$]

now it says:

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

but it never actually did it.....and it wont backup either......it says its fine but it's actually not....it dont create a file

[Birdie501]

Hey sorry i dont know how to solve your problem! You should ask your hoster because i think there is the problem!

[machiavelli33]

Originally posted by skyline2002

in some server ,The path to the 'mysqldump' command on the will be: /usr/local/mysql/bin/mysqldump

By the way,thx Birdie501 , Great hack!!!!
enjoy!!!

hey Skyline...can you explain this part again?

How do you change the mysqldump to another command? Is that something the site server can do or can it be modified in the hack?

[skyline2002]

Originally posted by machiavelli33


hey Skyline...can you explain this part again?

How do you change the mysqldump to another command? Is that something the site server can do or can it be modified in the hack?

you dont have the permission to turnon or off the mysqldump function if you rant the webspace by a hoster.

you may ask your hoster for the dir of the command.

i just changed the dir. the command still is mysqldump!

[Finan]

I've had this work under 224 and 225... Only problems where my own typos Great hack

[freakyshiat]

my mysql database is on a different server. will this hack work with it?

[nitro]

hmmm i suggested this @ vbulletin.com forum ages ago

they categorically stated it will make no difference php will still time out

and the restore will be incomplete and php backup is not 100% reliable

so i learnt telnet

its not difficult unless of course yer host dont have telnet but a host with mysql an no telnet imo is like a bacon butty with no bacon

of course i hope the hack works ok 4 u all iv downloaded it incase i ever need it i certainly dont have the knowledge to write it myself