Which backup techniques i use ?

Discussion in 'Databases' started by harshpatel, Oct 5, 2011.

0
  1. #1
    I want to take backup my database every two day.

    Which backup techniques i use ?
     
    harshpatel, Oct 5, 2011 IP
  2. sarahk

    sarahk iTamer Staff

    Messages:
    28,807
    Likes Received:
    4,534
    Best Answers:
    123
    Trophy Points:
    665
    #2
    Depends on your systems.

    My wordpress blogs have a plugin that emails a back up to me every day/week (differs blog to blog)

    I also have a desktop program called SqlYog that can automate backups of remote databases (ie websites)
     
    sarahk, Oct 5, 2011 IP
  3. Mohammed Ammar

    Mohammed Ammar Member

    Messages:
    39
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3
    use wordpress because it has a plugin which mail daily.
     
    Mohammed Ammar, Oct 7, 2011 IP
  4. supervds

    supervds Greenhorn

    Messages:
    39
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #4
    whm auto backup is best but then you need your own server for that.
     
    supervds, Oct 7, 2011 IP
  5. signorm68

    signorm68 Well-Known Member

    Messages:
    984
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    108
    #5
    you can also buy navicat and make backups to your desktop
     
    signorm68, Oct 7, 2011 IP
  6. roguemaster

    roguemaster Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    need more information. are you talking about backing up just your database? what database are you using?
     
    roguemaster, Oct 7, 2011 IP
  7. geek12

    geek12 Greenhorn

    Messages:
    21
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #7
    geek12, Oct 14, 2011 IP
  8. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #8
    As Sarah said, it depends on your system. There's no "one size fits all" solution to database backup.
     
    Rukbat, Oct 14, 2011 IP
  9. Commoditytips

    Commoditytips Peon

    Messages:
    27
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    hello all

    • Make incremental backups
    • Create Java archives
    • Find documentation to use other backup devices and programs
    • Encrypt your data..
    ​
     
    Commoditytips, Oct 17, 2011 IP
  10. expertvm

    expertvm Peon

    Messages:
    29
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Let us know what control panel you use and the database size you are going to backup too.

    Thanks!
     
    expertvm, Oct 23, 2011 IP
  11. dagofee

    dagofee Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    the best solution I've found is to dump the databases on my vps using rsnapshot, automysqlbackup and amazon S3
     
    dagofee, Oct 23, 2011 IP
  12. guavatip

    guavatip Peon

    Messages:
    234
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #12
    i think depend on your server/ site .
     
    guavatip, Nov 2, 2011 IP
  13. processblue

    processblue Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #13
    Do it via a backup script called 'automysqlbackup' (Google iT) place in the root dir of your webserver and add database names you want to back up and change any other settings to suit, then set up a cron to automate. Good luck
     
    processblue, Jan 14, 2012 IP
  14. mmerlinn

    mmerlinn Prominent Member

    Messages:
    3,197
    Likes Received:
    819
    Best Answers:
    7
    Trophy Points:
    320
    #14
    We don't know which backup techniques that you use. You did not tell us.
     
    mmerlinn, Jan 14, 2012 IP