ok, i was doing unlock, dumprivkey and import that into a new wallet. The amount it shows now is a slightly different than what the old wallet was showing (less than 1 coin difference) but my missing coins are still not there. Explorer shows them though. Are those coins lost? How did that happen? Is there something else i could try?
yes, i was rescanning it after importing privkey - still nothing. Where did the coins go and why do they not show when they show in the explorer? I don't get it.
Did you import the change addresses? These would have been created if you spent the partial amount of one input in a address in the past. If you open the old wallet.dat and use the coincontrol window you will see these addresses marked as (change) beside the address under the initial deposit they came from. they can only be seen there using the gui. Its how bitcoin works when spending part of an amount, it makes two outputs, one to the address with the amount you are spending, and the balance is sent to a "change" address which is hidden from view. You can check for the change address/es on the explorer viewing any sends you made from the address/es, if it was a partial spend of input, there will be another address that is yours but not seen in the main wallet view but can still be imported into a new wallet.dat as you will have the privatekey for it.