I'm trying to import a 35-meg (yes, that's right :) GEDCOM file into phpGedView. Not surprisingly, I run out of memory during the process on my webhost's server. I *did* manage the import on my home computer. Can I export the contents of the mySQL database from my home machine to a file and import it to my webhost database? Forgive me if this is a really basic question, but I am a newcomer both to php and mySQL.
I'd *really* like to be able to use phpGedView -- it's far and away the best program of its kind that I've been able to find.
Thanks in advance!
Lydia
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The ability to do this will depend on the options your host server gives you. You *CAN* export your local MySQL database to a file. Upload the file and then import it into your host database, if you can run MySQL on the command line.
You could also try to use PhpMyAdmin to do this. Install PhpMyAdmin on your home computer, export the contents of the database in SQL commands to a file. Then break this very large file into several smaller files. Then using PhpMyAdmin on the server you could import these smaller files.
You could also upload the single large file and on the MySQL command line, import the file without breaking it up. I don't remember the MySQL commands to do this off the top of my head. But you can look them up in the documentation at http://www.mysql.com
Once you have the database copied, all you have to do is copy the PhpGedView folder from your home computer to your website and reconfigure the database connection parameters and everything should work great.
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm trying to import a 35-meg (yes, that's right :) GEDCOM file into phpGedView. Not surprisingly, I run out of memory during the process on my webhost's server. I *did* manage the import on my home computer. Can I export the contents of the mySQL database from my home machine to a file and import it to my webhost database? Forgive me if this is a really basic question, but I am a newcomer both to php and mySQL.
I'd *really* like to be able to use phpGedView -- it's far and away the best program of its kind that I've been able to find.
Thanks in advance!
Lydia
WOW 35MB!!!
The ability to do this will depend on the options your host server gives you. You *CAN* export your local MySQL database to a file. Upload the file and then import it into your host database, if you can run MySQL on the command line.
You could also try to use PhpMyAdmin to do this. Install PhpMyAdmin on your home computer, export the contents of the database in SQL commands to a file. Then break this very large file into several smaller files. Then using PhpMyAdmin on the server you could import these smaller files.
You could also upload the single large file and on the MySQL command line, import the file without breaking it up. I don't remember the MySQL commands to do this off the top of my head. But you can look them up in the documentation at http://www.mysql.com
Once you have the database copied, all you have to do is copy the PhpGedView folder from your home computer to your website and reconfigure the database connection parameters and everything should work great.
--John