automaticlly backup mysql db data

[Anon]

I would like to ask how to write a shell script in a crontab to automatically backup mysql db data and then compressed it? Where can find the source code?
my config is LAMP == linux+apache+mysql+php

[[deleted]]

F'ing hell.. doesn't anybody search before they post?

Did you look at the MySQL manual at all?

[Anon]

sorry, maybe i did not explain my question clearly. the main point of my question is not backup mysql db, but how to use crontab to perform this task automatically. it needs to write shell script and i need a reference about it.
of course everyone can find the stuff about db backup in mysql documentation, but it is backup manually. i want a automatic backup using crontab in linux. Vincent, do you understand what i asked now?

[[deleted]]

The crontab simply runs scripts.
How you can put scripts in the crontab is descripbed in 'man cron' and 'man crontab'

The script itself would just contain the mysqldump command:

#!/path/to/sh
mysqldump databasename -u username -ppassword -h host > backupfile.sql

[Anon]

Je cherche a faire pareil...
si vous avez une solution...
Merci,
Alain

[[deleted]]

sigh

For some reason the french always seem to think that the entire world speaks french.

They even reply in french to an english post...

[Anon]

Sorry !

I would like to do the samething...

1) I create a script on my server i will put in cron :

#!/bin/bash
#

backup of mysql server

#
mysqldump -c -h[] -u[] --password=[] [DatabaseName] > path/mysqlbackup.sql
gzip -f -9 path/mysqlbackup.sql

2) I create a ftp script in two part :

ftpbackup:

download backup file

ftp -i -n hostname < script.txt

and script.txt :

user username password
get path/mysqlbackup.sql.gz

Alain