Re: Database Backup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Andrew,

I like the idea of using the crontab even though I have never used it 
before.  I guess the first thing I need to do is make my script.  Thanks for 
the link to mysqldump, I think it will be usefull.  Do you happen to know 
how I might be able to push a file to another server using FTP?  Just 
playing around the past few days I have created a script that will get the 
contents of the table and bring up a download window so I can download it 
into an Excel file.  It doesnt use mysqldump, but it works.  But I need it 
to send the file to my FTP server automaticly.  Any suggestions??

Thanks,

Aaron


"Andrew Kreps" <andrew.kreps@xxxxxxxxx> wrote in message 
news:3f0cd691041005155069a3a70a@xxxxxxxxxxxxxxxxx
> On Tue, 5 Oct 2004 16:33:08 -0400, Aaron Todd <aaloki88@xxxxxxxxxxx> 
> wrote:
>> What is everyone doing to backup a MySQL database.  Just in case...I'd 
>> like
>> to backup mine, but I was wondering if there was a way to do it without
>> going to a page and clicking a button.  Is there a way to run a php 
>> script
>> on a time schedule and then push a backup file to an FTP server or
>> something.  Anyone out there doing anything like this?
>
> Personally, I go straight to the source.
>
> http://dev.mysql.com/doc/mysql/en/mysqldump.html
>
> You can write a PHP script that runs the dump, compresses the file and
> FTP's the file anywhere you like.  As Martin mentioned, You can run
> this PHP script from your crontab or Task Scheduler by invoking the
> interpreter from the command line, i.e. '/usr/local/bin/php
> /home/mydir/scripts/backupDB.php'.
> 



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux