2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
m
→Export / Backup: Added export as CSV
(→Maintenance: Added "Export / Backup") |
m (→Export / Backup: Added export as CSV) |
||
| Line 294: | Line 294: | ||
# Exclude certain tables | # Exclude certain tables | ||
mysqldump -u root -p dbname --ignore-table=dbname.table1 --ignore-table=dbname.table2 > dbname.sql | mysqldump -u root -p dbname --ignore-table=dbname.table1 --ignore-table=dbname.table2 > dbname.sql | ||
# Export a table as CSV | |||
SELECT * INTO OUTFILE '/tmp/table.csv' | |||
FIELDS TERMINATED BY ',' ENCLOSED BY '' ESCAPED BY '\\' | |||
LINES TERMINATED BY '\n' FROM table; | |||
</source> | </source> | ||