Importing Data to MySQL Databases
How often do you have to import information from data files to the MySQL database? For example, import information from Excel worksheet to the table with a numerous number of columns having different data types? There is a number of solutions to solve this task in one way or another. Some solutions require conversion of MySQL data in several stages, which could entail the loss or distortion of data. Others are based on the use of ODBC technology, which noticeably depends on the applicable set of ODBC libraries, drivers and their capabilities. Using such methods causes problems with import of multilingual data to MySQL or data from XML files and can lead to errors in type conversion, Unicode handling and may require manual editing of data or constructing complex SQL queries to MySQL server to complete the import process.
Thus, an ordinary user of MySQL server, as well as database administrator needs a reliable solution to import information from the data file to MySQL database most effectively and flexibly without data loss and time wasting.
This MySQL import tool allows you to efficiently import data from most popular file formats into MySQL database tables. EMS Data Import for MySQL uses the native access to MySQL server, which ensures the maximum productivity during the import process and reduces the time required for importing a large amount of information.EMS Data Import for MySQL can import information to MySQL database from most popular file formats: MS Excel 97-2007, MS Access, XML, DBF, TXT, CSV, MS Word 2007, OpenDocument and HTML. Documents, text files, spreadsheets, local databases, information from web pages - all these can be easily imported into MySQL database tables without preliminary data conversion.
The program provides adjustable import parameters, which allows you to control source and target data formats, field data and type mappings, define values to be interpreted as NULLs, MySQL commit options, number of records to skip, as well as define SQL scripts to be executed before and after the import process for each database and more. The utility has the ability to automatically set correspondence between columns of the source file and fields of the target MySQL table according to the source data format. To specify the method of database data replacement for information already existing in the MySQL database, you can use a number of the record processing modes based on primary key values. Moreover, special data import modes like Batch Insert & CSV Insert can considerably accelerate the record insert speed during MySQL import.
EMS Data Import for MySQL supports Unicode, which allows you to import data stored in different languages without any risks of damaging the information. SSH and HTTP tunneling is available to access the host that is located behind a firewall and blocks direct connections on MySQL server port or to provide confidentiality and integrity during data transfer.
Data Import for MySQL includes a wizard, which allows you to set all import options for different files visually and import data to one or several tables or views from different data files simultaneously. The import into one or several tables, located in one or different databases is also possible. You can save all MySQL import parameters set on the current wizard session and use a special command-line utility to automate typical MySQL import tasks by performing the import on the schedule according to predefined settings saved before.
The utility has a customizable user interface with multilingual support and variable visual schemes.
Conclusions on MySQL Import Tools
EMS Data Import for MySQL can be used as a single tool or in a group of useful database utilities for MySQL server - EMS SQL Management Studio for MySQL - solution that simplifies management process and increases database administrator productivity. EMS SQL Management Studio for MySQL provides you with must-have tools for administering MySQL databases, managing database schema and objects as well as for MySQL database design, migration, extraction, MySQL query building, data import, export and database comparison.