Bulk import data from SQL files to MySQL tables at one time

by

Want to bulk import SQL files into MySQL tables at one time?

Try Withdata software FileToDB, a SQL to MySQL converter for MySQL for Windows, MacOS, and Linux, Easy and Fast, Even other type database SQL.

Download Withdata FileToDB Download FileToDB

Bulk import SQL files into MySQL tables

Login to MySQL -> Choose SQL files -> Set MySQL tables -> Import SQL files to MySQL tables

Choose MySQL and logon.

bulk import SQL files into MySQL tables - Choose MySQL and logon

Click “Wizard – N Files To N Tables” at task dialog.

bulk import SQL files into MySQL tables - task window

Select the “SQL” file type.

bulk load SQL files into MySQL tables - select file type

then show the wizard.

1. Select a folder that constains SQL files.

bulk import SQL files into MySQL tables - select a folder

2. Config first SQL file importing options.

bulk import SQL files into MySQL tables - config first file

3. Set “Import Type”.

bulk import SQL files into MySQL tables - set tables

4. Map MySQL tables to SQL files.

bulk import SQL files into MySQL tables - map

5. Summary. Set “Convert Rows” and “Skip Rows” if need.

bulk import SQL files into MySQL tables - preview

6. Import SQL files to MySQL tables, 1 file to 1 table, one by one.

bulk import SQL files into MySQL tables - import data

View imported data in MySQL table

bulk import SQL files into MySQL tables - view data


More about SQL file to MySQL converter

See also: