469,126 Members | 1,292 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,126 developers. It's quick & easy.

automatically backup database

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.
Apr 12 '07 #1
2 1144
masdi2t
37
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.
Apr 13 '07 #2
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.
Apr 13 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Thiko | last post: by
2 posts views Thread by nt | last post: by
6 posts views Thread by Eric Herber | last post: by
1 post views Thread by alex | last post: by
4 posts views Thread by uthuras | last post: by
5 posts views Thread by jag | last post: by
10 posts views Thread by Konstantin Andreev | last post: by
4 posts views Thread by snoconegod | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.