[support] Uploading and getting online

[Steve Hays]

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 at 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/ ]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20080726/22f816e5/attachment.htm