Rebuilding the PGV Database

  • Peter Cassidy

    Peter Cassidy - 2013-02-26

    I'm moving my PGV site to a new platform. I have all the files from the old platform including a recent backup except the mysql database. I have copied all the files from the old platform to the new one and have PGV running. The installation instructions say "the database can be rebuilt from the files in the backup." How do I do this?

    Peter Cassidy

  • Stephen Arnold

    Stephen Arnold - 2013-02-26


    the database can be rebuilt from the files in the backup

    . If you already imported the GEDCOM within a new installation, (family tree), you have rebuilt the database to the extent available, unless you made a SQL backup, as is suggested. Only the SQL backup will have NEWS, RESEARCH, MESSAGES, USER LIST & INFO and TODO, as well as your PLACE LOCATIONS from Google Map.  These tables are completely separate from any data retained by PGV. For complete restoration, a copy of the database is necessary. Otherwise, you will certainly lose your users and history.

    Also, have you also considered moving to webtrees? That program is under development, unlike PGV which is, politely termed as currently stagnant. It retains ALL the data in the SQL DB and is optimized to do so. Therefore it is a bit faster, especially with larger family trees (those over 15-20,000 INDI's).

  • Peter Cassidy

    Peter Cassidy - 2013-02-26

    Thanks. I wondered about backing up the mysql database. I could have done it easily. At least I have the core data. I will check out webtrees.


Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks