I have uploaded both Drupal folder and database. I'm getting all my theme and .css info, but haven't yet succeeded in connecting to the db.
I think the key is settings.php. Is this how the line should read-- where user and password are those assigned when creating the db on the remote host prior to upload?
$db_url = 'mysql://user:password@dbfilename'
Thanks,
Steve Hays Classics Ohio University
Quoting Steve Hays hays@ohio.edu:
I have uploaded both Drupal folder and database. I'm getting all my theme and .css info, but haven't yet succeeded in connecting to the db.
I think the key is settings.php. Is this how the line should read-- where user and password are those assigned when creating the db on the remote host prior to upload?
$db_url = 'mysql://user:password@dbfilename'
You're missing the host
$db_url = 'mysql://user:password@hostname/dbfilename'
Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
Earnie,
I couldn't get any work done last night, but by using your guidance I established the connection with the database.
When I tried to open my site, I got: Warning: Can't find file: './ ohiohay2_dd08/users.frm' (errno: 13) query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '6b6dc0f4d3915201c36ba8f6f6ce3c7d' in/home/ohiohay2/public_html/ includes/database.mysql.inc on line 128
and a whole page of other errors.
So, I opened the db file I had imported, and it was empty. It shows the requisite number of rows or tables: dbname(89), but when I look into individual rows in PhPMyAdmin on the host site, they lack the content that they have on my Mac.
The host administrator had assured me that he had installed the file, but apparently the installation had failed.
I have since tried to reinstall. I think the problem is the size of the .sql text file (9MB): PhPMyAdmin upload declares a max size of 51KB.
I'm a desktop guy with *very* little experience with hosts, their interfaces, and conventions. Can you give me some guidance?
Steve
On Jul 25, 2008, at 3:54 PM, Earnie Boyd wrote:
Quoting Steve Hays hays@ohio.edu:
I have uploaded both Drupal folder and database. I'm getting all my theme and .css info, but haven't yet succeeded in connecting to the db.
I think the key is settings.php. Is this how the line should read-- where user and password are those assigned when creating the db on the remote host prior to upload?
$db_url = 'mysql://user:password@dbfilename'
You're missing the host
$db_url = 'mysql://user:password@hostname/dbfilename'
Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
-- [ Drupal support list | http://lists.drupal.org/ ]
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,
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/ ]