Re: Mysql load dump

> 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 >

Re: Mysql load dump

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

Re: Mysql load dump

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

Re: Mysql load dump

> 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"

Re: Mysql load dump

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

Mysql load dump

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 ___