<div>Hi all,</div> <div> 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</div> <div>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? <BR> 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.</div> <div>This fear of loss of the site brought up the importance of doing a backup for restore or hosting elsewhere.</div> <div>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 </div> <div>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.</div> <div> </div> <div>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.</div> <div>thanks in advance for any help,</div> <div>Bruce</div><BR><BR>++++++++++++++++++++++++++++++++++++++++++++++++++++<br>Word Salad Poetry Magazine - join us online at:<br>http://wordsalad.net/ and also -><br>Check out the Buffy the Vampire Slayer writing <br>Street Exposure - Street Newspaper<br>http://wordsalad.net/StreetExposure/<br>Bruce Whealton - Webmaster/Designer/publisher/Writer<br>http://trianglewebservices.com/<br>++++++++++++++++++++++++++++++++++++++++++++++++++++