charlesg wrote: > Hi > > Why not something like: > SHELL "mysql -u root stock < /home/charles/mySQLbackup/stockDump.sql" WAIT > you could also specify a remote server. > where stockDump.sql was created by mysqldump. > > rgds > > If you want to input the sql password too (ie without any user interaction) you have to use something else, like this for example:
SHELL "mysql --host=" & sSQLHost & " --user=" & sSQLUser & " --password=" & sSQLPass & " --execute='SOURCE " & sDumpFile & "'" WAIT Look here for the complete routine I use to upgrade the database of my application upon program start: http://www.domotiga.nl/browser/trunk/DomotiGa/Main.module#L4808 Regards, Ron_2nd. ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
