Your ads will be inserted here by

Easy Plugin for AdSense.

Please go to the plugin admin page to
Paste your ad code OR
Suppress this ad slot.

Mysql Dump OUTFILE
Dumping mysql database table

This way we can dump any particular database table (as csv export) and Restore (as csv import).

SELECT * FROM database.table WHERE filed='string' INTO OUTFILE '/tmp/orders.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n';
LOAD DATA INFILE "/tmp/orders.csv" INTO TABLE table FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY """" LINES TERMINATED BY "n";