Menu

restore Database from SQL Backup

Help
Hans Gisch
2025-02-24
2025-02-24
  • Hans Gisch

    Hans Gisch - 2025-02-24

    Hi,
    had to start from scratch. Installed PHPGedview 4.3.0 and want to restore the old database from a previous SQL backup. SQL dump was taken from 4.2.3 version.
    Import works ok but I can't get excess to the data restored in the database.
    Is there any way to get that to work?

    Thanks for your help in advance,

    Hans

     
  • Gerry Kroll

    Gerry Kroll - 2025-02-24

    You need to upgrade your PhpGedView installation to the latest-and-greatest 4.3.1 . This version works with all versions of the PHP package, from 5.3 through 8.2. It should work OK with 8.4, but I haven't tested that and I haven't heard otherwise.

    You download this version from the SVN repository
    https://sourceforge.net/p/phpgedview/svn/HEAD/tarball?path=/trunk/phpGedView

    After having downloaded this ZIP file, expand it on your local computer and in the modules directory, delete all sub-directories that correspond to modules you don't want to keep.

    On my site, I only use these modules:
    GEDFact_assistant , JWplayer , lightbox , slideshow

    Before copying this stuff to your server's directory where PhpGedView lives, delelete directories /media and /index so that they don't accidentally over-write what's already on the server. PhpGedView that you downloaded does not contain a /config.php file.

    You need to preserve the existing /config.php file and the existing /index and /media directories.

    After having upgraded your PhpGedView installation, launch PhpGedView in the usual manner and immediately access the Admin page and click on "Manage GEDCOMs and edit Privacy".

    On the line where your GEDCOM file is mentioned, click "Export" and then immediately click "Import". Let the Import delete existing database records.

    The "Export" function looks at the database and exports the embedded GEDCOM records to a GEDCOM file in your /index directory. It does NOT look at any of the database fields, other than the embedded GEDCOM records. The "Import" function reads that just-exported GEDCOM file and populates your database with the appropriate information. It also re-builds the indexes. There's no need to download the exported GEDCOM file, unless you wish to do so.

     

Log in to post a comment.