What is better? Back ups from Phpmyadmin, Shell or from Cpanel

Discussion in 'MySQL' started by 4trianglesystems, Mar 28, 2007.

0
  1. #1
    It is a huge dilemma moving hosts or servers. The biggest issue is the Mysql databases.

    What is the best way to make a back up of a mysql databases where it will work on all servers regardless of mysql or php version.
     
    4trianglesystems, Mar 28, 2007 IP
  2. weknowtheworld

    weknowtheworld Guest

    Messages:
    306
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I personally would select phpmyadmin for backup from MySql Database..
     
    weknowtheworld, Mar 29, 2007 IP
  3. niteowl660

    niteowl660 Member

    Messages:
    65
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3
    Phpmyadmin is also my choice.
     
    niteowl660, Mar 29, 2007 IP
  4. serjio28

    serjio28 Peon

    Messages:
    37
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    For me the best choice are mysqldump and bash programming :)
     
    serjio28, Mar 29, 2007 IP
  5. sea otter

    sea otter Peon

    Messages:
    250
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    0
    #5
    SHELL by a wide wide margin!

    serjio28 is right. The more closely you can control --and monitor-- the process, the better off you'll be.
     
    sea otter, Mar 30, 2007 IP
  6. fabriciogr

    fabriciogr Active Member

    Messages:
    958
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    73
    #6
    it really depends...

    even though ssh is the best... phpMyAdmin dump can be pretty good when it's a small database and not much data..

    i've tried to dump big databases via phpMyAdmin and it was just not happening.
     
    fabriciogr, Apr 4, 2007 IP
  7. ninjashoes

    ninjashoes Well-Known Member

    Messages:
    1,401
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    138
    #7
    phpMyAdmin is only for small sites, you'll almost always have to become acustomed to actually using ssh
     
    ninjashoes, Apr 4, 2007 IP
  8. designcode

    designcode Well-Known Member

    Messages:
    738
    Likes Received:
    37
    Best Answers:
    0
    Trophy Points:
    118
    #8
    PHPMyAdmin backup is for small size DBs, use my sql dump instead if you have a DB with big data.
     
    designcode, Apr 4, 2007 IP