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?"
msg40413/pgp00000.pgp
Description: PGP signature