Advanced Installer 11.9 based on IIS packaging notes (for MySQL)

Original: Advanced Installer 11.9 based on IIS packaging notes (for MySQL)

MySQL free installation pre-deployment

• Download the green command-line version of MySQL, put it into the published program release package, perform the update batch, enter a custom port number, choose a non-conflicting number, such as 3310;
• Run scripts to start the MySQL service
• Prepare the database SQL script and create a new empty database after connecting with Navcat
• Open a command-line window and go to the MySQL bin directory
• First connect MySQL, Run command statement mysql-p3310-uroot-p--default-character-set=utf8, enter default password root
• Switch to the new database, use library name
• Import Database script, source D:\xx.sql
• Use Navcat to see if the import was successful

Packaging process

• New Enterprise Project
• Product Details Enter a text message such as name, company, or personal name
• Resource--files and Folders,application folder Add program release package, right-click property to set directory Read and Write permissions
• Package Definition--builds,package type Select single EXE setup
• Requirements--prerequiresites, tick the environment software, here the main tick. NET Framework
• User Interface, mainly to see if a custom dialog box is required
• Server---IIS

1. Create a new application pool with a drop-down option at the top of the right and default to basic pool Settings
   
2. Basic Pool Settings:start Mode select Always Running, tick Start application Pool immediately after Install,.net framework version selected Choose v4.0
3. Identify:use built-in User Count select Applicationpoolidentity
4. Create a new site, the basic information is not set to remain the default, BINDINGS/SSL can set the port; application pool Specify the application pools; ASP. NET specify version and tick the three check boxes below it

• Replace fixed text content with a variable: Select files and Folders in the left sidebar, click the Files button at the top menu bar, create a new Web. config mapping file, replace the content that you need to customize during installation, switch to the Attributes tab, and Symbol outbound variable filter; directly double-click the My.ini file in MySQL to replace the contents of the Port,basedir ([Appdir]); For batch files, use the text file Update, and the name must be the same as the batch file name. and replaced in replace, a number of different replacement content, you need to create multiple replace;
• Custom Behavior-Custom Actions: Add lanch file, enter [in File to Lanch box, select MySQL's two batch script in the., and check the three checkboxes below, where MySQL installs the script, Exection time Select when the system is being modified,execution Stage Condition, remove Uninstall and maintenace, and install excution in the middle column In the stage, move the script under Add resources; MySQL unload script, exection time select Immediately,execution Stage Condition, remove install and maintenace, and move the script below paths Resolution in the middle bar install excution stage
  

Advanced Installer 11.9 based on IIS packaging notes (for MySQL)