MySQL Data Wizard is a powerful tool for managing your MySQL data. It provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. MySQL Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database, including its structure and data, to the MySQL database, export data from MySQL tables and queries to most popular formats, and import data into the tables.

The PHP Generator Wizard allows you to generate PHP scripts for working with MySQL tables and queries, selected from different databases. The full customization of the result HTML appearance with some standard HTML templates provided for your convenience is available as well as full customization of the result script: you can enable/disable record filtering, column ordering, adding/editing/deleting records in the result script. Besides, flexible security settings are provided, allowing you to protect your scripts for unauthorized access.

The Data Pump Wizard allows you to convert any local or remote ADO-compatible database, including its structure and data. The full customization of the target database and objects is available: you can create a new database or convert to the existing one, select objects for conversion and adjust their properties for the target database. You can also adjust data import from the source tables to the target ones, view and edit the SQL script generated for the database conversion, and more.

The Data Export Wizard allows you to export data from MySQL tables and queries, selected from different databases, to any of 14 available formats: MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, SYLK, DIF, LaTeX, SQL. You can select fields to include into the result files, customize the result export files in the following ways: formats, headers/footers, record count, etc. Besides, powerful options for specific customization are available: full Excel formatting, including notes and hyperlinks, RTF formatting, full HTML and PDF appearance adjustment, and more.

The Data Import Wizard allows you to import data into MySQL tables, selected from different databases, from the following available formats: MS Excel, MS Access, XML, DBF, TXT and CSV. You can easily adjust the source file columns and the destination table fields, and customize the import process for each imported file in the following ways: data formats for all or selected fields, commit options, number of rows to skip and records to import, etc. Besides, the wizard provides an ability to define the key columns for the table and select whether to skip, update or delete records, which key value matches the imported one.

Here are some key features of "MySQL Data Wizard":

· MySQL 4.1/5.0 support;
· support of SSH tunnelling;
· multiple database connection support;
· customization of the result HTML appearance in PHP scripts;
· customization of the result PHP script: enabling/disabling record filtering, column ordering, adding/editing/deleting records in the result script, and more;
· optional security settings for PHP scripts;
· convering any local or remote ADO-compatible database;
· data export from a table or a query;
· support of 14 formats for data export: MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, SYLK, DIF, LaTeX, SQL;
· support of 6 formats for data import: MS Excel, MS Access, XML, DBF, TXT and CSV;


What's New in This Release:

· PHP Generator Wizard now has an additional security option, which allows you to generate the script with or without a possibility of session logout;
· the "Include relative path in links" option allows you to specify the way of link generation for target scripts in PHP Generator Wizard;
· several small improvements for better code generation were made in PHP Generator;
· passwords were loaded from wizard templates incorrectly in some cases. Now it is fixed.
· Secure SHell (SSH) tunnelling support


Server environment requirements:

· MySQL server 3.23.x/4.x/5.0