Batch Export into CSV

1 posts
[expired user #5540]'s profile image [expired user #5540] posted 13 years ago in Import/Export Permalink
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?

10134 posts
ansgar's profile image ansgar posted 13 years ago Permalink
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.
16 posts
[expired user #5483]'s profile image [expired user #5483] posted 13 years ago Permalink
... or mysqldump or (very comfortable) MySQL Workbench OSS.

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