Cloning a SQLite (or any SQL) database

[Bob Sneidar]

Not so. I use MySQLWorkbench from a remote computer to save the database locally on my laptop all the time. However, large SQL databases might be very time consuming to do remotely.

I have a Database Setup card which is capable of copying the data from one SQL database to another using queries, and as it connects to the database, it saves an array of the database schema, so that it can be recreated in case the database goes the way of the dodo.

I'd share it, but it is not fully functional in all respects, and I have not really fully tested and debugged it. But it's not too dificult to do something like this.

Bob S


On May 22, 2016, at 23:04 , Kay C Lan <lan.kc.macmail at gmail.com<mailto:lan.kc.macmail at gmail.com>> wrote:

If memory serves me I think the only limitation is you must be doing
this on the same machine as the MySQL server, you can't do it over a
network connection.