PDA

View Full Version : backing up via the command line


senbonzakura
Fri 6th Jun '08, 5:52pm
Hi i'm using the following command in an attempt to save backup via SSH

mysqldump --opt -Q -u dbusername -p databasename > backupname.sql

the problem is after i type the command, i expected to get a prompt asking for a password but the SSH Client just hangs and does nothing, any ideas please

thanks

Dilly
Sat 7th Jun '08, 9:05pm
mysqldump --opt -Q -u dbusername -p password databasename > backupname.sql

senbonzakura
Sat 7th Jun '08, 10:50pm
Hi, thanks i just gave that a go and it still seems to hang for a long time, btw with how the command had been written in my original post, wouldn't it have prompted me for a password ?