You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This change implements a new output mode for CSV files.
The new command option `--output-csv=...` enables CSV output mode, and must be given the path to a directory. The output mode will create `.csv` files in the given directory, named according to the dumped tables.
This output format does not support output redirection from `stdout` as the default MySQL SQL format does.
CSV files will be created only for tables that contain data. In other words, `schema` type dumps will skip the table in question. Also, dumping views/triggers makes no sense for CSV files, they will be skipped as well.
How to best write binary (BLOB) data and/or NULL values in CSV files is probably highly controversial. For now, we'll just go with the [`0x...` hex literals supported by MySQL](https://dev.mysql.com/doc/refman/8.0/en/hexadecimal-literals.html). Maybe having binary data in CSV files is not a sane idea in the first place.
Co-authored-by: Matthias Pigulla <mp@webfactory.de>
This option turns on the CSV (comma separated values) output mode. It must be given the path to a directory where `.csv` files will be created. The files are named according to tables, e. g. `my_table.csv`.
73
+
74
+
CSV files contain only data. They are not created for views, triggers, or tables dumped with the `schema` dump mode. Also, no files will be created for empty tables.
75
+
76
+
Since this output format needs to write to different files for different tables, redirecting `stdout` output (as can be done for the default MySQL SQL mode) is not possible.
77
+
78
+
**Experimental Feature** CSV support is a new, [experimental feature](https://github.com/webfactory/slimdump/pull/92). The output formatting may change at any time.
79
+
70
80
## Configuration
71
81
Configuration is stored in XML format somewhere in your filesystem. As a benefit, you could add the configuration to your repository to share a quickstart to your database dump with your coworkers.
72
82
@@ -254,4 +264,4 @@ If you're a developer looking for new challenges, we'd like to hear from you! Ot
254
264
-<https://www.webfactory.de>
255
265
-<https://twitter.com/webfactory>
256
266
257
-
Copyright 2014-2020 webfactory GmbH, Bonn. Code released under [the MIT license](LICENSE).
267
+
Copyright 2014-2022 webfactory GmbH, Bonn. Code released under [the MIT license](LICENSE).
$output->getErrorOutput()->writeln('<info>The MySQL "max_execution_time" timeout setting has been disabled for the current database connection.</info>');
122
-
}
141
+
$output->writeln('<info>The MySQL "max_execution_time" timeout setting has been disabled for the current database connection.</info>');
0 commit comments