Database back up

Discussion in 'MySQL' started by Jim bob 9 pants, Dec 25, 2006.

0
  1. #1
    HI

    I just backed up one of my blogs and emailed the back up to my self

    Has anyone got or know of a script to do this for my other none wordpress sites? I guess I could look at the code and try and work it out, but if anyone has a prewritten script I would be for ever greatful

    Jamie

    PS MERRY CHRISTMAS
    I have had a truely delightful Christmas this year !!!
     
    Jim bob 9 pants, Dec 25, 2006 IP
  2. Seiya

    Seiya Peon

    Messages:
    4,666
    Likes Received:
    404
    Best Answers:
    0
    Trophy Points:
    0
    #2
    PHPmyadmin not easy enough?
     
    Seiya, Dec 25, 2006 IP
  3. Senpai IT

    Senpai IT Active Member

    Messages:
    453
    Likes Received:
    43
    Best Answers:
    0
    Trophy Points:
    68
    #3
    You can use mysqlhotcopy shell script to save a copy of the DB files. Then do gzip, then email the backup.gz to your email, and finally gunzip it to the location of DB files on a new server.
    Read more here: vbulletin.com/forum/showthread.php?t=134821
     
    Senpai IT, Dec 25, 2006 IP
  4. Jim bob 9 pants

    Jim bob 9 pants Peon

    Messages:
    890
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Its easy enough, just not quick enough, I have 10 data bases and it takes a while to go in and out of each one thats all.

    I am just looking for a quicker alternative.
     
    Jim bob 9 pants, Dec 25, 2006 IP
  5. Jim bob 9 pants

    Jim bob 9 pants Peon

    Messages:
    890
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Thanks I will look into that
     
    Jim bob 9 pants, Dec 25, 2006 IP
  6. dct

    dct Finder of cool gadgets

    Messages:
    3,132
    Likes Received:
    328
    Best Answers:
    0
    Trophy Points:
    230
    #6
    dct, Dec 27, 2006 IP
  7. Rogem

    Rogem Peon

    Messages:
    171
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #7
    I hear cPanel has a really good backup feature. Most web hosts should offer this feature.
     
    Rogem, Dec 27, 2006 IP
  8. krakjoe

    krakjoe Well-Known Member

    Messages:
    1,795
    Likes Received:
    141
    Best Answers:
    0
    Trophy Points:
    135
    #8
    krakjoe, Dec 27, 2006 IP
  9. Jim bob 9 pants

    Jim bob 9 pants Peon

    Messages:
    890
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Thanks all, getting some great ideas now
     
    Jim bob 9 pants, Dec 27, 2006 IP