how to backup a mysql database regularly to a ftp server i mention ?
Any script for doing so ?
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.