MySQL Data Wizard is a powerful Windows GUI utility 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 to the MySQL database, export data from MySQL tables and queries to most popular formats, and import data into the tables.
- 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;
- and many more.