The MySQL tab enables you to modify configuration settings specific to MySQL databases.
The MySQL tab
MySQL is licensed under a double license: GPL and commercial. For more details, please refer to the MySQL licensing information at the following Web sites:
- MySQL Licensing Policy at: http://www.mysql.com/products/licensing
- MySQL Commercial License at: http://www.mysql.com/products/licensing/commercial-license.html
- MySQL Licensing Policy FAQ at: http://www.mysql.com/products/licensing/faq.html
More information about the MySQL support are explained in the PHP and MySQL FAQs topic.
You can download a preconfigured package for MySQL support in the Add-On Packages topic.
The fields in http.ini specific to the
MySQL section are shown below:
[MySQL] ; MySQL Engine settings Start=1 DemonPath=##DWEBPRO_PATH##\engine\mysql\bin\mysqld.exe BinDir=##DWEBPRO_PATH##\engine\mysql\bin BaseDir=##DWEBPRO_PATH##\engine\mysql DataDir=##DWEBPRO_PATH##\engine\mysql\data Username=H/WxhC Password= CustomParams=--skip-innodb --pid-file="##TEMP##\dwebpro_mysql.pid" ; Network settings Port=3306 FindFreePort=1 ; Startup / Shutdown settings RunLocally=0 ShowShutDownTimeOutMessage=0 ShutDownTimeout=5000 ShutDownOnExit=1 ; File Copy settings CopyDataToHardDisk=0 DestinationDir= DatabaseVersion=1 DeleteOldDatabases=1 ShowCopyProgressWindow=1 AskUserForCopy=0 AskUserForCopyDefaultButton=Yes Overwrite=0 AskUserForOverwrite=0 AskUserForOverwriteDefaultButton=Yes ClearOnShutDown=0 AskUserForClearOnShutDown=0 AskUserForClearOnShutDownDefaultButton=Yes ; Interactice Install settings UseInteractiveInstall=0 SpaceNeeded=1048576
MySQL Engine settings
Start MySQL
Start
Start MySQL specifies whether MySQL is
started upon start up of DWebPro.
Accepted values: 0, 1
Daemon Path
DaemonPath
Daemon Path specifies the path pointing
to the MySQL daemon, normally
mysqld.exe, that
will be opened by DWebPro. Refer to the DWebPro Internal Constants topic for additional information on paths. Accepted values: string
Binary Directory
BinDir
Binary Directory specifies the path of
the directory where the MySQL daemon is located. Refer to the DWebPro Internal Constants topic for additional information on paths.
Accepted values: string
Base Directory
BaseDir
Base Directory specifies the base path
to the directory where the MySQL engine resides. Refer to the DWebPro Internal Constants topic for additional information
on paths.
Accepted values: string
Data Directory
DataDir
Data Directory specifies the path of the directory where the database files reside. Refer to the DWebPro Internal Constants topic for additional information
on paths.
Accepted values: string
Username
Username
Username specifies the user name of a
user that has MySQL shutdown privileges or permissions. Since both
username and password are encrypted, you must use the DWebPro Configurator
to specify these values.
Accepted values: string
Password
Password
Password specifies the password of a
user that has MySQL shutdown privileges or permissions. Since both
username and password are encrypted, you must use the DWebPro Configurator
to specify these values.
Accepted values: string
Custom Params
CustomParams
Custom Params specifies additional parameters
that will be passed to the MySQL daemon at startup.
Accepted values: string
Network settings
Port
Port
Port specifies the port on which MySQL
listens.
Accepted values: integer
Find Free Port
FindFreePort
Find Free Port specifies whether DWebPro
should search for free ports on which to start MySQL. Refer to the DWebPro Internal Constants topic for additional information.
Accepted values: 0, 1
 |
When you use the Find Free Port option, you have to use the ##DWEBPRO_MYSQL_PORT## constant in the connection string to connect to the correct instance of MySQL. Refer to the DWebPro Internal Constants topic for additional information. Here is a PHP example: $host = '127.0.0.1:' . dwebpro_getvar('DWEBPRO_MYSQL_PORT');
mysql_connect($host, 'root', ''); |
Startup / Shutdown settings
Run Locally
RunLocally
Run Locally specifies whether DWebPro
should copy files to the user's file system for running MySQL. Selecting
this option (1), bypasses the copy process and
runs MySQL locally. Note that you can run locally only when you run
DWebPro from a hard drive or other writable media. Using this option
can be useful during the development phase.If you want to run your Web application on CD/DVD, you must
not select this option (0).
Accepted values: 0, 1
Show Shutdown Timeout Message
ShowShutDownTimeOutMessage
Show Shutdown Timeout Message specifies
whether DWebPro prompts the user prior to closing MySQL.
Accepted values: 0, 1
Shutdown Timeout
ShutDownTimeout
Shutdown Timeout specifies the timeout,
in milliseconds, before MySQL is forced to close.
Accepted values: integer
Shutdown on Exit
ShutDownOnExit
Shutdown on Exit specifies whether MySQL
is closed on DWebPro shutdown.
Accepted values: 0, 1
File Copy settings
Copy Data to Hard Disk (from data directory to destination
directory)
CopyDataToHardDisk
Copy Data to Hard Disk specifies whether
the MySQL database is copied to the user's hard drive.
Accepted values: 0, 1
Destination Directory
DestinationDir
Destination Directory specifies the path
of the directory to which the database files will be copied. Refer
to the DWebPro Internal Constants topic for additional
information on paths.
Accepted values: string
Database Version
DatabaseVersion
Database Version specifies the version
of the MySQL database. If you want to distribute your application
with different versions of the database or distribute an updated version
of the database within the same application, you can use this field
to specify which version of the database you are distributing and
let DWebPro automatically start the database server with the correct
database.
Accepted values: integer
Delete Old Databases
DeleteOldDatabases
Delete Old Databases specifies whether
DWebPro has to delete an existing MySQL database before copying a
new one.
Accepted values: 0, 1
Show Copy Progress Window
ShowCopyProgressWindow
Show Copy Progress Window specifies whether
the progress window displays during file copy routines.
Accepted values: 0, 1
Ask user for copy
AskUserForCopy
Ask user for copy specifies whether DWebPro
prompts the user to confirm the copy of the files into the destination
directory.
Accepted values: 0, 1
Default Button
AskUserForCopyDefaultButton
Default Button specifies the default
button on the confirmation form for files copy.
Accepted values: Yes, No
Overwrite
Overwrite
Overwrite specifies whether the
databases copied to the user's hard drive are overwritten.
Accepted values: 0, 1
Ask User for Overwrite
AskUserForOverwrite
Ask User for Overwrite specifies whether DWebPro
prompts the user to confirm the copy of the files if the destination
directory already exists.
Accepted values: 0, 1
Default Button
AskUserForOverwriteDefaultButton
Default Button specifies the default
button on the confirmation form for files copy.
Accepted values: Yes, No
Clear on Shutdown
ClearOnShutdown
Clear on Shutdown specifies whether DWebPro
deletes the files copied to the user's file system prior to closing.
Accepted values: 0, 1
Ask User for Clear on Shutdown
AskUserForClearOnShutDown
Ask User Clear on Shutdown specifies whether DWebPro
prompts the user to confirm the deletions of the files in the destination
directory prior to closing.
Accepted values: 0, 1
Default Button
AskUserForOverwriteDefaultButton
Default Button specifies the default
button on the confirmation form for files deletion.
Accepted values: Yes, No
Interactive Install settings
Use Interactive Install
UseInteractiveInstall
Use Interactive Install specifies whether
DWebPro uses the Interactive Installation procedure. Refer to the Interactive Install Workflow topic for more information.
Accepted values: 0, 1
Space Needed
SpaceNeeded
Space Needed specifies the needed space
for the copy. Use the drop-down box to the right of this field to
specify the units of space desired. This option is relevant only when
using the Use Interactive Install option. Refer
to the Interactive Install Workflow topic for more
information.
Accepted values: integer