I'm a little confused when it comes to backing up my database. I want to download a copy of my database to my home computer. I looked in the Knowledge Base and went to the page on how to do a backup, but I'm not clear if that will let me download it to my computer, or if it backs it up on DreamHost's computers.
Also, the instructions say, "1. Use phpMyAdmin and use the options there to dump the contents to a text file." I went to phpMyAdmin, and I'm not sure which options to use. Can anyone help me, step-by-step?
Then it says: "2. From the shell, run this command: [and then the command to run]"
I understand how to run the command (I think), but where is the shell? I haven't used telnet in a long time, but I assume this means I can run this command from my web browser in phpMyAdmin?
I understand creating web pages and running some scripts (mostly, Perl and PHP) pretty well, but on databases, I'm an amateur. Help appreciated.