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.
> On Feb 14, 2018, at 09:18 , Mike Bonner via use-livecode
> <email@example.com> wrote:
> 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 in sqlite) so it might be possible
> to parse the file line by line and send each line in sequence. (No clue
> what other hoops you might need to jump through to do this though. )
use-livecode mailing list
Please visit this url to subscribe, unsubscribe and manage your subscription