Hi, Just yesterday I have finished doing something very similar ( Apache+PHP+MySQL+Database+PHP-Application ) installer for a demo site. The setup installs the Apache service, the MySQL service and database and start the services. On unistall it removes the services, leaving all clean. The idea is as follows :
1. Create ( and populate ) the database in MySQL on your computer. 2. Create the user needed for your database and remove unneeded users 3. Create an empty folder where to store your application's files ( eg. C:\APP ) 4. Copy the entire MySQL directory from your install into this folder ( eg. C:\APP\MySQL ) 5. Remove any unneeded files from C:\APP\MySQL - you will have to remove other databases, these are stored in c:\APP\MySQL\Data , each database has its own directory. Delete everything but "MySQL" and "Your_database_name" folders. In the "bin" folder you can delete anything but the server you use ( eg. mysqld-nt.exe ) 6. Create or copy a "my.ini" file in c:\APP\MySQL and write any configurtion preferences in it ( like base_dir, port, innodb prefs, etc ) The installer should : 1. Copy the content of c:\APP folder on client's computer 2. Run the command c:\app\mysql\bin\mysqld-nt.exe --install MySQL --defaults-file="c:\app\mysql\my.ini", this will install the MySQL service 3. Run the command "net start MySQL", this will start the MySQL service, "MySQL" is the name of the service, you can set it to anything you like as long as you use same name after "--install" and "--remove" ( eg. ".... --install My_Name_for_mysql_service ...." then "net start My_Name_for_mysql_service" That would be all, the server will be installed with your database. The ammount of interaction during install depends on how you make the installer ( you can make even a BAT file ). For the installer I have used "Inno Setup", available here http://www.jrsoftware.org/isinfo.php , it is free and very easy to use. If you need to uninstall the app, uninstaller should : 1. Stop the MySQL service : "net stop MySQL" 2. Remove the MySQL service : "c:\APP\MYSQL\BIN\mysqld-nt.exe --remove MySQL" 3. Delete the "c:\APP" folder That would be all, hope it helps. -- -------------------------------- Puiu Hrenciuc Xentra Development ""Jim"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > > Hi All, > > > > Does anybody have some advise on automating the install of mySQL and our > DB > on a PC/Laptop with no user interaction required. > > Does the SETUP.EXE take any paramaters to auto install without the user > dialogs? > > > > Thanks, > > Jim > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
