mysql database backup

[Who?]

how do i backup and download a mysql database in telnet?

[insiderhosting]

use the command

mysqldump -uusername -ppassword database_name > backup.sql


Then depending on where you want to download it, IE to your local computer or another server, you would use FTP (local) and wget (server)

[Who?]

ah thanks, but is there anyway i can download the file in telnet, because i cant use FTP:(

[insiderhosting]

Where do you want to download that file, to your local computer or another server?

[atlas]

Dump it to a web accessible location then. Or, if you have SSH, use scp to copy it back over to your machine.

-mk

[Who?]

i want to download it to my comp