¿ªÔÆÌåÓý

Re: Recovering deleted database #database


 

On 03 Jan 2020 21:40, Hakan Karag?z wrote:

Is it possible to recover an old database file that has been deleted?
No, you should make a habit of first exporting before deleting.

You can export a database as JSON (I'm not sure why) and CSV. You can later import rows from the CSV file again (although you have to create the database structure manually first before you import the CSV rows).

The CSV format exported by Groups.io is: UTF8 without BOM, comma delimited, double quotes escaped by doubling, and no double quotes around fields that do not require double quotes.

(Groups.io can also import CSV files in UTF8 with BOM, but it can't import e.g. UTF16LE. It can also import CSV with double quotes around fields that do not require double quotes.)

There appears to be a database limit of about 5000 rows, with no error messages given if you attempt to import more than 5000 rows.

Samuel

Join [email protected] to automatically receive all group messages.