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 > >[email protected] > >https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > >_______________________________________________ >MediaWiki-l mailing list >[email protected] >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 _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
