This is what you'll want to do:

0 0 * * * /path/to/mysqldump -u[username] -p[username] [database] > /path/to/backup.sql

Put that above in your crontab (you might want to tar/gzip it too if it's big)
then download it via cron to your local box.

You could also look into rsync.

--Joe

On Sat, Nov 17, 2001 at 10:25:04PM +0000, cosmin laslau wrote:
> Hi,
> 
> Say I'm not really confident in the prowess of my server, and I want to 
> download my database onto my computer. Can that be done? What can I look 
> (FTP access) in the directory structure. I guess, where is it usually 
> located?
> 
> Thanks.
> 
> Cosmin Laslau
> 
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

Joe Stump <[EMAIL PROTECTED]>
------------------------------------------------------------------------
"How would this sentence be different if pi equaled 3?" 

Attachment: msg40413/pgp00000.pgp
Description: PGP signature

Reply via email to