u3 rev application with mysql/apache

Wed Aug 2 11:28:25 EDT 2006

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 

-------Original Message------- 

From: Robert Mann 
Date: 08/02/06 14:50:19 
To: How to use Revolution 
Subject: RE: u3 rev application with mysql/apache 

Not sure how to code the call to start the mysql is there a sample out there

somewhere? 

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 2:39 AM 
To: How to use Revolution 
Subject: RE: u3 rev application with mysql/apache 

Hi, 

You have to call Mysql from the main application while it is loading or on 
demand. Autorun wont start it automatically from a thumbdrive. 

Viktoras 

-------Original Message------- 

From: Robert Mann 
Date: 08/02/06 00:46:09 
To: How to use Revolution 
Subject: RE: u3 rev application with mysql/apache 

tying to get your suggestion to work I have it so that it opens my app which

is the first 5 lines but I am not able to get the mysql started here is my 
autorun.inf 

[autorun] 

action=SNmain.exe 
open=/SNmain/Windows/SNmain.exe 
shellexecute=/SNmain/Windows/SNmain.exe 
shell\Auto=&SNmain.exe 
shell\Auto\command=/SNmain/Windows/SNmain.exe 

action=xampp_start.exe 
open=/xampp/xampp_start.exe 
shellexecute=/xampp/xampp_start.exe 
shell\Auto=&xampp_start.exe 
shell\Auto\command=/xampp/xampp_start.exe 

Icon=sn.ico 
shell=Auto 
label=Suspension Network 

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: Monday, July 31, 2006 3:16 PM 
To: How to use Revolution 
Subject: Re: u3 rev application with mysql/apache 

Hi Robert, 

you do not need U3 drive for this. Some cool things can be done with 
ordinary flashdrives. For MS Windows you use Autorun.inf like this:[autorun]

action=NAME_OF_YOUR_APP 
open=your_app.exe 
shellexecute=your_app.exe 
shell\Auto=&NAME_OF_YOUR_APP 
shell\Auto\command=your_app.exe 
Icon=your_icon.ico 
shell=Auto 
label=NAME_OF_YOUR_APP 

What you get is: 
1) after insertion of the flashdrive your_icon will appear instead of the 
default flashdrive icon; 
2) if autoplay on users machine is enabled it will show NAME_OF_YOUR_APP 
with your_icon as the first choice in autoplay menu and will allow to launch

your app from there; 
3) it will launch the application on doubleclicking the flash_drive's icon 
(your_icon) 
4) it will provide the first option in the context menu as NAME_OF_YOUR_APP 
(upon right mouse-click on flash-drive's icon) 
5) it WILL NOT launch your application automatically on startup, which is 
good from a security point of view... 

For MacOS this tool can be of some use: 
http://www.naratt.com/MultipleLauncher.html 

I think it is more than enough for a non-U3 drive. I am also bundling my 
Contents Management Soft with Apache this way :-). 

All the best 
Viktoras 

-------Original Message------- 

From: Robert Mann 
Date: 07/31/06 22:19:27 
To: rev list 
Subject: u3 rev application with mysql/apache 

I am building a rev standalone that works in conjunction with a mysql 
database, so If I bundle a install I need to also check first to see if 
apache is installed if not then install it with a mysql database, so was 
thinking that maybe this new u3 drive I can preinstall everything on it so 
then all I need to send the use is a flash drive, any thoughts as to is this

will be possible to run apache/mysql/rev application all within a u3 flash 
drive? 

Robert Mann 
President 
GP Racing LLC 

_______________________________________________ 
use-revolution mailing list 
use-revolution at lists.runrev.com 
Please visit this url to subscribe, unsubscribe and manage your subscription

preferences: 
http://lists.runrev.com/mailman/listinfo/use-revolution 
_______________________________________________ 
use-revolution mailing list 
use-revolution at lists.runrev.com 
Please visit this url to subscribe, unsubscribe and manage your subscription

preferences: 
http://lists.runrev.com/mailman/listinfo/use-revolution 

_______________________________________________ 
use-revolution mailing list 
use-revolution at lists.runrev.com 
Please visit this url to subscribe, unsubscribe and manage your subscription

preferences: 
http://lists.runrev.com/mailman/listinfo/use-revolution 
_______________________________________________ 
use-revolution mailing list 
use-revolution at lists.runrev.com 
Please visit this url to subscribe, unsubscribe and manage your subscription

preferences: 
http://lists.runrev.com/mailman/listinfo/use-revolution 

_______________________________________________ 
use-revolution mailing list 
use-revolution at lists.runrev.com 
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences: 
http://lists.runrev.com/mailman/listinfo/use-revolution