Re: [PHP] PHP Backing up a Database?
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 +, 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/pgp0.pgp Description: PGP signature
RE: [PHP] PHP Backing up a Database?
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 up a Database? 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] -- 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]