DBForms for MS Access to PHP + MySQL Choose Destination
Choose Destination

Select a destination database type to be converted (MySQL Database ,MySQL Dump or PHP Script).

  • If you select MySQL Database as a destination, specify Hostname, Port, Username and Password if needed.


    DBForms for MS Access to PHP + MySQL supports Unicode. To make language special symbols displayed correctly select utf8 in the list box "Connection character set". You can also choose any other character set from the list box. After defining necessary information, click "Test connection" button. This will check if it's possible to connect to your MySQL server with the parameters you specified before.

    In case the connection is set successfully the following message appears and you can continue configuring necessary data:


    By pressing "Refresh" button you can view all existing databases available on this server for this user and list them in "Database" combo-box.
    Choose a MySQL database where data for your forms will be saved. You can also type the name of the database in this combo it will allow you to save time needed for refreshing information about the bases available.

  • If you select MySQL Dump as a destination database, you need to do the following:


    In "Output file" field enter a name for MySQL Dump (.sql file) to be created. You can also browse it by clicking the button nearby.

    In "Database" field enter a name for a database that will be created by the .sql file you specified above. This .sql file will insert data from the Source database to the database with the name you define in "Database" field.

    At this step you can set a way the resulting dump file should be formed in. The following settings are available:

      MySQL server version - this parameter determines the syntax of MySQL statements being used in output dump file. 'Old' versions of MySQL (before 3.23.6) put more restrictions on database objects names. Note that 'new' syntax is not accepted by 'old' versions of MySQL. Use 'old' syntax whenever you are not sure about your MySQL server version.

      Line breaks - this parameter specifies how to separate text lines in the dump file. If your target MySQL server is running on MS Windows platform, you should select 'MS Windows style' option. Otherwise select 'Unix style'.

      Insert comments - select this option to add brief comments. It makes the resulting dump file more understandable.

  • If you select PHP Script as a destination database, specify a destination Hostname, Port, Userame and Password if needed.


    In "Output file" field enter a name for PHP Script to be created. You can also browse it by clicking the button nearby.

    In "Database" field enter a name for a database that will be created by the PHP Script you specified above. This script will add data from the Source database to the database with the name you define in "Database" field.

    At this step you can set a way the resulting dump file should be formed in. The following settings are available:

      MySQL server version - this parameter determines the syntax of MySQL statements being used in output Php file. 'Old' versions of MySQL (before 3.23.6) put more restrictions on database objects names. Note that 'new' syntax is not accepted by 'old' versions of MySQL. Use 'old' syntax whenever you are not sure about the version of your MySQL server.

      Line breaks - this parameter specifies how to separate text lines in the dump file. If your target MySQL server is running on MS Windows platform, you should select 'MS Windows style' option. Otherwise select 'Unix style'.

         Click "Next >" to continue.

  • © Copyright by DMSoft Technologies, 2001-2007.