Ipower web hosting - PHP SOLUTIONS: DYNAMIC WEB DESIGN MADE EASY 13.
PHP SOLUTIONS: DYNAMIC WEB DESIGN MADE EASY 13. If you want to change the configuration at a later date, launch the Configuration Wizard from the Windows Start menu by choosing Programs . MySQL . MySQL Server 5.0 . MySQL Server Instance Config Wizard. The dialog box that opens offers the following two options: Reconfigure Instance: This takes you through all the dialog boxes again. Remove Instance: This does not remove MySQL from your system, but removes the Windows service that automatically starts MySQL when you boot your computer. Unfortunately, it also removes the MySQL configuration file. See Starting and stopping MySQL manually on Windows for a less radical solution. Changing the default table type on Windows Essentials The instructions in this section are required only if you selected Multifunctional Database in step 4 of Configuring MySQL Windows Essentials. The Windows Configuration Wizard sets InnoDB as the default table storage engine for a multifunctional database. Since most hosting companies don t support InnoDB, you should reset the default to MyISAM. All it requires is a simple change to the MySQL configuration file: my.ini. 1. Use Windows Explorer to navigate to the folder in which MySQL was installed. The default is C:Program FilesMySQLMySQL Server 5.0. 2. Locate the file called my.ini, and double-click it. The file will open in Notepad. 3. Approximately 80 lines from the top you should find a line that reads as follows: default-storage-engine=INNODB Change it to the following: default-storage-engine=MyISAM 4. Save the file and close it. To make the change effective, restart MySQL. MySQL will now create all new tables in the default MyISAM format. To use the InnoDB format for a database, you can change the table type in phpMyAdmin, the graphical interface for MySQL that you will install later in the chapter. Starting and stopping MySQL manually on Windows Most of the time, MySQL will be configured to start up automatically, and you can forget about it entirely. There are times, however, when you need to know how to start or stop MySQL manually whether for maintenance, to conserve resources, or because you re paranoid about security (a physical firewall is probably a much better solution). 1. Select Control Panel from the Windows Start menu. Double-click the Administrative Tools icon and then double-click the Services icon in the window that opens. 2. In the Services panel, scroll down to find MySQL and highlight it by clicking once. You can now use the video recorder type icons at the top of the panel to stop or start the server. The text links on the left of the panel do the same.
In case you need affordable webhost to host your website, our recommendation is ecommerce web host services.