Batch Export into CSV
| User, date | Message |
|---|---|
|
Written by rsanghi
2 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
2 years ago 3950 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
2 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. |