Equivalent of SQL loader in MySQL

Question

I have found SQL loader in Oracle is very helpful, fast and efficient. What is the MySQL equivalent of SQL loader?

score 5 · Accepted Answer · answered Sep 26 '11 at 12:09

5

There is MySQL Front 3.2

and

LOAD DATA INFILE

(see docs)

answered Sep 26 '11 at 12:09

Louis

Louis: it seems just like external table, Yeah I have tried but any suggestion please for sqlloader ? – Suleman Ahmad Sep 27 '11 at 05:30
1

@Suleman : Also called heidiSQL : http://www.roseindia.net/mysql/mysql-front.shtml It is a solid tool to interact with the db. Also does import/export of text files, CSV files, .... – Louis Sep 27 '11 at 06:18

score 2 · Answer 2 · answered Sep 26 '11 at 12:12

2

Provides much of the same functionality as you would implement in your control file except for byte ranges and 'WHERE' filters.

answered Sep 26 '11 at 12:12

symcbean

2 Answers2