UPDATE domain SET domain_gid = "0";
UPDATE domain SET domain_uid = "0";
UPDATE domain SET domain_status = "toadd";
UPDATE subdomain SET subdomain_status = "toadd";
UPDATE domain_aliasses SET alias_status = "toadd";
update mail_users set status = "toadd";
TRUNCATE TABLE `auto_num`;
update htaccess_groups set status = "toadd";
update htaccess_users set status = "toadd";
<?php
mysql_connect("localhost","root","ROOTPASS") or die ("ERROR");
mysql_select_db("vhcs2") or die ("Die Datenbank existiert nicht");
$ergebnis = mysql_query("SELECT * FROM sql_database order by sqld_id DESC");
while($row = mysql_fetch_row($ergebnis))
{
$dbnamealt = $row[2];
echo "$dbnamealt<br>";
mysql_query("CREATE DATABASE `$dbnamealt`");
}
?>
MYSQL DUMPS IMPORTIEREN
#!/bin/sh
ROOTPASS="XXXXX"
RESTORELIST=`find -name "*.sql" -maxdepth 1`
for i in $RESTORELIST
do
dateiname=$(echo $i | sed -e "s/\....$//")
dateiname=${dateiname:2}
mysql $dateiname < $dateiname.sql -p$ROOTPASS
done
echo FERTIG RESTORE!!
# BACKUPS IN DIE KUNDENORDNER SCHIEBEN
#!/bin/sh
RESTORELIST=`find -name "*.tar.gz" -maxdepth 1`
for i in $RESTORELIST
do
dateiname=$(echo $i | head -c -33)
dateiname=${dateiname:2}
echo $dateiname
original=${i:2}
mv $original /var/www/virtual/$dateiname/backups/$dateiname.tar.gz
chmod 660 /var/www/virtual/$dateiname/backups/$dateiname.tar.gz
rm /var/www/virtual/$dateiname/htdocs/index.html
done
echo FERTIG RESTORE!!
UPDATE domain SET domain_status = "restore";
## KUNDEN ORDNER NACHDEM RESTORE OWNER:GROUP SETZEN ;)
#!/bin/sh
CHOWN=`cat /etc/passwd | grep "vu2"`
for i in $CHOWN
do
OWNER=$(echo $i | cut -d ":" -f -1)
PFAD=$(echo $i | cut -d ":" -f 6)
GROUP=www-data
chown $OWNER:$GROUP $PFAD/ -R
echo $OWNER:$GROUP $PFAD/
done
#!/bin/sh
RESTORELIST=`find /var/www/virtual/ -name "*.*" -maxdepth 1`
for i in $RESTORELIST
do
cd $i/backups/ && rm *.tar.gz
echo $i
done
echo FERTIG RESTORE!!