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
but if my table is sooo big..
eg if large than 1 G. so use the mysqldump is more and more slowly
speed.
"Hans van Dalen" <[EMAIL PROTECTED]>
??:[EMAIL PROTECTED]
> Read the manual at the section:
>
> Disaster Prevention and Recovery
>
>
> Database Backups
>
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 da
mysqldump...lots and lots of options
http://www.mysql.com/doc/en/mysqldump.html
hth
Jeff
"Erich C.
