Cary,
Your comments caused me to rethink the memory issue. First, I misprinted the max size, which was 51,000 KB (51 MB). then, the realization that my beginning site was over the normal size caused me to rethink why. I flushed the cache and ended up with 2MB, which loaded right up.
I'm still not done with all my problems, but at least I'm making progress. Many thanks.
Steve Hays Ohio University
On Jul 26, 2008, at 12:43 PM, Cary Gordon wrote:
The "PhPMyAdmin upload declares a max size of 51KB" sounds like a big problem. It also sounds like a misconfiguration on the server. Someone should check the phpmyadmin config.inc.php file for a possible misconfiguration. You might also be running up against limits in the /etc/php.ini file, but 51 kb would be a pretty severe upload limit.
Even with normal limits of 2-8 mb you would have to split your script into 2-5 scripts to stay below the limit. Of course, you could try splitting it into 180 pieces for stay under 50Km, but that would be insane.
The best way to do what you need is from the command line.
- In phpmyadmin, drop and create (or empty) the database. Do not add
any tables.
- FTP the file to your home directory
- run "mysql -u user -p dbname < dbname.sql" (you will be prompted for
the password.
- if you do not have privileges to run mysql form the command line,
have your admin do it.
If you are on a cPanel host, use the cPanel MySQL cp to do this.
-- Cary Gordon The Cherry Hill Company http://chillco.com -- [ Drupal support list | http://lists.drupal.org/ ]