You can now export your Vitess database data in multiple formats using the new --output-format flag with the pscale database dump command.
The new flag supports three output formats:
sql(default) - MySQL INSERT statements for direct importjson- JSONL format with one JSON object per linecsv- CSV format with headers for easy analysis
# Export as JSON pscale database dump my-database main --output-format=json # Export as CSV pscale database dump my-database main --output-format=csv # Export as SQL (default) pscale database dump my-database main --output-format=sql
This feature is available for Vitess databases only.
Thanks to @ivov for contributing this feature!