Mysql load dump

Mike Bonner bonnmike at gmail.com
Wed Feb 14 11:12:27 EST 2018


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.

On Wed, Feb 14, 2018 at 8:31 AM, Ludovic THEBAULT via use-livecode <
use-livecode at lists.runrev.com> wrote:

> Hello,
>
> I want to load a dump from an livecode app but i don’t know how to do it.
>
> I’ve tried :
>
> answer file  « Your dump :"
>
> put "source " & quote & it & quote into tSQL
>
> revExecuteSQL tDatabaseID, tSQL
>
>
> Without success.
>
> Any ideas ?
>
> Thanks
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



More information about the Use-livecode mailing list