How to back up the MYSQL databse?

Discussion in 'MySQL' started by alanX, May 22, 2006.

  1. #1
    To everyone:
    I want to ask how to back up the databse in MYSQL. How to convert the database into text format. Like .sql. microsoft excel etc


    thanks
     
    alanX, May 22, 2006 IP
  2. T0PS3O

    T0PS3O Feel Good PLC

    Messages:
    13,219
    Likes Received:
    777
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Use PHPMyAdmin - makes it childsplay to back-up your DBs to any format.
     
    T0PS3O, May 22, 2006 IP
  3. PinoyIto

    PinoyIto Notable Member

    Messages:
    5,863
    Likes Received:
    170
    Best Answers:
    0
    Trophy Points:
    260
    #3
    The easiest way I guess if you're using cpanel goto backup then back the db.. or you can do it in your hosting phpadmin export....
     
    PinoyIto, May 22, 2006 IP
  4. Farkas

    Farkas Well-Known Member

    Messages:
    389
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    140
    #4
    Farkas, May 22, 2006 IP
  5. Will.Spencer

    Will.Spencer NetBuilder

    Messages:
    14,789
    Likes Received:
    1,040
    Best Answers:
    0
    Trophy Points:
    375
    #5
    Here's the script I run to backup all of my MySQL databases:
    
    #!/bin/sh
    date=`date -I`
    mysqldump --all-databases -p | gzip > backup-$date.sql.gz
    
    Code (markup):
     
    Will.Spencer, May 22, 2006 IP