|
Creating MySql database from csv files:
1.Export MT4 data to csv file. (script Close_toFile2.mq4)
2.Create MySql database:
$ mysqladmin --user='root' --password='botvos' create mt4data1
$ mysql --user='root' --password='botvos' mt4data1 < create1.txt
3.Import csv files in MySql tables:
$ mysqlimport --local --fields-terminated-by=',' --lines-terminated-by='\r\n' --user='root' --password='botvos' --delete --columns='time,open,low,high,close,volume' mt4data1 '/home/barnix/cpp/date2/eurusd/EURUSD240.csv'
Last edited by barnix; 12-14-2008 at 03:34 PM.
|