Tweet
Bakcup Database
I hope this is the right forum to post this.....it is a hint 4 people who don´t run vbulletin on their own Server or don´t have SSH access to their provider´s Server/database....
I had the Problem that the backup via User CP didn´t work....i get a timeout there....even with phpmyadmin i wasn´t able to dump my database properly.
This is a script to make a backup of ur whole database and save it into zip file on ur server/webspace what ever.
Just create a small php file with following code.
I had the Problem that the backup via User CP didn´t work....i get a timeout there....even with phpmyadmin i wasn´t able to dump my database properly.
This is a script to make a backup of ur whole database and save it into zip file on ur server/webspace what ever.
Just create a small php file with following code.
<html>
<head>
<!-- TemplateBeginEditable name="doctitle" -->
<title>DB Backup</title>
<!-- TemplateEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- TemplateBeginEditable name="head" -->
<!-- TemplateEndEditable -->
</head>
<body>
<?php
$host= '';
$user= '';
$pass= '';
$db= '';
$date = date("d-m-Y");
system(sprintf(
"mysqldump --opt -h %s -u %s -p%s %s | gzip > %s/DBbackup_".$date.".de.sql.gz",
$host,
$user,
$pass,
$db,
getenv('DOCUMENT_ROOT')."/DB_Backup"
));
echo "<center><font style=arial>Database <b>".$db."</b> from <b>".$host."</b> saved.</font></center><p>";
?>
</body>
</html>
<head>
<!-- TemplateBeginEditable name="doctitle" -->
<title>DB Backup</title>
<!-- TemplateEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- TemplateBeginEditable name="head" -->
<!-- TemplateEndEditable -->
</head>
<body>
<?php
$host= '';
$user= '';
$pass= '';
$db= '';
$date = date("d-m-Y");
system(sprintf(
"mysqldump --opt -h %s -u %s -p%s %s | gzip > %s/DBbackup_".$date.".de.sql.gz",
$host,
$user,
$pass,
$db,
getenv('DOCUMENT_ROOT')."/DB_Backup"
));
echo "<center><font style=arial>Database <b>".$db."</b> from <b>".$host."</b> saved.</font></center><p>";
?>
</body>
</html>
Comment