Need info on exporting database please

Discussion in 'Databases' started by gamefreaked, Apr 8, 2010.

  1. #1
    Guys ..hi , i have a site i purchased for someone, its on a cpanel and im dumfounded why this cpanel doesnt have a option to backup database .So if i export from php admin will it leave the database on the server ? would it prompt me to copy to my pc? if so i dont know where to go from there really can someone give me some guidance please ? thanks
     
    gamefreaked, Apr 8, 2010 IP
  2. etc

    etc Well-Known Member

    Messages:
    3,234
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    158
    #2
    its in the phpmyadmn > select the database , check all the tables and export as sql :D
     
    etc, Apr 8, 2010 IP
  3. eadler25

    eadler25 Peon

    Messages:
    217
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    go to backup and see there is option to take backups
     
    eadler25, Apr 8, 2010 IP
  4. gamefreaked

    gamefreaked Peon

    Messages:
    686
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #4
    There is no backup option , as i said ........would exporting it leave a copy on the server ?
     
    gamefreaked, Apr 8, 2010 IP
  5. Guttu

    Guttu Peon

    Messages:
    728
    Likes Received:
    88
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Nope. It will prompt you to save file on PC.
     
    Guttu, Apr 9, 2010 IP
  6. WebHostingNerds.com

    WebHostingNerds.com Peon

    Messages:
    59
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Cpanel > Databases > PHPMyAdmin > Click on the DB you want to export > Click Export in the top menu > Select the tables you want to export ( probably all ) > Tick 'Save as file' > Click 'Go'
     
    WebHostingNerds.com, Apr 11, 2010 IP
  7. MEMORIES89

    MEMORIES89 Peon

    Messages:
    1,461
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    after taking backup , check all and delete. simple
     
    MEMORIES89, Apr 14, 2010 IP