SSH mysql backup

Joe 90 · 27-08-2009, 01:00

Evening, I'm trying to make a backup of a databse via SSH

so, i've connected to the database;

Code:

mysql -h mysql14.streamline.net -u USERNAME -p

and then keep tryin this command but it doesn't ask for my password so obviously isn't working;

Code:

mysqldump --opt -Q -shuwarrior1 -p shuwarrior1 > /backups/backup.sql

I've never used SSH before so don't really know how to figure it out :/

27-08-2009, 01:00	#1
Joe 90 Absinthe Join Date: Jan 2007 Location: Chester Posts: 2,345	SSH mysql backup Evening, I'm trying to make a backup of a databse via SSH so, i've connected to the database; Code: mysql -h mysql14.streamline.net -u USERNAME -p and then keep tryin this command but it doesn't ask for my password so obviously isn't working; Code: mysqldump --opt -Q -shuwarrior1 -p shuwarrior1 > /backups/backup.sql I've never used SSH before so don't really know how to figure it out :/ __________________ 360 Blog \| Join GiffGaff \| Twitter

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode