Peuplarchie Posted May 25, 2010 Share Posted May 25, 2010 Good day to you, I have added an options to my db production site which is to back up the table into csv file, see code below. Now I would like to be able to export to sql file, how would I do it without using phpMyadmin , I would like to use a function like the following. <?php $host = 'localhost'; $user = '....'; $pass = '....'; $db = '....'; $table = $_GET[table][tr][td]; $file = 'export'; $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 = "Backup__".$table."__".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; echo "Exporting..."; ?> Thanks! [/td][/tr][/table] Quote Link to comment Share on other sites More sharing options...
andrewgauger Posted May 25, 2010 Share Posted May 25, 2010 $Results = shell_exec("mysqldump -u$User -p$Password $DatabaseName > $file"); Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.