Backing up!

Discussion in 'Databases' started by Okenyon, Jun 14, 2010.

  1. #1
    hi i have a new adult site and have worked very hard on it - it has 100's of images and videos that i do not have on my system as a freelancer uploaded them for me

    how can i make a decent back up without downloading all these videos etc?
     
    Okenyon, Jun 14, 2010 IP
  2. netload

    netload Member

    Messages:
    105
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    28
    #2
    For MySQL, with ssh
    mysqldump -p -ulogin -hlocalhost --add-drop-table --quote-name db_name > backup.sql
    tar -czf backup.tar.gz backup.sql

    without ssh, use mysqldumper.net
     
    netload, Jun 15, 2010 IP
  3. Okenyon

    Okenyon Banned

    Messages:
    528
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    28
    #3
    that means nothing to me lol - very new to this?
     
    Okenyon, Jun 15, 2010 IP
  4. bvsonline

    bvsonline Peon

    Messages:
    83
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Hi,

    I think you need to take the backof of the whole site to your local system. Do you have any control panel to manage your site? If you have cpanel, then under "backup" section, you have the option to take a compressed backup of your whole site including your mail and database backup.

    The above given command is the one used to take backup of your mysql database. You can either ssh into your server (remote login) or from the site mysqldumper.net you can download an application for taking mysql backups from your local machine.
     
    bvsonline, Jun 28, 2010 IP