Batch import TXT files into MySQL TEXT (CLOB) without programming

by

Posted on by

Want to batch import TXT (Text) documents into MySQL TEXT (CLOB) or BLOB column?

Using DBBlobEditor, you can import bulk txt files into MySQL TEXT (CLOB) or BLOB easily and fast, just a few mouse clicks.

Support connect to MySQL through SSH tunnel.

Here you can download and install DBBlobEditor.

Batch import TXT documents to MySQL TEXT (CLOB) column

Click “Start New Task – Import LOB From Files” at task dialog.

Batch import txt files into MySQL TEXT (CLOB) - Task Window

then show the wizard.

1. Config.

Batch insert txt files into MySQL TEXT (CLOB) - config

2. Import.

Batch save txt files into MySQL TEXT (CLOB) - import

then you can see importing results

Batch import txt files into MySQL TEXT (CLOB) - view

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

More about DBBlobEditor – the tool to batch import TXT documents to MySQL TEXT (CLOB) column

30-day free trial Download DBBlobEditor