Here's a little how to on using cron and scp to do automated backups of
your data:
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 so
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
===
>
> Database Backups
>
> with mysqldump you can dump a whole database.
>
> hans
>
>
> At 09:03 29-10-03 -0500, you wrote:
> >Hi there,
> >
> >Does anyone have some tips or advice for creating backups of all the
tables
> >and data con
Read the manual at the section:
Disaster Prevention and Recovery
Database Backups
with mysqldump you can dump a whole database.
hans
At 09:03 29-10-03 -0500, you wrote:
Hi there,
Does anyone have some tips or advice for creating backups of all the tables
and
ROTECTED]cc:
yrent.net> Subj
Hi there,
Does anyone have some tips or advice for creating backups of all the tables
and data contained therein? Do you use custom solutions or perhaps
open-source projects?
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
