[support] Where are my SQL db files?

[Victor Kane]

Later on, check out this video on the Lullabot site, it might prove to be of
some assistance to you:

http://www.lullabot.com/videocast/install_local_web_server_mac_osx

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

> Steve,
> 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.
>
> Peace, and many thanks.
>
> Steve Hays
>
> On Jul 23, 2008, at 5:44 PM, Steve Edwards wrote:
>
>  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.
>
> Steve
>
> Steve Hays wrote:
>
> Steve,
>  Yes.  dd08 does contain that information.  I can view it from within PhP
> My Admin.
>
>  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.
>
>  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.
>
>  Thanks for your patience.
>
>  Steve
>  On Jul 23, 2008, at 5:32 PM, Steve Edwards wrote:
>
>  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.
>
> Steve Hays 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/ ]
>
>
>   --
> [ Drupal support list | http://lists.drupal.org/ ]
>
>
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20080723/475956c5/attachment.htm