Athul Asked: 2010-04-12 11:59:40 +0800 CST2010-04-12 11:59:40 +0800 CST 2010-04-12 11:59:40 +0800 CST how to backup mysql db to a ftp 772 how to backup a mysql database regularly to a ftp server i mention ? Any script for doing so ? backup ftp mysql 1 Answers Voted Best Answer Richard Holloway 2010-04-12T13:22:40+08:002010-04-12T13:22:40+08:00 You could mount the remote ftp server using curlftpfs under /mnt/ftpserver/ for example and then backup your database using mysqldump --all-databases --opt > /mnt/ftpserver/mysql_backup.sql Alternatively you can perform the mysqldump and then use lftp to push the backup file to the ftp server using something like lftp -c "open -u <username>,<password> <servername>/<directory>; set ftp:rest-stor false; put mysql_backup.sql" If you need more detail, please add a comment.
You could mount the remote ftp server using
curlftpfsunder/mnt/ftpserver/for example and then backup your database usingAlternatively you can perform the
mysqldumpand then uselftpto push the backup file to the ftp server using something likeIf you need more detail, please add a comment.