Mysql load dump
ludovic.thebault at laposte.net
Wed Feb 14 14:25:20 EST 2018
> Le 14 févr. 2018 à 18:18, Mike Bonner via use-livecode <use-livecode at lists.runrev.com> 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 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. )
I wanted to use my favorite tool, Livecode, to create a script to automate this but making a query for each dump line is not the cleanest.
More information about the Use-livecode