471,306 Members | 835 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,306 software developers and data experts.

MySQL backup script

I'm looking for a script that I can run periodically (from crontab) that
creates a dump from a mysql database, stores it in a folder on the server
and maybe sends me a copy via email.

I think I would be able to write this myself, but I'm sure there must be
some decent ones around. Why reinvent the wheel, right?

Does anyone know a good one?
..soma
Jul 17 '05 #1
3 6059
somaBoy MX wrote:
I'm looking for a script that I can run periodically (from crontab) that
creates a dump from a mysql database, stores it in a folder on the server
and maybe sends me a copy via email.

I think I would be able to write this myself, but I'm sure there must be
some decent ones around. Why reinvent the wheel, right?

Does anyone know a good one?
.soma


there is an app "mysqldump" which can be run with the command line switches
mysqldump -u<username> -p<password> -ac >> sqlbackup.sql

the a means all mysql specific create options

and the c means complete insert statments

~Cameron
Jul 17 '05 #2
On Thu, 29 Jan 2004 00:33:30 +0100, "somaBoy MX" <no**@nonesuch.net>
wrote:
I'm looking for a script that I can run periodically (from crontab) that
creates a dump from a mysql database, stores it in a folder on the server
and maybe sends me a copy via email.

I think I would be able to write this myself, but I'm sure there must be
some decent ones around. Why reinvent the wheel, right?

Does anyone know a good one?
.soma


Here you go.... http://www.phpfreaks.com/script/view/11.php I'm using
it with a daily cron job and each morning my Mysql database turns up
in my email. It was also store a copy on your server in whatever
directory you like to choose.

HTH,
Neil

Jul 17 '05 #3

"Neil" <me@nospam.net> wrote ...
: Here you go.... http://www.phpfreaks.com/script/view/11.php I'm using
: it with a daily cron job and each morning my Mysql database turns up
: in my email. It was also store a copy on your server in whatever
: directory you like to choose.

Thanks, it's exactly what I was looking for...
..soma
Jul 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by James | last post: by
4 posts views Thread by Neil | last post: by
1 post views Thread by Konrad | last post: by
6 posts views Thread by Mosher | last post: by
reply views Thread by Duane Winner | last post: by
4 posts views Thread by news | last post: by
1 post views Thread by Karuna | last post: by
6 posts views Thread by frank78 | last post: by
4 posts views Thread by Bootstrap Bill | last post: by
15 posts views Thread by Jerry Yang | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.