[TUT] MERGE SQLite DATABASE FILES
#1
Gekko will create one db (database) file for every exchange. 

I had two Binance files from different computers.

The simplest way (thanks to TommieHansen) to MERGE these files is by using a tool:
SQliteStudio or phpLiteAdmin
(This tutorial is ONLY for SQliteStudio)

Download here:
https://sqlitestudio.pl/index.rvt
(click download on top of page, feel free to donate)

Only unpack the zip file and move to C/programs/ or User/Desktop. No Installation necessary
(Use Freeware 7zip)
http://download.cnet.com/7-Zip/3000-2250...45185.html

Double click >>> SQliteStudio.exe

Add the first database:
Menu >>> Database >>> [add Database]
In the popup window >>> click the small folder Icon
Choose /.../.../Gekko_Stable/History/YOUR FIRST .db FILE  // (example: binance_01.db)

Add the second database:
Menu >>> Database >>> [add Database]
In the popup window >>> click the small folder Icon
Choose  /YOUR SECOND .db FILE

On the left, double click your two .db files
Now you see your PAIRS:
candles_BTC/ETH

You can drag and drop [candles_BTC/ETH] like so:
>>> RightClickHold source file and move to the other Database >>>drop.
>>> choose COPY or MOVE
>>> repeat until your finished

Save the file, is not necessary since SQliteStudio establish a direct connection to the Database.
This allows us to edit/modify our .db WHILE it is in use by Gekko or other Clients.
>>> click/select on the .db file (binance_01)

>>>Menu >>> Database >>> [Disconnect from the Database]. (or click Icon)
Now your new .db is saved.
>>> No need to restart Gekko. ONLY click [Scan available data]


thanks to TommieHansen

I try askMikes Hint for Tip:
BTC 392hHafnMmHS8JWT6yDjdsX6mtEhQvTAq8
ETH 0x01d1897cE56347D936B9d8aceb422D8D2C958401
  Reply


Messages In This Thread
[TUT] MERGE SQLite DATABASE FILES - by susitronix - 02-15-2018, 12:07 AM

Forum Jump:


Users browsing this thread: