Mysql load dump

Ludovic THEBAULT ludovic.thebault at laposte.net
Wed Feb 14 11:46:52 EST 2018


> Le 14 févr. 2018 à 17:12, Mike Bonner via use-livecode <use-livecode at lists.runrev.com> a écrit :
> 
> If this is sqlite, you might be able to use the .read dot command.. (note
> the nearly invisible period that begins .read)
> 
> Untested, but this might work.
> 
> put "path/to/dump.sql" into tPath
> put merge(".dump [[tpath]]") into tSql
> revexecutesql tDatabaseId, tsql
> 
> If the dump is IN to sqlite, but is from another db (mySQL or whatever) it
> might not work.
> 
> Oh, if its sqlite and you still have access to the first database file, it
> should be possible to a) open the new database, b) attach the old database
> and c) copy the tables you need from one to the other, then d) detach the
> old database and you should be good to go.

Thanks, but it’s for Mysql.





More information about the use-livecode mailing list