Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = "";//host do banco
- $user = "";//usuario do banco
- $senha = "";//senha do banco
- $dbc = mysql_connect($host,$user,$senha);
- $m = mysql_select_db("test", $dbc);
- $sql = "show databases";
- $sts = mysql_query($sql,$dbc) or die (mysql_error());
- $data = date("d-m-y");
- while($row = mysql_fetch_array($sts)){
- $nome = $row[0];
- $NARQUIVO = $nome."-".$data;
- $resp = `mysqldump --host=$host --user=$user --password=$senha --databases $nome
- > /home/user/public_html/$NARQUIVO.sql` ;
- }
- $arquivo = "mysql_".$data;
- //criar os pacotinhos com todos os arquivos.sql
- $resp = `tar -cvzf /usr/backup/$arquivo.tar.gz /home/user/public_html/*.sql`;
- $resp = `rm *.sql`;
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement