Este codigo te hace una backup de MYSQL en un archivo GZ no? Pero como puedes exportar una tabla de MYSQL a un archivo XML ?
Cita:
Iniciado por Inside PHP Código PHP:
// Mysql Database Information:
$db_name = "name";
$db_username = "username";
$db_password = "password";
$backup_db_as = "elnombre.gz";
$backupcommand = "mysqldump --add-drop-table --add-locks -u$db_username -p$db_password $db_name | gzip > $backup_db_as";
passthru( "$backupcommand", $error );
Prueva este a ver si funciona:
Código PHP:
<?php
header("Content-type: text/xml");
$host = "localhost";
$user = "root";
$pass = "";
$database = "test";
$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host.");
mysql_select_db($database, $linkID) or die("Could not find database.");
$query = "SELECT * FROM blog ORDER BY date DESC";
$resultID = mysql_query($query, $linkID) or die("Data not found.");
$xml_output = "<?xml version=\"1.0\"?>\n";
$xml_output .= "<entries>\n";
for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){
$row = mysql_fetch_assoc($resultID);
$xml_output .= "\t<entry>\n";
$xml_output .= "\t\t<date>" . $row['date'] . "</date>\n";
// Escaping illegal characters
$row['text'] = str_replace("&", "&", $row['text']);
$row['text'] = str_replace("<", "<", $row['text']);
$row['text'] = str_replace(">", ">", $row['text']);
$row['text'] = str_replace("\"", """, $row['text']);
$xml_output .= "\t\t<text>" . $row['text'] . "</text>\n";
$xml_output .= "\t</entry>\n";
}
$xml_output .= "</entries>";
echo $xml_output;
?>