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

Batch Export into CSV

User, date Message
Written by rsanghi
4 years ago
Category: Import/Export
1 posts since Mon, 21 Feb 11
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?

Written by ansgar
4 years ago
5045 posts since Fri, 07 Apr 06
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.
Written by brazil
4 years ago
16 posts since Thu, 27 Jan 11
... or mysqldump or (very comfortable) MySQL Workbench OSS.
 

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