New answers tagged export
You can concatenate output to CSV, like select email || ',' || firstname from account with column header turned off using set heading
As @Rick James has already said CREATE TABLE ... with the columns approximating the Excel columns. LOAD DATA LOCAL FILE ... into that table in MySQL. I am just goin to explore a bit more. I am writting the steps by steps the procedure based on (SQLyog,MySQL Workbench) tool . How you shall import excel file or CSV file into Mysql DB. 1) ...
This issue has been dealt with here. The approach described therein assumes that you have already separated your schema dump by filename. However, if I've understood you correctly, you have a schema dump from which you wish to extract a single file? I have written a small tool which extracts individual table data separately from a schema dump file. It's ...
This is possible using piecemeal restore. The source database's objects and filegroups have to be organised in a way that supports this. The RESTORE requires additional specific keywords. While the concept may take a little bit of getting used to, the amount of scripting to implement is no more than that for other solutions suggested.
Top 50 recent answers are included