Use mysqldump to Export All Tables from an MySQL Database to CSV Files
Preface This solution will download all tables in a single database to flat files so you can keep a backup copy or if you want to work with the data outside of mysql. Prerequites Make sure the directory you are exporting to when using the mysqldump command has permissions to write to, otherwise you will