[support] Where are my SQL db files?

[Steve Edwards]

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/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20080723/cf0f8d5e/attachment.htm