Results 1 to 4 of 4

Thread: Taking Backup of MySql automatically

  1. #1
    Join Date
    May 2008
    Posts
    35

    Taking Backup of MySql automatically

    Hi,

    I want to know how to take backup of MySQL database on a lo0cal machine & on the server automatically?

    If you guys know any application then please let me know about the same.

  2. #2
    Join Date
    Feb 2009
    Posts
    133

    Re: Taking Backup of MySql automatically

    I think you need to go through this tutorial by MySql
    http://dev.mysql.com/doc/refman/5.0/...-recovery.html

    I hope this helps.
    IF YOU CAN'T Convince THEM ...

    CONFUSE THEM ...

  3. #3
    Join Date
    Jan 2009
    Posts
    40

    Re: Taking Backup of MySql automatically

    A MySQL dump is a bit slower than a raw backup because it creates all the SQL queries required to create the tables of that database, as well as all the insert queries required to place the information back into the database's tables.

    If you want to perform the mysql dump manually, without the assistance of your hosts control panel, then run SSH to your web server and do the following (taken from MySql.com):

    * mysqldump --tab=/path/to/some/dir --opt db_name

  4. #4
    Join Date
    May 2008
    Posts
    35

    Re: Taking Backup of MySql automatically

    Is there any Software I mean application that will enable me to backup my SQL database periodically?
    I am on Mac environment. (Windows based GUI will also do.)

Similar Threads

  1. please help in taking backup from USB flash drive
    By sophisticated in forum Portable Devices
    Replies: 1
    Last Post: 02-04-2012, 05:50 PM
  2. Replies: 7
    Last Post: 27-10-2011, 02:10 PM
  3. 0X800423F0 error while taking system backup
    By Harnoor in forum Operating Systems
    Replies: 4
    Last Post: 04-12-2010, 10:22 PM
  4. Replies: 3
    Last Post: 07-11-2009, 08:36 PM
  5. Taking backup of D: Drive
    By Chandran12 in forum Operating Systems
    Replies: 2
    Last Post: 12-08-2008, 03:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •