Want to bulk import SQL files into MariaDB tables at one time?
Try Withdata software FileToDB, a SQL to MariaDB converter for MariaDB for Windows, MacOS, and Linux, Easy and Fast, Even other type database SQL.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
- Convert locally, Avoid uploading LARGE SQL file(s) to online services.
- Support standard SQL files, and SQL files of database types: Access, DB2, DBF, MySQL, Oracle, PostgreSQL, SQLite, SQL Server, etc.
Bulk import SQL files into MariaDB tables
Login to MariaDB -> Choose SQL files -> Set MariaDB tables -> Import SQL files to MariaDB tables
Choose MariaDB and logon.
Click “Wizard – N Files To N Tables” at task dialog.
Select the “SQL” file type.
then show the wizard.
1. Select a folder that constains SQL files.
2. Config first SQL file importing options.
3. Set “Import Type”.
4. Map MariaDB tables to SQL files.
5. Summary. Set “Convert Rows” and “Skip Rows” if need.
6. Import SQL files to MariaDB tables, 1 file to 1 table, one by one.
View imported data in MariaDB table
Bulk import SQL files into MariaDB tables in command line
Save “bulk SQL files to MariaDB tables” session, then you can:
- Bulk import SQL files into MariaDB tables in Windows command line.
- Bulk import SQL files into MariaDB tables in Linux command line.
- Bulk import SQL files into MariaDB tables in macOS command line.
Set scheduled tasks for bulk importing SQL files into MariaDB tables
You can schedule and automate this converting task by:
- Save session and create .bat (Windows) or .sh (Linux/macOS) file for “SQL to MariaDB” conversion.
- Set scheduled task for “SQL to MariaDB” conversion.
More about Withdata FileToDB – SQL to MariaDB converter
See also: