Gary, I think you read the Help Vampire article too? *chuckle*. This person's not a help vampire though, by the definition in the article :-)
Kobus
listout@accidentaltechie.org 4/20/2006 4:31:00 PM >>>
"Morbus Iff" wrote:
I took my lead from this guy --
We are both fighting the same war: you're rude to newbs, I'm rude to
newbs who
don't think they're newbs.
Idea:
Let's not. Or at least not each other. :)
Seriously, no harm intended to the OP (front page person), and even more especially not to you. Really.
I am a magnanimous, friendly, often-caustic-without-meaning-to-be and wide-open guy who likes to laugh (at myself, often and especially.)
No harm (intended), no foul (I hope.)
Over and out. -- Gary
(I don't really think we're rude, by the way. Either one.)
Hi all, I'm hoping someone can help me please. I had installed drupal using cpanel. Recently, I tried changing the username for my account. That had my site (my drupal site) unreachable, with an "unable to select database," error. Well, I realized that the problem was that my cpanel interface adds a prefix to the database, as in myoldaccountid_drpl1 when changed to mynewaccountid_drpl1 will not work. Amazingly, even when I changed the config file, which is settings.php in the sites/default directory. I'm perplexed as to why that didn't work. I looked all through my site and could not find any other place where the actual name of the database was hard-coded. Question: Is there some other place where the actual database name will be found in the code? If it was just two lines in the settings.php file, then when I changed that database name to reflect the new database name (new prefix ) it should have worked. This fear of loss of the site brought up the importance of doing a backup for restore or hosting elsewhere. Next question... if I wanted to backup everything so that it could be setup elsewhere or just so that everything could be restored, how would I do that? what tools might I use to backup the database? I'm thinking phpmyadmin There are several ways to backup and save a database and I'm not sure which way would be the best. There's SQL, LaTex, CSV, MS CSV for Excel... well, you get the idea, many alternatives. How might I select one that would best allow me to save and then restore - the latter task being my key interest here, easy to restore on sever or to setup site elsewhere.
It occurs to me that many files and directories would need to be saved but it seems like I cannot even access the files directory to back that up if I wanted to do so. I might zip and then backup the zip file onto a disk. But what about the files directory? I can't ftp (copy) the file to local hard drive. What should I do? I'm obviously planning on using an ftp tool to download the entire site - the drupal site... it just won't let me get what is in the files folder/directory. thanks in advance for any help, Bruce
++++++++++++++++++++++++++++++++++++++++++++++++++++ Word Salad Poetry Magazine - join us online at: http://wordsalad.net/ and also -> Check out the Buffy the Vampire Slayer writing Street Exposure - Street Newspaper http://wordsalad.net/StreetExposure/ Bruce Whealton - Webmaster/Designer/publisher/Writer http://trianglewebservices.com/ ++++++++++++++++++++++++++++++++++++++++++++++++++++
On Apr 23, 2006, at 10:22 AM, Bruce Whealton wrote:
Hi all, I'm hoping someone can help me please. I had installed drupal using cpanel. Recently, I tried changing the username for my account. That had my site (my drupal site) unreachable, with an "unable to select database," error. Well, I realized that the problem was that my cpanel interface adds a prefix to the database, as in myoldaccountid_drpl1 when changed to mynewaccountid_drpl1 will not work. Amazingly, even when I changed the config file, which is settings.php in the sites/default directory. I'm perplexed as to why that didn't work. I looked all through my site and could not find any other place where the actual name of the database was hard-coded. Question: Is there some other place where the actual database name will be found in the code?
CPanel setups will also frequently prefix the database username as well. You will want to check that, too. In CPanel, you can look at your MySQL users and databases.
I have no idea if your password was reset as well.
Next question... if I wanted to backup everything so that it could be setup elsewhere or just so that everything could be restored, how would I do that? what tools might I use to backup the database? I'm thinking phpmyadmin There are several ways to backup and save a database and I'm not sure which way would be the best. There's SQL, LaTex, CSV, MS CSV for Excel... well, you get the idea, many alternatives. How might I select one that would best allow me to save and then restore - the latter task being my key interest here, easy to restore on sever or to setup site elsewhere.
You can use export in phpMyAdmin. Select all the tables (unless you have a huge table like the zipcodes, you might want to skip that one), go through the various settings you want, and export a tgz backup.
It occurs to me that many files and directories would need to be saved but it seems like I cannot even access the files directory to back that up if I wanted to do so. I might zip and then backup the zip file onto a disk. But what about the files directory? I can't ftp (copy) the file to local hard drive. What should I do? I'm obviously planning on using an ftp tool to download the entire site
- the drupal site... it just won't let me get what is in the files
folder/directory.
Are you looking in your html or public_html folder? If your host won't give you access to your directories, then ask them to do the backup for you.
Hope this helps.
Laura
Laura Scott, President pingVision, LLC 4450 Arapahoe Ave, Suite 100 Boulder, CO 80303 www.pingv.com
laura@pingv.com 303.415.2559 303.459.4859 (direct)
Changing a username for an account with WHM or Cpanel usually results in havoc. In a shared scenario the username is appended to databasename.
If your database is name drupal then it becomes username_drupal and since your password is attached to a username rather than inherited in some way. In other words you create a username when you create a new account...then a cpanel password is assigned to to that username or account. as for the database: My Cpanel will not allow me to change successfully a username. I must create a new account and never use the old username again. If I want to use something similar, I change the last letter to a number such as olduser1...usually 8 letters or less. and assign any password to it. then each database becomes olduser1_drupal and then I create a database username such as asdf123 and use it for that and all other databases on that account.
Hope this helps Russ Griechen
From: Bruce Whealton To: support@drupal.org Sent: Sunday, April 23, 2006 11:22 AM Subject: [support] Database problem
Hi all, I'm hoping someone can help me please. I had installed drupal using cpanel. Recently, I tried changing the username for my account. That had my site (my drupal site) unreachable, with an "unable to select database," error. Well, I realized that the problem was that my cpanel interface adds a prefix to the database, as in myoldaccountid_drpl1