select TABLE_NAME from information_schema.TABLES where TABLE_SCHEMA='schema';

#for each table from ^
SELECT * FROM schema.table INTO OUTFILE 'table.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';