backing up database

Discussion in 'Databases' started by Cal813, Sep 13, 2009.

0
Page 2 of 2
  1. NetStar

    NetStar Notable Member

    Messages:
    2,471
    Likes Received:
    541
    Best Answers:
    21
    Trophy Points:
    245
    #21
    Contact the administer and ask them to enable SSH for your account. Most will.

    If they don't..you can use a script to execute the same commands I gave you above..
     
    NetStar, Oct 4, 2009 IP
  2. NetStar

    NetStar Notable Member

    Messages:
    2,471
    Likes Received:
    541
    Best Answers:
    21
    Trophy Points:
    245
    #22
    Contact the administer and ask them to enable SSH for your account. Most will.

    If they don't..you can use a script to execute the same commands I gave you above..
     
    NetStar, Oct 4, 2009 IP
  3. Cal813

    Cal813 Active Member

    Messages:
    856
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    85
    #23
    Normally I know hosts won't give SSH access due to security issues
     
    Cal813, Oct 4, 2009 IP
  4. NetStar

    NetStar Notable Member

    Messages:
    2,471
    Likes Received:
    541
    Best Answers:
    21
    Trophy Points:
    245
    #24
    An SSH account can be restricted and controlled.

    Just ask your host rather than assuming...

    If they refuse to grant you SSH access to your account then use PHP or Perl to execute the commands I posted.

    -or- tell them to back up the mySQL database. Then change hosts.
     
    NetStar, Oct 4, 2009 IP
  5. timarcher52

    timarcher52 Peon

    Messages:
    62
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #25
    I use automysqlbackup, a freely available script from sourceforge. It works great taking daily, weekly, and monthly backups and emailing them to you. I email them to my gmail address for a poor mans "off site backup".

    Heres a link to the software:
    http://sourceforge.net/projects/automysqlbackup/
     
    timarcher52, Oct 4, 2009 IP
Page 2 of 2