distal-attribute
distal-attribute
distal-attribute
distal-attribute

Batch Export into CSV

rsanghi posted 4 years ago in Import/Export
I have a database with over 200 tables. Is there one command that can convert all those tables into CSV files? Or do I have to do this separately for each table in the database?

ansgar posted 4 years ago
Not doable in one step via HeidiSQL - one step per table is required. However, CSV is not the preferred backup method as there are many things in a database which cannot be presented in a CSV file. Use the "Export database as SQL" instead if you like to have stable backups.
brazil posted 4 years ago
... or mysqldump or (very comfortable) MySQL Workbench OSS.

Please login to leave a reply, or register at first.