Actually there are programs which do that.
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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@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