Weka How to Bulk import Arff files into the MySQL database

Here, the Arff file is an example of the Iris.arff file in the Data folder in the Weka installation directory.
1. Convert the Arff file to a CSV file in Weka, and then delete the first line in the CSV file that describes the property name, such as.

2, save, and put in the database data file directory (such as C:\ProgramData\MySQL\MySQL Server 5.5\data\weka);
3, in navicat the corresponding database set up a data table, in this case:

create table iris(sepallength REAL,sepalwidth REAL,petallength REAL,petalwidth REAL,class VARCHAR(20));

and execute the above batch statement at the command line:

load data infile ‘\iris.csv‘   into table iris   fields terminated by ‘,‘  optionally enclosed by ‘"‘ escaped by ‘"‘   lines terminated by ‘\r\n‘;

At this point, the Arff file is successfully imported into the database.

Weka How to Bulk import Arff files into the MySQL database