Backup issue

[kobraprophet]

I just purchased a new computer, and am trying to transfer my database over to the new machine and my new pokertracker.
When trying to perform a backup I get this error message;

PokerTracker 3 Database...file size: 1008.83MBpg_dump: SQL command failed
pg_dump: Error message from server: ERROR: could not read block 7553 of relation 1663/16403/192246: Invalid argument
pg_dump: The command was: COPY public.tourney_holdem_hand_histories (id_hand, history) TO stdout;

I get a similar message when I try to perform housekeeping, which I thought might solve this,
hope there's an easy way to fix this!

Thanks in advance

[kraada]

Please check your anti-virus to make sure no files in the PostgreSQL directory are in quarantine. That error likely indicates that there is a file missing in the PostgreSQL directory - without it, the database cannot be backed up as there is unknown and missing information.

[kobraprophet]

I'm not sure that's the issue, as I think a portion of the database became corrupted along with a few other files (some of the reason I bought a new computer), is there anyway to back it up without those bits, or any other way to get my results and hud info across?

[WhiteRider]

If there are file errors then you may not be able to transfer the complete database.
In that case the best option will probably be to re-import your hand histories. If you play cash games and have have your original hand history files (in the PokerTracker 3\Processed folder) then you can re-import from them. If you don't have them, or if you play tournaments and have entered manual results then you will probably be able to export from your existing database and import those files to your new computer.

[kobraprophet]

Thank you for your help so far, I've exported all the tournaments I wish to transfer and got them on to the new machine, where do I put them for Pokertracker to recognise them all?

[kraada]

Any folder will do - then in PT3 go to the Import -> Manual Import tab and click Import From Directory - pick the directory that you saved them to and everything will start importing.