Re: PHP Backing up a Database?
| From: | Joe Stump | Date: | Sun, 18 Nov 2001 23:52:39 +0000 |
| Subject: | Re: PHP Backing up a Database? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-75050@lists.php.net to get a copy of this message | ||
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: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
Joe Stump <joe@joestump.net>
------------------------------------------------------------------------
"How would this sentence be different if pi equaled 3?"