PHP SOLUTIONS: DYNAMIC WEB DESIGN MADE EASY (Web hosting support) If
PHP SOLUTIONS: DYNAMIC WEB DESIGN MADE EASY If you plan to use InnoDB, you need to tell MySQL where to store the data. The InnoDB engine uses a single tablespace that acts as a sort of virtual file system. InnoDB files, once created, cannot be made smaller. The default location for the tablespace is C:Program FilesMySQLMySQL Server 5.0data. If you want to locate the tablespace elsewhere, the drop-down menu offers some suggested alternatives. When you have made your choice, click Next. 6. Leave the next dialog box at the default Decision Support (DSS)/OLAP and click Next. 7. The next dialog box sets the networking options and SQL mode. The important settings are in the top half. Make sure Enable TCP/IP Networking is checked, and leave Port Number on the default setting of 3306. The lower half of the dialog box lets you choose whether to run MySQL in strict mode. In an ideal world, you should accept this default setting, but it may cause problems with some PHP applications written before strict mode was introduced. Deselect the Strict mode check box and click Next. 8. MySQL has impressive support for most of the world s languages. The next dialog box invites you to choose a default character set. In spite of what you might think, this has no bearing on the range of languages supported all are supported by default. The character set mainly determines the order in which data is sorted. Unless you have a specific reason for choosing anything other than the default Standard Character Set, I suggest that you accept it without making any changes, as shown. Click Next. 9. The recommended way of running MySQL is as a Windows service. If you accept the defaults as shown in the top half of the next dialog box, MySQL will always start automatically when you boot your computer and run silently in the background. (If MySQL has already been installed as a Windows service, this section will be grayed out.) If for any reason you don t want MySQL to start automatically, uncheck the Launch the MySQL Server automatically option. You can easily change this option later (see the section Starting and stopping MySQL manually on Windows later in this chapter).
We would like to recommend you tested and proved virtual web hosting services, which you will surely find to be of great quality.