automatically backup database

[mankolele]

Hi all.

I am triying to figure out that when I have a server which has a mysql database, I want to auto update the database, iI understand there is a script I need to use but do not know where to start. Does anyone have a clear explanation for me on to where to start.

Thank you in advance for all the responces.

[masdi2t]

Hi all.

I am triying to figure out that when I have a server which has a mysql database, I want to auto update the database, iI understand there is a script I need to use but do not know where to start. Does anyone have a clear explanation for me on to where to start.

Thank you in advance for all the responces.

this is an example (using mysqldump):
mysqldump --user=<user_name> --password=<password> --lock-all-tables \
--all-databases > <output_directory>/<output_file>

execute your script with cron in Linux or task scheduler in Windows or with your own scheduler program.

[mankolele]

this is an example (using mysqldump):
mysqldump --user=<user_name> --password=<password> --lock-all-tables \
--all-databases > <output_directory>/<output_file>

execute your script with cron in Linux or task scheduler in Windows or with your own scheduler program.

I see what you say I need to do, but that is where I get lost where , what , how do I put the script. Like when I go to the PC and switching it on saying I want to do the auto backuping of my database.

Thanks for the reply.