I no longer have my original GED file. I do have all healthy MySql tables. How do I re-install and connect the new install to my data tables? I did a fresh Install and it wants me to import a Gedcom-I dont need to-I have all of the tables full of good data!! HELP
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2009-09-12
Ouch, thats not good. But before you panic, is this your own or a hosted web server? Most web hosts operate a very rigid backup routine, so they should have a copy of your GEDCOM file form the day before. Have you asked?
Presumably you don't have your own backups :-((
Second, if thats not possible, is it just the GEDCOM file, or everything that was in the phpgedview/index folder? If not everything, what is left there?
Lets clear these questions first, then if we need to step through a process of recovering your data from the database, which can certainly be done. If you'd prefer, you can contact me direct and work through this off-line. Email me on my profile here, giving your email address.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
<<I do have all healthy MySql tables>>
You don't say what version of PGV, nor whether the new installation is the same version of PGV,
Yes, you can get your data back, but as kiwi_pgv says, if you give us incomplete info, we can give you general advice, but if we know the full picture, we can give you accurate instructions.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ok thanks so much for the replies-here is more information. I have my own server that PGV runs on. Ubuntu 8.04. I lost my hard drive. So I setup a new server and copied the backed up phpgedview php files to /var/www. I then copied the backed up phpgedview SQL tables to /var/lib/mysql.
I have done this in the past with no problems. This time I get a cryptic error: See at the bottom…
So what I wanted to do is just install a new PGV and "connect" it to my MySql tables. For example, if I do the following sql statement I see all of my people > select * from pgv_individuals
(how can I tell what version of PGV I have?)
Thanks so much!
ERROR 2: DB::include_once(DB/mysql.php) : failed to open stream: No such file or directory
0 Error occurred on line 532 of file DB.php in function connect
1 called from line 532 of file DB.php in function connect
2 called from line 100 of file functions.php in function check_db
3 called from line 353 of file session.php in function require_once
4 called from line 80 of file config.php in function require
5 called from line 28 of file index.php
Warning: DB::include_once(DB/mysql.php) : failed to open stream: No such file or directory in /var/www/PhpGedView/DB.php on line 532
ERROR 2: DB::include_once() : Failed opening 'DB/mysql.php' for inclusion (include_path='.:/var/www/PhpGedView/includes:/var/www/PhpGedView:.:/usr/share/php:/usr/share/pear')
0 Error occurred on line 532 of file DB.php in function connect
1 called from line 532 of file DB.php in function connect
2 called from line 100 of file functions.php in function check_db
3 called from line 353 of file session.php in function require_once
4 called from line 80 of file config.php in function require
5 called from line 28 of file index.php
Warning: DB::include_once() : Failed opening 'DB/mysql.php' for inclusion (include_path='.:/var/www/PhpGedView/includes:/var/www/PhpGedView:.:/usr/share/php:/usr/share/pear') in /var/www/PhpGedView/DB.php on line 532
ERROR 2: Cannot modify header information - headers already sent by (output started at /var/www/PhpGedView/includes/functions/functions.php:728)
Warning: Cannot modify header information - headers already sent by (output started at /var/www/PhpGedView/includes/functions/functions.php:728) in /var/www/PhpGedView/includes/session.php on line 576
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
<<how can I tell what version of PGV I have>>
Assuming your system is less than a few years old, it will be defined in include/session.php.
<<ERROR 2: DB::includeonce(DB/mysql.php) : failed to open stream: No such file or directory>>
From this error message, I can see that you are not using the latest version of PGV. This doesn't really matter. What I wanted to know was whether you were trying to combine an upgrade with a recovery.
The error message suggests that you haven't copied all your files from your old installation to your new one. In particular, you are missing /var/www/PhpGedView/DB/mysql.php.
Now, this DB directory isn't strictly necessary. Many PHP installations include these files in a library/include path, so many people deleted it to save space. Perhaps you were one of them, and your new server doesn't have this library?
This is a third-party library, and you can get a fresh copy by downloading PGV version 4.2.1, and copying *JUST THE DB DIRECTORY* from this, to your installation.
BTW - do you have the PhpGedView/index directory? When you lost the gedcom file, you didn't say whether or not you lost the associated ???_conf.php and ???_priv.php files as well.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
fisharevest-thanks so much for the pointing me in the right direction. For some reason my DB directory was db. I changed the name to DB and everything came up! It even created a new GED file for me.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I no longer have my original GED file. I do have all healthy MySql tables. How do I re-install and connect the new install to my data tables? I did a fresh Install and it wants me to import a Gedcom-I dont need to-I have all of the tables full of good data!! HELP
Ouch, thats not good. But before you panic, is this your own or a hosted web server? Most web hosts operate a very rigid backup routine, so they should have a copy of your GEDCOM file form the day before. Have you asked?
Presumably you don't have your own backups :-((
Second, if thats not possible, is it just the GEDCOM file, or everything that was in the phpgedview/index folder? If not everything, what is left there?
Lets clear these questions first, then if we need to step through a process of recovering your data from the database, which can certainly be done. If you'd prefer, you can contact me direct and work through this off-line. Email me on my profile here, giving your email address.
<<I do have all healthy MySql tables>>
You don't say what version of PGV, nor whether the new installation is the same version of PGV,
Yes, you can get your data back, but as kiwi_pgv says, if you give us incomplete info, we can give you general advice, but if we know the full picture, we can give you accurate instructions.
Ok thanks so much for the replies-here is more information. I have my own server that PGV runs on. Ubuntu 8.04. I lost my hard drive. So I setup a new server and copied the backed up phpgedview php files to /var/www. I then copied the backed up phpgedview SQL tables to /var/lib/mysql.
I have done this in the past with no problems. This time I get a cryptic error: See at the bottom…
So what I wanted to do is just install a new PGV and "connect" it to my MySql tables. For example, if I do the following sql statement I see all of my people > select * from pgv_individuals
(how can I tell what version of PGV I have?)
Thanks so much!
ERROR 2: DB::include_once(DB/mysql.php) : failed to open stream: No such file or directory
0 Error occurred on line 532 of file DB.php in function connect
1 called from line 532 of file DB.php in function connect
2 called from line 100 of file functions.php in function check_db
3 called from line 353 of file session.php in function require_once
4 called from line 80 of file config.php in function require
5 called from line 28 of file index.php
Warning: DB::include_once(DB/mysql.php) : failed to open stream: No such file or directory in /var/www/PhpGedView/DB.php on line 532
ERROR 2: DB::include_once() : Failed opening 'DB/mysql.php' for inclusion (include_path='.:/var/www/PhpGedView/includes:/var/www/PhpGedView:.:/usr/share/php:/usr/share/pear')
0 Error occurred on line 532 of file DB.php in function connect
1 called from line 532 of file DB.php in function connect
2 called from line 100 of file functions.php in function check_db
3 called from line 353 of file session.php in function require_once
4 called from line 80 of file config.php in function require
5 called from line 28 of file index.php
Warning: DB::include_once() : Failed opening 'DB/mysql.php' for inclusion (include_path='.:/var/www/PhpGedView/includes:/var/www/PhpGedView:.:/usr/share/php:/usr/share/pear') in /var/www/PhpGedView/DB.php on line 532
ERROR 2: Cannot modify header information - headers already sent by (output started at /var/www/PhpGedView/includes/functions/functions.php:728)
Warning: Cannot modify header information - headers already sent by (output started at /var/www/PhpGedView/includes/functions/functions.php:728) in /var/www/PhpGedView/includes/session.php on line 576
<<how can I tell what version of PGV I have>>
Assuming your system is less than a few years old, it will be defined in include/session.php.
<<ERROR 2: DB::includeonce(DB/mysql.php) : failed to open stream: No such file or directory>>
From this error message, I can see that you are not using the latest version of PGV. This doesn't really matter. What I wanted to know was whether you were trying to combine an upgrade with a recovery.
The error message suggests that you haven't copied all your files from your old installation to your new one. In particular, you are missing /var/www/PhpGedView/DB/mysql.php.
Now, this DB directory isn't strictly necessary. Many PHP installations include these files in a library/include path, so many people deleted it to save space. Perhaps you were one of them, and your new server doesn't have this library?
This is a third-party library, and you can get a fresh copy by downloading PGV version 4.2.1, and copying *JUST THE DB DIRECTORY* from this, to your installation.
BTW - do you have the PhpGedView/index directory? When you lost the gedcom file, you didn't say whether or not you lost the associated ???_conf.php and ???_priv.php files as well.
fisharevest-thanks so much for the pointing me in the right direction. For some reason my DB directory was db. I changed the name to DB and everything came up! It even created a new GED file for me.