How to shrink wallet.dat? It's over 200MB

[miningpoolhub]

Hi I'm running a pool.

Is there any method to shrink wallet.dat? There's so many not using keys in wallet.dat.
It's growing and growing, over 200MB.

Well, it's not about bitcoin, actually it's altcoin. But this problem lies same in bitcoin too.
What is the right method, easily clean not using keys.

"change=" option may work, but not all altcoin's have this option. Also it must be ran before wallet.dat gets bigger.

Any dirty method is appreciated too. I want to reduce the wallet.dat safely.

[Diapolo]

Isn't there an issue tracker for your altcoin :-P?

[leofidus]

If you don't receive any transactions with the wallet, you could just send the entire balance to a new wallet and use that new wallet file from now on. That's not really ideal from a privacy standpoint, but it's a solution. Alternatively export all relevant private keys and import them into a new wallet, leaving those you don't need behind.

[laanwj]

You could try -zapwallettx. It will remove all transactions from the wallet and rescan them from the block chain. This may make the wallet smaller. After that you could compact the bdb file like this to get rid of empty space:

cp wallet.dat wallet.dat.backup
db4.8_dump wallet.dat | db4.8_load wallet.dat.new
mv wallet.dat.new wallet.dat