/ Published in: PHP
Attempt 1 is a command-line attempt. Likely not to work due to php often running as "nobody". Attempt 2 is a php way, going through teach table in the database and writing out to a file.
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
<?php require_once('wp-config.php'); //Attempt 1: Via command-line /* $backupFile = './art-ice-db-' . date("Y-m-d-H-i-s") . '.gz'; $command = "mysqldump --opt -h DB_HOST -u DB_USER -p DB_PASSWORD DB_NAME | gzip > $backupFile"; system($command, $ret); echo $ret; */ //Attempt 2: Via PHP connecting to mysql backup_tables(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME); /* backup the db OR just a table */ function backup_tables($host,$user,$pass,$name,$tables = '*') { //get all of the tables if($tables == '*') { { $tables[] = $row[0]; } } else { } //cycle through foreach($tables as $table) { $return.= 'DROP TABLE '.$table.';'; $return.= "\n\n".$row2[1].";\n\n"; for ($i = 0; $i < $num_fields; $i++) { { $return.= 'INSERT INTO '.$table.' VALUES('; for($j=0; $j<$num_fields; $j++) { if ($j<($num_fields-1)) { $return.= ','; } } $return.= ");\n"; } } $return.="\n\n\n"; } //save file }