> Le 14 févr. 2018 à 18:18, Mike Bonner via use-livecode
> a écrit :
>
> DOH, I see it in the subject now.
>
> If you can get to a command line where the db server resides, you can use
> the mysql client to do the import, or if phpmyadmin is available, you can
> use its interface to import the
mySQLWorkbench has an import/export feature you may be able to use. It's free.
If you are trying to build this feature into LC, I would attempt the sql syntax
in an editor on a test database first and see if it generates any errors.
Bob S
> On Feb 14, 2018, at 09:18 , Mike Bonner via use-live
DOH, I see it in the subject now.
If you can get to a command line where the db server resides, you can use
the mysql client to do the import, or if phpmyadmin is available, you can
use its interface to import the dump. IIRC livecode doesn't like sending
multi-line sql to mysql (though it works i
> Le 14 févr. 2018 à 17:12, Mike Bonner via use-livecode
> 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 [[tpa
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 fro
