1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Backup of Database

Discussion in 'MySQL' started by assh319, Nov 26, 2012.

  1. #1
    what is the method of Backup of Database?
     
    assh319, Nov 26, 2012 IP
  2. benjaminp

    benjaminp Notable Member

    Messages:
    1,212
    Likes Received:
    16
    Best Answers:
    2
    Trophy Points:
    230
    #2
    If you're using phpMyAdmin, you can just select your database and hit the export tab. Export the .sql file and save it to your HDD.
     
    benjaminp, Nov 26, 2012 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    It depends on your database size. Using phpMyAdmin is not feasible/possible with bigger databases. Use XtraBackup if you have a quite large database otherwise phpMyAdmin will work for you.
     
    mwasif, Jan 5, 2013 IP
  4. amrush

    amrush Active Member

    Messages:
    30
    Likes Received:
    2
    Best Answers:
    2
    Trophy Points:
    58
    #4
    you can use sqlyog front end tool for mysql backup. you can export backup in few format. It you want to take backup in .csv format than this tool is good. Easy to export and import. OR you can use mysqldump utility for backing up your database in .sql format.It is command based backup method. There are also several backup tool like mysq-zrm and the tool mentioned above as well as phpmyadmin.

    But it is totally depends on the size of your database(mentioned by awasif) and in which format you want to take backup.
     
    amrush, Jan 5, 2013 IP
  5. dark_zone

    dark_zone Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #5
    use percona xtrabackup...it is very useful tool....
     
    dark_zone, Jan 21, 2013 IP