How do I back up my MYSQL stuff for shared hosting?

Discussion in 'MySQL' started by Dmak02, Aug 17, 2008.

0
  1. #1
    I want to back up all my websites MySQL stuff. I have a shared hosting account and I can access phpmyadmin. Is tehre anyway to do it automatically?
     
    Dmak02, Aug 17, 2008 IP
  2. ninjacluster

    ninjacluster Peon

    Messages:
    132
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Do you have a control panel like cpanel?
     
    ninjacluster, Aug 17, 2008 IP
  3. Dmak02

    Dmak02 Peon

    Messages:
    494
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I don't have CPANEL, but I have SSH access
     
    Dmak02, Aug 17, 2008 IP
  4. ryandanielt

    ryandanielt Well-Known Member

    Messages:
    1,797
    Likes Received:
    37
    Best Answers:
    0
    Trophy Points:
    185
    #4
    just go into phpmyadmin and export everything into a text file. this is the easiest way
     
    ryandanielt, Aug 17, 2008 IP
  5. Dmak02

    Dmak02 Peon

    Messages:
    494
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Well, i have about 5 different phpmyadmin. Anyway for me to just have it automatically done?
     
    Dmak02, Aug 17, 2008 IP
  6. HBZSoftware.com

    HBZSoftware.com Peon

    Messages:
    88
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    You can setup a cron job to download the database if you can get your shared host to give you read access to the actual database files, usually stored in /var/...

    Or, look into mysqldump
     
    HBZSoftware.com, Aug 17, 2008 IP
  7. blueribbon

    blueribbon Peon

    Messages:
    29
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    your best best is to use mysqldump -all-databases
     
    blueribbon, Aug 18, 2008 IP