+- Gekko Forum (https://forum.gekko.wizb.it)
+-- Forum: Gekko (https://forum.gekko.wizb.it/forum-13.html)
+--- Forum: Guides (https://forum.gekko.wizb.it/forum-22.html)
+--- Thread: [TUT] MERGE SQLite DATABASE FILES (/thread-1494.html)
[TUT] MERGE SQLite DATABASE FILES - susitronix - 02-15-2018
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_4-10045185.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
RE: How to MERGE SQLite DATABASE FILES - tommiehansen - 02-15-2018
Great! +1
RE: How to MERGE SQLite DATABASE FILES - Kromdore - 02-15-2018
Thank you so much! This is exactly what I was about to start working on before I decided to check the forums.
tommiehansen you are also super helpful to the community. I wish both of you luck and hope I can contribute in some way soon
RE: How to MERGE SQLite DATABASE FILES - ankasem - 02-15-2018
Great! +2
RE: How to MERGE SQLite DATABASE FILES - susitronix - 02-15-2018
Thanks. Hope its Bullet proof... hehe lol