Mysql load dump
bobsneidar at iotecdigital.com
Wed Feb 14 12:25:15 EST 2018
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 <use-livecode at lists.runrev.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. )
More information about the Use-livecode