See Also
Bitcoin Blockchain to MySQL ETL Tool
Crypto.BI Toolbox comes with an ETL tool that allows you to extract data from the block DAT files and import the blockchain into MySQL. If you got the blocks directory configuration set up correctly, then you can run the ETL tool. Go to the Crypto.BI Toolbox installation directory and run: $ ./toolbox/db/blocks_to_sql > <output_file.sql> This […]
Bitcoin Toolbox Home
Crypto.BI Toolbox is a set of tools for local blockchain exploration. It uses data from the raw Bitcoin block data files and does not require a network connection, API’s and other 3rd party data sources. It’s built of a combination of C++ libraries, Python integration and many other planned components that aim to make blockchain […]
Bitcoin Blockchain to MySQL Insertion Tool
Crypto.BI Toolbox comes with a raw .dat block file to MySQL insertion tool called blocks_inserter. To use it, first you’ll need to generate the MySQL schema on your local server by importing scripts/sql/mysql/cryptobitoolbox_bitcoin.sql into your MySQL server. Then you will need to configure Toolbox with the appropriate username, password, host and database so that Toolbox […]
Bitcoin Blockchain MySQL Database Inserter Configuration
Toolbox tries to read configuration from $HOME/.cyptobi/cryptobi.conf If a config file is unavailable, then defaults will be applied. The order of precendence from highest to lowest is: Command line options override all others. Config file options override defaults. Program defaults. Environment Set CRYPTOBI_HOME environment variable to the directory where you cloned the Crypto.BI Toolbox from […]