Best way to backup?

Discussion in 'General Chat' started by hostusfree, Oct 12, 2007.

Thread Status:
Not open for further replies.
0
  1. #1
    Hi guys we know that there are so many ways to backup your files.

    But what is the best way to backup and restore mysql

    Any easy ways?

    thanks
     
    hostusfree, Oct 12, 2007 IP
  2. Kerosene

    Kerosene Alpha & Omega™ Staff

    Messages:
    11,366
    Likes Received:
    575
    Best Answers:
    4
    Trophy Points:
    385
    #2
    I do a cPanel backup of the database, and also an 'export' .sql backup from phpMyAdmin.

    To restore: I just create an empty database, or drop everything out of the corrupt database, then import the sql file using phpMyAdmin.
     
    Kerosene, Oct 12, 2007 IP
  3. hostusfree

    hostusfree Banned

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    yes thats what i do but there must be an easier way?
     
    hostusfree, Oct 12, 2007 IP
  4. Kerosene

    Kerosene Alpha & Omega™ Staff

    Messages:
    11,366
    Likes Received:
    575
    Best Answers:
    4
    Trophy Points:
    385
    #4
    It's only about three mouse clicks!

    I'm sure you could set up a cronjob to backup your db. But I like to save the files safely on my local PC myself.
     
    Kerosene, Oct 12, 2007 IP
  5. hostusfree

    hostusfree Banned

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    so if you have 4 databases? you can download them all into one file and then when you upload it will it be 4 different dtabases again?
     
    hostusfree, Oct 12, 2007 IP
  6. anions

    anions Notable Member

    Messages:
    4,840
    Likes Received:
    179
    Best Answers:
    0
    Trophy Points:
    275
    #6
    No, you download them as 4 separate .sql files and import them to separate (empty) databases...

    I'm basically just repeating what kerosene said, but you're asking the same thing again :p
     
    anions, Oct 12, 2007 IP
  7. Red_Virus

    Red_Virus Well-Known Member

    Messages:
    3,756
    Likes Received:
    249
    Best Answers:
    0
    Trophy Points:
    135
    #7
    I also just do a complete Cpanel Backup on a daily basis & I think that is the best way :)
     
    Red_Virus, Oct 12, 2007 IP
  8. hostusfree

    hostusfree Banned

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    how do you reinstall the complete backup though
     
    hostusfree, Oct 12, 2007 IP
Thread Status:
Not open for further replies.