http://www.spaceprogram.com/knowledge/cron_scp.html
Only thing you need to add is the a mysqldump line to your cron script before calling the scp.
Travis
A. Clausen wrote:
avenger wrote:
but if my table is sooo big.. eg if large than 1 G. so use the mysqldump is more and more slowly speed.....
I don't have one gig tables, but I do have a few that come in at a few hundred meg. I actually dump them to another machine on my network (100mbit NIC cards) and it usually takes no more than a four or five minutes. Since I do the main dump once a day at 1am, it could run for a half hour and I wouldn't care.
For critical data (mainly our accounting database), I do hourly dumps. Those tables are relatively small, so it doesn't take more than 40 or 50 seconds (I've only seen it take that long when things have been pretty busy).
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
