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
