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
mysqldump
check it out, either man or google
then ftp that file down, load it wherever, and mysql database < dump.sql
jack
-Original Message-
From: cosmin laslau [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 17, 2001 5:25 PM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP Backing u
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
_
3 matches
Mail list logo