This is how I do it (also for @Voodoo):
-
Make a copy of a synced
/wallet/db/blockchain_wallet_v1_mainnet_1234567890.sqlite
file. As the file is normally in use, I prefer to make an online backup as I described here. Either way, don’t use the original file. -
Use the
sqlite3
command on the copy as follows:.open blockchain_wallet_v1_mainnet_1234567890.sqlite SELECT puzzle_hash FROM coin_record;
Or if you prefer a GUI, open it in DB Browser for SQLite and choose the
coin_record
table to view thepuzzle_hash
field.
- You now have a list of puzzle hashes which you can convert to “receive” addresses at Chiaexplorer.
If this is something you want to do often, you can write a simple script to perform the above steps.
Further reading:
Chia-Keys-Architecture