Actually there are programs which do that.
http://www.mysqldumper.de/en/
But that's beside the point. There are also programs out there which
optimize databases server wide. Don't know anymore where I found
them, but I have them installed on my servers.
At 12:32 AM 2/14/2009, you wrote:
Ha, yeah, sure, I was just giving the structure and did
not want to
specify a time. You would of course need to replace this like you would
need to replace everything else (e.g. "username"). I just wanted to give
an idea for research, not a finished solution (which I cannot give, not
knowing the specifics). I would dump once every day, but on a site with
very little traffic once a week may be enough, while a site with very
heavy traffic or a large database might want to dump individual tables
separately (so as not to have huge dumps or exceed execution time limits) ...
I, personally, would have the cronjob call an .sh script that gives a
unique name based on the date to each dump and deletes old dumps after a
certain time (maybe 90 days).
Manfred Kooistra wrote:
And (first of all): Set up a cronjob to dump your
database on a regular
basis so whatever happens you won't loose your data. Kind of like this:
* * * * * mysqldump db_name -u username -ppassword > /home/username/
backup.sql
Shouldn't at least one of those * be different? As it is, it would be
started every minute...
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_ _
(o) (o)
oOOO----(_)----OOOo---
Henny (Lee Hae Kang)
-----------------------------
http://www.henny-savenije.pe.kr Portal to all my sites
http://www.hendrick-hamel.henny-savenije.pe.kr (in English) Feel free
to discover Korea with Hendrick Hamel (1653-1666)
http://www.hendrick-hamel.henny-savenije.pe.kr/indexk2.htm In Korean
http://www.hendrick-hamel.henny-savenije.pe.kr/Dutch In Dutch
http://www.vos.henny-savenije.pe.kr Frits Vos Article about Witsen
and Eibokken and his first Korean-Dutch dictionary
http://www.cartography.henny-savenije.pe.kr (in English) Korea
through Western Cartographic eyes
http://www.hwasong.henny-savenije.pe.kr Hwasong the fortress in Suwon
http://www.oldKorea.henny-savenije.pe.kr Old Korea in pictures
http://www.british.henny-savenije.pe.kr A British encounter in Pusan (1797)
http://www.genealogy.henny-savenije.pe.kr/ Genealogy
http://www.henny-savenije.pe.kr/phorum Bulletin board for Korean studies