Is a full MySQL backup enough to restore a database?

Discussion in 'MySQL' started by qwikad.com, Jul 26, 2013.

0
  1. #1
    I generated and downloaded my MySQL database backup in case something goes wrong. Are the database files that I downloaded enough to restore the database back to where it was if something goes wrong? What else should be done to ensure that a full database/site backup is available? Thanks.
     
    qwikad.com, Jul 26, 2013 IP
  2. A_ManojKumar

    A_ManojKumar Active Member

    Messages:
    131
    Likes Received:
    8
    Best Answers:
    1
    Trophy Points:
    65
    #2
    It is just enough. Please backup the files too in case something goes wrong with script/template whatever it is.
     
    A_ManojKumar, Jul 26, 2013 IP
  3. qwikad.com

    qwikad.com Illustrious Member Affiliate Manager

    Messages:
    7,312
    Likes Received:
    1,702
    Best Answers:
    31
    Trophy Points:
    475
    #3
    Yes, I FTPed the entire website (all files/image) as well.
     
    qwikad.com, Jul 27, 2013 IP
  4. fare

    fare Well-Known Member

    Messages:
    89
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    145
    #4
    Yeah, a backup of your home directory and database is sufficient for a full site backup/restore.
     
    fare, Jul 27, 2013 IP
  5. jimmyt200388

    jimmyt200388 Well-Known Member

    Messages:
    192
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    130
    #5
    Thats all I do. Backup all files on server and MySQL backup. Dont think theres much else you can do!
     
    jimmyt200388, Jul 28, 2013 IP
  6. o_iSniPe_xX

    o_iSniPe_xX Well-Known Member

    Messages:
    482
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    155
    Digital Goods:
    1
    #6
    All you need is a home directory backup, and SQL backup. That's all.
     
    o_iSniPe_xX, Jul 28, 2013 IP