How do I activate File/Export in Libre Base?

Yes, I went to Tools/Options/LibreOffice/General and checked the box Use LibreOffice dialogs. Still dimmed.

Base is somewhat different than the others. What are you attempting to accomplish?

I want to send a database. I see one can email a database, i.e., the odb file, but the data resides in the configuration file, so that doesn’t appear to work. One can also export individual tables via libre calc, but that is tedious for an entire database. I thought there might be a resolution in the File/Export command.

What type of DB are you talking about: embedded; split; external (which one)?

What type of DB are you talking about: embedded; split; external (which one)?

Embedded in Base.

See my answer. I don’t see any reason you can’t send the .odb in an email. Just completed a test sending an embedded DB and had no problems.

Based upon you comment, if using an embedded DB, the .odb contains the all the data already and you can email as is. If you are talking of a split DB, zip (or archive) the entire folder, rename the extension (change .zip to something else) because most email services wont allow zipped files, then provide instructions to the recipient. If an external DB (MySQL, PostgreSQL etc.) then email two items, the .odb & a dump of the database from the server.

Thank you for the comprehensive answer. I see now that my database is not embedded, it is split. Also that conversion is not trivial, requires some work.

On Linux the whole process takes less than 30 seconds. The real time consumption is let the recipient know what to do.

If the answer solves your question please tick the :heavy_check_mark:.

I have found the sql ‘script’ command useful. SCRIPT ‘filename’ stores all the tables and much other information. The whole thing, or parts of it can then be run as a sql command to restore data. Particularly useful if you need to modify a large table.