View Single Post
  #504 (permalink)  
Old 12-14-2008, 02:46 PM
barnix barnix is offline
Senior Member
 
Join Date: Mar 2006
Posts: 1,069
barnix is on a distinguished road
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'
Attached Files
File Type: txt cre1.txt (125 Bytes, 11 views)
File Type: txt create1.txt (12.6 KB, 11 views)
File Type: txt imp1.txt (4.2 KB, 10 views)

Last edited by barnix; 12-14-2008 at 03:34 PM.
Reply With Quote