First, you need and install MyToTxt.
MyToTxt is a tool to bulk/batch export Mysql data to files.
Using MyToTxt you can bulk/batch export Mysql data to files easily and fast.
Bulk/Batch Export Mysql All Tables – 3 steps
Click “Export All Tables” button.
then show the Unload All Tables form.
1. Select tables to unload.
2. Config unload options.
You can export data to text, csv, excel, xml, html, Excel.
3. Click unload button, Show unload output.
More about MyToTxt – the tool to batch export Mysql tables data