[support] Database problem

[Bruce Whealton]

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/
++++++++++++++++++++++++++++++++++++++++++++++++++++
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20060423/3c4d5f22/attachment.htm