// Verbindung zur Datenbank aufbauen 
 
$db_con_id = mysql_connect($db_hostname, $db_user, $db_password) or die (mysql_error()); 
mysql_select_db($db_database) or die (mysql_error()); 
 
 
// Alle Tabellen der Datenbank ermitteln 
 
$resTables = mysql_list_tables($db_database, $db_con_id); 
if (!$resTables) { 
	echo "DB Fehler, Tabellen koennen nicht ermittelt werden: " . mysql_error(); 
	exit; 
} 
 
 
// Alle Tabellen der Datenbank sequentiell durchlaufen 
 
while ($tables = mysql_fetch_row($resTables)) { 
	echo 'Tabelle gefunden: '.$tables[0]; 
	// Hier die Export-Routine für die Tabelle aufrufen 
} 
 
mysql_close($db_con_id); 

<?php 
 
$host = 'xxx'; 
$user = 'xxx'; 
$pass = 'xxx'; 
$db = 'xxx'; 
$table = 'xxx'; 
$file = 'xxx'; 
 
$link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error()); 
mysql_select_db($db) or die("Can not connect."); 
 
$result = mysql_query("SHOW COLUMNS FROM ".$table.""); 
$i = 0; 
if (mysql_num_rows($result) > 0) { 
while ($row = mysql_fetch_assoc($result)) { 
$csv_output .= $row['Field']."; "; 
$i++; 
} 
} 
$csv_output .= "\n"; 
 
$values = mysql_query("SELECT * FROM ".$table.""); 
while ($rowr = mysql_fetch_row($values)) { 
for ($j=0;$j<$i;$j++) { 
$csv_output .= $rowr[$j]."; "; 
} 
$csv_output .= "\n"; 
} 
 
$filename = $file."_".date("Y-m-d_H-i",time()); 
header("Content-type: application/vnd.ms-excel"); 
header("Content-disposition: csv" . date("Y-m-d") . ".csv"); 
header( "Content-disposition: filename=".$filename.".csv"); 
print $csv_output; 
exit; 
?>