MySQL mysqldump or SEELCT INTO OUTFILE
MySQLDump within PHP:
$shell = 'mysqldump
-u'.$cur_db[user].'
-p'.$cur_db[pass].'
-h '.$cur_db[server].' '.$cur_db[name].' > '.$tmp_file.';';
shell_exec( $shell ) or die( 'mysql:'.mysql_error() );
Alternatives:
SELECT * or field_list
FROM your_table
WHERE your_conditions INTO OUTFILE '/srv/folder/table.dump.file'
$shell = 'mysqldump
-u'.$cur_db[user].'
-p'.$cur_db[pass].'
-h '.$cur_db[server].' '.$cur_db[name].' > '.$tmp_file.';';
shell_exec( $shell ) or die( 'mysql:'.mysql_error() );
Alternatives:
SELECT * or field_list
FROM your_table
WHERE your_conditions INTO OUTFILE '/srv/folder/table.dump.file'
Comments
Write the first comment
Leave a trace
Post being viewed right now
