Backup of mysql database

Discussion in 'MySQL' started by buzzgal, Feb 1, 2010.

0
  1. #1
    I am using mysql on local machine and not on server. I want to know can I take backup of database with data ?
     
    buzzgal, Feb 1, 2010 IP
  2. RHS-Chris

    RHS-Chris Well-Known Member

    Messages:
    1,007
    Likes Received:
    35
    Best Answers:
    10
    Trophy Points:
    150
    #2
    What OS are you running it on, windows, linux..? You can use a gui tool, like PhpMyAdmin to export your database(s), you just need to install it, that differs though on the OS you are using.
     
    RHS-Chris, Feb 1, 2010 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    You can choose a MySQL GUI tool to export your database as RHS-Chris suggested or use command line utility mysqldump. The syntax to export your DB with mysqldump will be (run this on command line)
    mysqldump database_name > path_to_file/backup.sql
    Code (markup):
     
    mwasif, Feb 2, 2010 IP