<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><DIV><DIV>On Apr 23, 2006, at 10:22 AM, Bruce Whealton wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><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></DIV></BLOCKQUOTE><DIV><BR class="khtml-block-placeholder"></DIV>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.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I have no idea if your password was reset as well. </DIV><DIV><BR><BLOCKQUOTE type="cite"><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></BLOCKQUOTE><BLOCKQUOTE type="cite"><DIV> </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></BLOCKQUOTE><DIV><BR class="khtml-block-placeholder"></DIV>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.<BR><BLOCKQUOTE type="cite"> <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></BLOCKQUOTE><DIV><BR class="khtml-block-placeholder"></DIV>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.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Hope this helps.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Laura<BR><DIV><DIV><FONT class="Apple-style-span" color="#066CBD"><B><BR class="khtml-block-placeholder"></B></FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD"><B><BR class="khtml-block-placeholder"></B></FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD"><B>Laura Scott, </B></FONT><FONT class="Apple-style-span" color="#066CBD">President</FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD">pingVision, LLC</FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD">4450 Arapahoe Ave, Suite 100</FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD">Boulder, CO 80303</FONT></DIV><DIV><A href="http://www.pingv.com"><FONT class="Apple-style-span" color="#066CBD">www.pingv.com</FONT></A></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><FONT class="Apple-style-span" color="#066CBD"><A href="mailto:laura@pingv.com">laura@pingv.com</A></FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD">303.415.2559</FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD">303.459.4859 (direct)</FONT></DIV><DIV><FONT class="Apple-style-span" color="#066CBD"><BR class="khtml-block-placeholder"></FONT></DIV><DIV><BR class="khtml-block-placeholder"></DIV></DIV><BR></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV></BODY></HTML>