Viktoras thanks for the help I am not having any luck getting it to work so I guess I need to ask a few more questions. I have been using xampp for the mysql install now that I understand that I do not need the apache is there something else I should use? where should I place all the apps, all in one dir or separate, here is how it is setup right now on the flash drive rev application is in the root mysql is in the xampp\mysql\
I also notice that if I move my flash drive to a different computer and the drive letter changes like from l to m and I click on the mysql_start I get a error message is there a way to correct this so that it will change to the proper drive letter? also this line "-password=kristupukas shutdown" in your code should I be changing it to "-password=mypassword shutdown" is this correct from below? on startup put "MySQL Server 5.0\bin\mysqladmin -" & "-password=kristupukas shutdown" into theCommand set the hideConsoleWindows to true get shell(theCommand) end startup Robert Mann President GP Racing LLC -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 -------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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
