How to Export each Database Table to separate SQL file with Data in MySQL Workbench - MySQL DBA Tutorial

Export each Database Table to separate SQL file with Data in MySQL Workbench


demo explains how to export each table from MySQL Schema or MySQL Database to separate SQL files. The Export Data feature of MySQL Workbench give you different options so you can choose if you like to export only data, only structure or structure+ data to separate file for each table.

It really helps when you need to import data for only single table. You can load these files to Database tables on same server or different servers by using MySQL Import/ Restore feature.


MySQL Workbench Tutorial - How to export tables to separate files by using MySQL workbench