1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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,151
    Likes Received:
    1,656
    Best Answers:
    29
    Trophy Points:
    475
    #3
    Yes, I FTPed the entire website (all files/image) as well.
     
    qwikad.com, Jul 27, 2013 IP
  4. fare

    fare Active Member

    Messages:
    89
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    95
    #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