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.

  • NULL stays 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.

0 views Something unclear? Open an issue on GitHub