How can i export a mysql table located on a webserver into a local folder?
I made something like
select user,"The company" as memo into outfile 'data.txt'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
from member
inner join member on balance.memberid=member.memberid where balance.status=1
I would like to know if it will appear to an user that save/open screen
Export a mysql table to a local file
Moderator: General Moderators
-
fastfingertips
- Forum Contributor
- Posts: 242
- Joined: Sun Dec 28, 2003 1:40 am
- Contact:
-
fastfingertips
- Forum Contributor
- Posts: 242
- Joined: Sun Dec 28, 2003 1:40 am
- Contact:
something like this perhaps
Code: Select all
<?php
// Make the browser save as a file
header('Content-type: text/plain');
header('Content-Disposition: attachment; filename=datadump-'.date('Ymd').'.sql');
// Change these
$db = 'database';
$user = 'username';
$pass = 'password';
$mysqldump = '/usr/bin/mysqldump' // This may differ, some systems may use /usr/local/mysql/bin/mysqldump
passthru($mysqldump.' -u '.escapeshellarg($user)
.' --password='.escapeshellarg($pass)
.' --opt '.escapeshellarg($db)
);
die(); // prevent any additional output
?>-
fastfingertips
- Forum Contributor
- Posts: 242
- Joined: Sun Dec 28, 2003 1:40 am
- Contact: