Exporting
Exporting
Exports run in a background job with progress and cancel, and the file is downloaded through a short-lived signed link.
#SQL dumps
Export a whole database, or chosen tables, to .sql or .sql.gz with mysqldump:
- a consistent snapshot (
--single-transaction); - routines, triggers and events included;
- ready to re-import anywhere, including back into DBNova.
10 million rows (3.7 GB of SQL) export to a 261 MB .sql.gz in about 26 seconds.
#CSV
Export one table, or the full result of a SQL editor query, to .csv or .csv.gz.
NULLstays distinguishable from empty text.- Query exports are read-only.
- Safe for spreadsheets (optional): text starting with
=,+,-or@gets a leading', so Excel, Numbers and Google Sheets don't run it as a formula. Numbers are never changed.
#Keeping files
Export files are kept for 24 hours and download links work for 60 minutes by default. Each user can keep up to 10 finished exports at once.