PDA

View Full Version : can't restore database



jacopastorius
11-22-2009, 05:33 AM
I backuped my database from a laptop and now i'm trying to restore it in another pc. The backup process ends fine with return code0 but wehn the import finishes it gives me 154 errors or sometimes (i tried few times) error code1. Is my database corrupt?how can i fix it?

netsrak
11-22-2009, 07:23 AM
Are you using the same postgresql version on both computers?

You need to create the new database via pgadmin with the same coding (probably SQL_ASCII) as the old one.

If it doesn't work you should export all hands on the old computer and import them on the new one: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

jacopastorius
11-22-2009, 09:29 AM
Are you using the same postgresql version on both computers?

You need to create the new database via pgadmin with the same coding (probably SQL_ASCII) as the old one.

If it doesn't work you should export all hands on the old computer and import them on the new one: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

yes, they are the same version and i create the database with same code. I have just copied the whole postgre folder from the old to new computer and now it works. Is this a fine solution or should i export all hands?

fozzy71
11-22-2009, 02:20 PM
Did you use the entire \postgres folder? Or just the \data portion? You should only need to use the \data folder and follow these steps - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177

I would suggest you always export your hands in addition to doing a .backup file. The backup/restore method, and the reinstall \data folder method are not fail-proof. If they do fail, you want the original and exported hands to import. If you play a site like stars/ftp you can email their support and ask for all your old hand histories and tourney summaries.

jacopastorius
11-29-2009, 11:27 AM
i copied and overwrited the entire folder of postgre. Thank you for your advice. I'll send an email to stars support for sure to get all my hand histories.