<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Earnie,<div><br></div><div>I couldn't get any work done last night, but by using your guidance I established the connection with the database.</div><div><br></div><div>When I tried to open my site, I got: <span class="Apple-style-span" style="font-family: Times; "><b>Warning</b>: 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<b>/home/ohiohay2/public_html/includes/database.mysql.inc</b> on line <b>128</b></span></div><div><font class="Apple-style-span" face="Times"><b><br></b></font></div><div><font class="Apple-style-span" face="Times"><b><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-weight: normal;">and a whole page of other errors.</span></font></b></font></div><div><br></div><div><font class="Apple-style-span" face="Times"><b><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-weight: normal;">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.</span></font></b></font></div><div><br></div><div>The host administrator had assured me that he had installed the file, but apparently the installation had failed. </div><div><br></div><div>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.</div><div><br></div><div>I'm a desktop guy with *very* little experience with hosts, their interfaces, and conventions. Can you give me some guidance?</div><div><br></div><div>Steve</div><div><br></div><div><br></div><div><font class="Apple-style-span" face="Times"><b><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-weight: normal;"><br></span></font></b></font><div><div>On Jul 25, 2008, at 3:54 PM, Earnie Boyd wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Quoting Steve Hays <<a href="mailto:hays@ohio.edu">hays@ohio.edu</a>>:<br><br><blockquote type="cite">I have uploaded both Drupal folder and database. I'm getting all my<br></blockquote><blockquote type="cite">theme and .css info, but haven't yet succeeded in connecting to the db.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I think the key is settings.php. Is this how the line should read--<br></blockquote><blockquote type="cite">where user and password are those assigned when creating the db on the<br></blockquote><blockquote type="cite">remote host prior to upload?<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> $db_url = 'mysql://user:password@dbfilename'<br></blockquote><blockquote type="cite"><br></blockquote><br>You're missing the host<br><br>$db_url = 'mysql://user:password@hostname/dbfilename'<br><br><br>Earnie -- <a href="http://for-my-kids.com/">http://for-my-kids.com/</a><br>-- <a href="http://give-me-an-offer.com/">http://give-me-an-offer.com/</a><br><br>-- <br>[ Drupal support list | <a href="http://lists.drupal.org/">http://lists.drupal.org/</a> ]<br></div></blockquote></div><br></div></body></html>