Backup Mysql database

Discussion in 'MySQL' started by smartcomputer, Apr 6, 2010.

0
  1. #1
    Hello

    I want to take backup of my mysql database can anyone help me with this? I want backup with complete data in it
     
    smartcomputer, Apr 6, 2010 IP
  2. Shauni

    Shauni Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    mysqldump -u$mysql_user -p$mysql_password -h$mysql_host -x -R -Q -A | gzip > my.sql.gz
     
    Shauni, Apr 6, 2010 IP
  3. kuzmanin

    kuzmanin Peon

    Messages:
    242
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    don't forget that if your database is big you will lock your website for the time when databse is backuped
     
    kuzmanin, Apr 7, 2010 IP