u3 rev application with mysql/apache

[Robert Mann]

Viktoras
I got the start button to work
on mouseUp
  set the hideConsoleWindows to false
  open process "\xampplite\mysql\bin\mysqld" for neither
 end mouseUp

but I am not able to get the stop to work (password=    is correct for
user=pma)

#stop the server
on mouseUp
  put "\xampplite\mysql\bin\mysqladmin -" & " -password=  shutdown" into
theCommand
  set the hideConsoleWindows to false
  get shell(theCommand)

end mouseUp

Thanks


Robert Mann
President
GP Racing LLC

-----Original Message-----
From: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com]On Behalf Of Viktoras
Didziulis
Sent: Wednesday, August 02, 2006 10:28 AM
To: How to use Revolution
Subject: RE: u3 rev application with mysql/apache


Hi Robert,

try this with 3 buttons:

#start the server
on mouseUp
set the hideConsoleWindows to true
open process "MySQL Server 5.0\bin\mysqld" for neither
end mouseUp

#stop the server
on mouseUp
put "MySQL Server 5.0\bin\mysqladmin -" & "-password=kristupukas shutdown"
into theCommand
set the hideConsoleWindows to true
get shell(theCommand)
end mouseUp

#show server status
on mouseUp
put "MySQL Server 5.0\bin\mysqladmin -" & "-password=kristupukas status"
into theCommand
set the hideConsoleWindows to true
get shell(theCommand)
answer it
end mouseUp

This should do the job.

Instead of using buttons you may want to load server (scripts of the stack):

on startup
put "MySQL Server 5.0\bin\mysqladmin -" & "-password=kristupukas shutdown"
into theCommand
set the hideConsoleWindows to true
get shell(theCommand)
end startup

and close it with:
on closeStack
put "MySQL Server 5.0\bin\mysqladmin -" & "-password=kristupukas shutdown"
into theCommand
set the hideConsoleWindows to true
get shell(theCommand)
end closeStack

Viktoras