The hostname to connect to is "localhost" if connecting from a script on the server, or your domain name for connecting remotely. The database name and username need to be entered exactly as they appear in the MySQL manager in your control panel (CPanel) ie cpanelusername_dbname, etc. The password is the one you specified when…

Use the PHPMyAdmin feature in your control panel. In PHPMyAdmin, select the database you want to backup and select "Export" tab on the right screen. Choose the tables you wish to backup (or "Select All" for all tables). Scroll down and tick "Save File As…" and click on the "Go" button. Simply save the database…