SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    Not Bad, eh? Justin Sampson's Avatar
    Join Date
    Aug 2000
    Location
    N.S., Canada
    Posts
    487
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey,
    I was wondering if someone knew of a tutorial on setting up a cronjob to back up your mySQL database? Also when I do a normal mysql dump where is that file located?

    Is it excsible from the web or just ftp?
    I was wondering because I was going to set up a script on a free host to get the contents of the sql file regularly too and make another copy (can never be too safe).

    Thanks,
    Justin Sampson

  2. #2
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    This, in combination with the man page for 'crontab' should give you all the information you need.

    http://www.webmasterbase.com/article.php/228/883

    Basically, mysqldump puts the file in whatever directory you were located when you ran the program, or where you specify (if you specify a path with the output filename).
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •