Hi, my dear friends.
I a using sqlite and want to save the database from time to time in a sql file. Simple plain text-file that could be executed in a mysql (for example) db. Usualy they have the extension .sql.
Is there a simple way to make it with ai2?
How are you accessing sqlite on your device? Do you use one of the sqlite extensions?
Perhaps the easiest approach is to export each of your tables to csv then you can import these into mysql?
You may find this useful, it is aimed at google sheets but the extraction sections will work for any requirement:
The alternative is to export your sqlite db to a file, upload this to your server (which is hopefully running linux), and find a suitable bash script that can convert sqlite to mysql db.
I am using Simplesqlite.