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
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
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/ ]
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/ ]
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/ ]
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/ ]
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/ ]
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@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/ ]
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/ ]
-
Steve Edwards -
Steve Hays -
Victor Kane