Data Dumping

-- Preview data from interesting tables
SELECT * FROM <table> LIMIT 10;

-- Dump a table to disk (if FILE privilege + secure_file_priv allows it)
SELECT id, name, email 
INTO OUTFILE '/var/lib/mysql-files/users_export.csv'
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '\n'
FROM users;

-- Import file into table
LOAD DATA INFILE '/var/lib/mysql-files/data.csv'
INTO TABLE my_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;