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,
On Mon, May 23, 2016 at 4:46 AM, Paul Dupuis wrote:
> this app may use MySQL (or someday, possible other flavors of
> SQL database) and I'd like to have a generalized routine that just
> relies on LiveCode and "standard" SQL commands.
>
If you are using MySQL why not have a look at DUMP. This is n
Check out LiveCloud for LiveCodehttps://livecloud.io
Addresses the cloning element but it's seems like a closed database
architecture so you have to adopt their model
I've played with it but yet to build anything production grade with it.
The team is extremely helpful and stays with you every ste
Check out LiveCloud for LiveCodehttps://livecloud.io
Addresses the cloning element but it's seems like a closed database
architecture so you have to adopt their model
I've played with it but yet to build anything production grade with it.
The team is extremely helpful and stays with you every ste
On 5/22/2016 11:19 AM, Mike Bonner wrote:
> If you just need to duplicate the database, would making a copy of the file
> be sufficient?
>
Yes. I should have been clearer. While I could just copy the file for a
sqlite db, this app may use MySQL (or someday, possible other flavors of
SQL database)
If you just need to duplicate the database, would making a copy of the file
be sufficient?
On Sun, May 22, 2016 at 9:15 AM, Paul Dupuis wrote:
> Does any one have a good script they might care to share for cloning a
> SQLite database?
>
> the basic model is to use revDatabaseTableNames(databaseI
Does any one have a good script they might care to share for cloning a
SQLite database?
the basic model is to use revDatabaseTableNames(databaseID) to get the
list of tables in the source database and then loop through getting each
tables schema and data and recreate that in the target database.
