Mysql load dump

[Bob Sneidar]

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