<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body 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 cite="mid:EE01BA8D-2072-45EA-ADBD-B55EBAC4C95F@ohio.edu"
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 class="Apple-interchange-newline">
<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 cite="mid:3EE8A0F1-3119-42A2-A057-11340947ADF7@ohio.edu"
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 class="Apple-tab-span" style="white-space: pre;"> </span>dd08
(which I created)</div>
<div><span class="Apple-tab-span" style="white-space: pre;"> </span>information_schema
(which seems to be Views related)<br>
</div>
<div><span class="Apple-tab-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 class="Apple-tab-span" style="white-space: pre;"> </span><br>
</div>
<div><span class="Apple-tab-span" style="white-space: pre;"> </span><br>
<div>
<div>On Jul 23, 2008, at 4:49 PM, Steve Edwards wrote:</div>
<br class="Apple-interchange-newline">
<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
cite="mid:A863C7C1-649F-4D46-B516-70EB8BDA71F8@ohio.edu" type="cite">
<pre wrap="">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 moz-do-not-send="true"
href="http://lists.drupal.org/">http://lists.drupal.org/</a> ]</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
-- <br>
[ Drupal support list | <a moz-do-not-send="true"
href="http://lists.drupal.org/">http://lists.drupal.org/</a> ]</blockquote>
</div>
<br>
</div>
</blockquote>
</body>
</html>