Back Up database as csv file

Hi


I search for a sample code for back up database as csv file.

I found this code:

<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'payroll';
$table = 'generate_payroll';
$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 = $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;
?> 

Code (markup):

when I run this code, theres a pop up window asking if i want to open or save, when i click open or save i got an error.

I got a pop up Window Internet Explorer

Saying:
Internet Explorer was not able to open this internet site. The requested site is either unavailable or cannot be found.Please try again.


Thank you

 

Use phpMyAdmin and click on export and select the options to meet your requirements for csv file

 

Why CSV? and dod you try BIGDUMP? search for it!

 

There is a small paid script that implements it, here:
http://www.scriptbaba.com/details-sql-to-csv-exporter-12.html

I hope it helps.

 

A csv file isn't actually an excel file, it's a text file. (Most people use the default file associations, in which .csv is opened by Excel, but you can change that to open .csv files with a text editor.) Try changing your

("Content-type: application/vnd.ms-excel");

into a header, and make it text/plain.

 

If you using mysql then you can use the built in function of mysql to export the data