DA: database backup

From Kb_JMY(晉明夷)

Jump to: navigation, search

DirectAdmin: database backup


  • Ref: GreenHost ticket support#994474, 2007/12/22 09:35
-> 主題: How to create cronjobs for daily backup of my databases?


  • Question -- Suppose I want to :
  • backup my database "myacct_en"
  • daily at 1:00am,
  • zip it into *.zip
  • and put it in the folder: /home/myacct/domains/mysite.org/_bkup/
-> how to create such a Cronjobs?
  • Ans:
  • In DirectAdmin -> go "CronJob"
  • 時間 -> 0 1 * * *
  • command
-> mysqldump -uDB_USER -pDB_PASSWORD DBNAME | gzip > /home/myacct/domains/mysite.org/_bkup/DB_backup.sql.gz
-> OR mysqldump -uDB_USER -pDB_PASSWORD DBNAME | zip > /home/myacct/domains/mysite.org/_bkup/DB_backup.sql.zip
  • then compress all the database files (*.sql.zip) into a single file
-> cd /home/myacct/domains/mysite.org/_bkup; tar -czf all_7db_files.sql.tar.gz *.zip;
[Remarks: c=create, z=zip??, f=file]
Retrieved from "http://kb.healthkb.org/view/DA:_database_backup"



Personal tools