<div dir="ltr">Later on, check out this video on the Lullabot site, it might prove to be of some assistance to you:<br><br><a href="http://www.lullabot.com/videocast/install_local_web_server_mac_osx">http://www.lullabot.com/videocast/install_local_web_server_mac_osx</a><br>
<br><div class="gmail_quote">On Wed, Jul 23, 2008 at 6:54 PM, Steve Hays <<a href="mailto:hays@ohio.edu">hays@ohio.edu</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="">Steve,<div><br></div><div>Thanks. The interface looks a little scary. I guess I'll just use the defaults and hope for the best. I can't do it right now. Time to give up web site development for teaching a 2-hour class.</div>
<div><br></div><div>Peace, and many thanks.</div><div><br></div><font color="#888888"><div>Steve Hays</div></font><div><div></div><div class="Wj3C7c"><div><br><div><div>On Jul 23, 2008, at 5:44 PM, Steve Edwards wrote:</div>
<br><blockquote type="cite"> <div bgcolor="#ffffff" text="#000000"> <font size="-1"><font face="Arial">phpMyAdmin allows you to export the entire database as a .sql file. Export it from your local db, and then import it on your server. It's easiest to have your db already created on your server, and then just import the .sql file.<br>
<br> Steve<br> </font></font><br> Steve Hays wrote: <blockquote type="cite">Steve, <div><br> </div> <div>Yes. dd08 does contain that information. I can view it from within PhP My Admin.</div> <div><br> </div> <div>
information_schema contains things like Triggers, User_privileges, and Views--all of Type "View"--which causes me to wonder whether the Views module has built it.</div> <div><br> </div> <div>My problem is that although I can see dd08 within PhpMyAdmin, I cannot find it in the System X Finder and so I have no idea how to FTP it to the host.</div>
<div><br> </div> <div>Thanks for your patience.</div> <div><br> </div> <div>Steve<br> <div> <div>On Jul 23, 2008, at 5:32 PM, Steve Edwards wrote:</div> <br> <blockquote type="cite"> <div bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Arial">mysql is the system database for your MySQL server. It sounds like your db is dd08. Can you look in that database and see what tables are there? If you see ones such as access, blocks, blocks_roles, then that's your Drupal db.</font></font><br>
<br> Steve Hays wrote: <blockquote type="cite">Steve, <div><br> </div> <div>Here's the variable: mysqli://root:xxxxxxx@localhost/dd08.</div> <div><br> </div> <div>PhP My Admin lists the following 3 databases, all of which seem to be Drupal related:</div>
<div><span style="white-space: pre;"> </span>dd08 (which I created)</div> <div><span style="white-space: pre;"> </span>information_schema (which seems to be Views related)<br> </div> <div><span style="white-space: pre;"> </span>mysql (which has 17 records that may or may not have anything to do with the Drupal site. I can't tell.)<br>
</div> <div><br> </div> <div>Now, you need to understand that I'm not a programmer, and I don't work in Terminal mode. Instead, I'm using Mamp, which makes PhP and SQL work within what I regard as a somewhat normal user interface. Drupal also operates within Mamp. So, I'm looking for actual files and folders in System X, and what I find is the following:</div>
<div><br> </div> <div>Mamp >>db>>mysql>>dd08 (folder), ib_logfile0, iblogfile1, ibdata1, mysql(folder). [The comma-separated items are all the same level.]</div> <div><br> </div>
<div>The mysql folder contains 51 files with terminations in ..frm, ..MYD, and MYI. The dd08 folder contains only a single file called "db.opt" (options?).</div> <div>I find nothing in that folder that bears any similarity to "information_schema."</div>
<div><br> </div> <div>So, I'm befuddled. If I have to, I suppose I can learn enough about Terminal mode to find the proper file and upload it.</div> <div><br> </div> <div>I guess I don't even know quite what to ask. Perhaps this will give someone enough info to extend a suggestion.</div>
<div><br> </div> <div>Thanks,</div> <div><br> </div> <div>Steve Hays</div> <div>Department of Classics</div> <div>Ohio University</div> <div><span style="white-space: pre;"> </span><br>
</div> <div><span style="white-space: pre;"> </span><br> <div> <div>On Jul 23, 2008, at 4:49 PM, Steve Edwards wrote:</div> <br> <blockquote type="cite"> <div bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Arial">settings.php in /sites/default. Look for the $db_url variable around line 93.<br> <br> Steve<br> </font></font><br> Steve Hays wrote: <blockquote type="cite"> <pre>
Guys,
I'm in the process of uploading my alpha-version site. I've got the
Drupal folder uploaded. Now I need to find the db it has stored
things in, and I'm not sure where to find it.
I'm on a new Mac, operating within Mamp. Any chance that any of you
are operating in a similar environment and can tell me which files/
folders I need to upload and to which folders within the webhosting
site?
Steve Hays
</pre> </blockquote> </div> -- <br> [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]</blockquote> </div> <br> </div> </blockquote>
</div> -- <br> [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]</blockquote> </div> <br> </div> </blockquote> </div> -- <br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]</blockquote>
</div><br></div></div></div></div><br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br></div>