I am Anders Karlsson, and I have been working in the RDBMS industry for many, possibly too many, years. In this blog, I write about my thoughts on RDBMS technology, happenings and industry, and also on any wild ideas around that I might think up after a few beers.
You can export data from MariaDB using mysqldump and a bunch of other tools, but if you need really flexible output format, this might not be what you need. Instead, give MyMDBDump a try. This tool will export data just like mysqldump, but the output format is a lot more flexible. I urge you to test it and check out the documentation, but some if the features are, in short:
Dynamic column support - Dynamic columns can be exported as binary, JSON or even as SQL, where I think the latter is a pretty unique feature.
Oracle export format - This exports data as INSERT statements, just like mysqldump, but in an Oracle friendly way.
MS SQL / SQL Server format - This exports data as SQL Server friendly INSERTs.
Binary data formats - Supporting plain binary, base64, hex and a number of more formats.
JSON export support - Including embedding dynamic columns as JSON.
UTF8 support and UTF8 validity checking.
Generated ROWNUM column output
FLOAT and DOUBLE formatting
DATETIME, TIMESTAMP, DATE and TIME custom formating.