Just above the line you cite ("Here's the variable") is an explanation of the various fields, explaining that "dd08" is the database you want.

Check out the Drupal Handbook Documentation:
Copying a site to a local MAMP installation on a Mac
http://drupal.org/node/232460

Has some good info, even though you don't need to go to "terminal mode".

Victor Kane
http://awebfactory.com.ar

On Wed, Jul 23, 2008 at 6:26 PM, Steve Hays <hays@ohio.edu> wrote:
Steve,

Here's the variable: mysqli://root:xxxxxxx@localhost/dd08.

PhP My Admin lists the following 3 databases, all of which seem to be Drupal related:
dd08 (which I created)
information_schema (which seems to be Views related)
mysql (which has 17 records that may or may not have anything to do with the Drupal site.  I can't tell.)

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:

Mamp >>db>>mysql>>dd08 (folder), ib_logfile0, iblogfile1, ibdata1, mysql(folder).  [The comma-separated items are all the same level.]

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?).
I find nothing in that folder that bears any similarity to "information_schema."

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.

I guess I don't even know quite what to ask.  Perhaps this will give someone enough info to extend a suggestion.

Thanks,

Steve Hays
Department of Classics
Ohio University


On Jul 23, 2008, at 4:49 PM, Steve Edwards wrote:

settings.php in /sites/default.  Look for the $db_url variable around line 93.

Steve

Steve Hays wrote:
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
  
--
[ Drupal support list | http://lists.drupal.org/ ]


--
[ Drupal support list | http://lists.drupal.org/ ]