Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    57

    Unanswered: incremental or differential backup

    how to do incremental or differential backup for MySql database?
    we need save backup file in different server, is this possible to do?

  2. #2
    Join Date
    Dec 2005
    Location
    Tilburg, Netherlands
    Posts
    73
    ... mysql.com ???
    ... manual ???

    Good luck,
    Yveau

    > SELECT * FROM users WHERE clue > 0;
    Empty set (0.00 sec)


  3. #3
    Join Date
    Jul 2004
    Posts
    62
    Type of backups
    1. Incremental backup
    You need to start the server with the --log-bin option to enable binary logging. You may find all the SQL statements created during transaction in the logs files.
    2. Full backup
    you can use mysqldump

    For more info pls refer to http://dev.mysql.com/doc/refman/5.0/en/backup.html

Posting Permissions

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