These settings are applied to all php pages and features with MySQL database (as Shop, Catalog, Blog, Calendar, Newsletter, Online Editable Page, Counter, etc) functions. MySQL is a database management system that runs on your web server providing access to databases created or saved on the site. For example, the list of names and email addresses your mailing list or shop has collected. This data is managed by a MySQL server. You only need a single MySQL database for your website.
- Use MySQL for all online scripts (check box) - Shop and catalog pages always use MySQL database. While Blog, Calendar, Search, Counter, Podcast, etc can work with both flat (plain text) files and MySQL database. If you want to have all PHP features to work with MySQL, check this box and set the MySQL settings below.
- Host Name or IP (edit box) - Enter the hostname of the MySQL server. Most servers use "localhost" as the host name, enter that if you do not have a specific server name.
- Database Name (edit box) - Type the database name to be used. e.g. MySite_SQL_Database
- Username (edit box) - Username for the database login.
- Password (edit box) - Password for the database login.
- Project ID (check box)- If you use single MySQL database for multiple projects, make sure to define here project ID. This ID should serve as a unique prefix.
- Monitor Users (check box) - Use this to monitor how many guests and registered users are browsing your site. EZGenerator Counter is required for this feature. Also, you have to add %GUEST_COUNT%, %USER_COUNT%, %USERS% macros from Macros Fields. These macros are available in the php pages such as Blog, Calendar, etc.
- What's the use of Project ID (a.k.a. project prefix)?
- As mentioned above, multiple projects can be handled by same database. So that means there will be several "users" table (for instance). If many projects use same tables, it will become a project mess. Here the use of project prefix comes in hand. By defining unique table prefix for each project, you ensure the systems won't put data into wrong tables.
- How to use Project ID (what kind of wording to use in this field)?
- Full information about the naming can be found here: http://dev.mysql.com/doc/refman/5.0/en/identifiers.html However, I suggest using only lower case letters and underscore ( _ ).
Table without prefix: ca_users; Table with prefix test_: test_ca_users.
Note: I use underscore after the letters, because it's easyer to read the tables when you open the tables list via external tool. But it's not required.
- When to use Project ID?
- The simple and most correct answer is: ALWAYS. If you have only one project so far and it has no project ID yet, don't change this (adding project prefix to current tables will force tables to be duplicated). But make sure all future projects will have project prefix, and it will be unique for every project.