Downloading database help


i can’t download my database from phpadmin anymore it just freezes up cause my database is too big, i have been trying to learn winscp client, im confused i ask dreamhost support what info to put in it and they give me info for the file server im on, where can i get info on how to connect to my mysql server it’s called bang is all the info i could find on it in my client area? i have had some support threads with dreamhost support but they just point my to a wiki that doesnt really have tell me what info i need to connect to the bang mysql server with winscp client so i can just download the database. could someone please educate me on how to do this?


i made some progress with this, i see now i don’t need to connect to a mysql server i do need to connect to the file server. i entered this changeing all the following info:
username password yourMySQLHostname dbname
the file in my root directory is output.sql now when i enter the command should i change output to the name of my database? or should i just leave it, does it matter?
If i manually rename a .sql file does it still work?

mysqldump --opt --user=username --password=password --host=yourMySQLHostname dbname > output.sql


Change the output to ~/output.sql so it ends up in your home directory, no matter where you are when you run the command. You can manually rename a .sql file once dumped.



Create “db_backup” and run from $HOME.


USAGE: sh db_backup [dbname]

set -e
pfx=$(date +%y%m%d)
mkdir -p ~/archives
cd ~/archives
echo “SQL Backup of “$1” attached” >> msg.txt
mysqldump --opt -u $usr -p$psw -h $sql $1 > SQL_"$1"$pfx.sql
tar zcf SQL_Backup
"$1"$pfx.tar.gz *.sql
mutt -s "SQL Backup of “$1"” -a SQL_Backup
"$1"_$pfx.tar.gz $eml < msg.txt
rm -rf {*.sql,msg.txt}
exit[/code]Prepend # to the mutt line if you don’t want it to be emailed to you.

Maximum Cash Discount on any plan with MAXCASH

How To Install PHP.INI / ionCube on DreamHost