View Single Post
  #506 (permalink)  
Old 12-15-2008, 08:42 AM
barnix barnix is online now
Senior Member
 
Join Date: Mar 2006
Posts: 1,069
barnix is on a distinguished road
3.Import csv file to Mysql
a.)
Create tables Symbols_Normal and Symbols_Mini
mysql --user='root' --password='botvos' mt4data1 < create2.txt
b.)Import csv data
mysqlimport --local --verbose --fields-terminated-by=',' --lines-terminated-by='\r\n' --user='root' --password='botvos' --delete --columns='symbol, point, digits, spread, stoplevel, lotsize, tickvalue, ticksize, swaplong, swapshort, start, expiration, tradeallowed, minlot, lotstep, maxlot, margininit, marginmaintenance, marginrequired' mt4data1 '/home/barnix/cpp/date2/Symbols_Mini.csv'

Download MYSql database from:
http://code.google.com/p/betterea/downloads/list
Attached Files
File Type: txt cre2.txt (126 Bytes, 13 views)
File Type: txt imp2.txt (745 Bytes, 12 views)

Last edited by barnix; 12-15-2008 at 10:14 AM.
Reply With Quote