Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2006
    Posts
    33

    sql database backup question ?

    I know there is a scheduled tasks for cron jobs, but , I was wondering if anyone could recommend either php script or cron that I could use or try?
    what I would like to do is set one up to automate the backup on my Linux server sql database's at least once a day.

    Thank you


  2. #2
    You can use mysqldump tool to backup your database(s). An example of a command:

    mysqldump db_name > out.sql

  3. #3
    Join Date
    Jun 2006
    Posts
    33
    sorted now

    thank you for your reply

  4. #4
    Join Date
    Sep 2002
    Location
    Nashville, TN
    Posts
    237
    I usually do "mysqldump -e --quote-names"... read the man page and you'll see why.

    Thanks,

    Chris Miller
    ServerMotion

Posting Permissions

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