Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    30

    Question Unanswered: backup without using mysqldump

    i was told that it takes days if i need to backup a databases with large tables using mysqldump

    what other ways i can backup the whole database and recover it in short time?

    i heard about myisampack but not too sure about it..
    still new to database & mysql..

  2. #2
    Join Date
    Feb 2005
    Location
    Germany
    Posts
    22
    hi,
    it depend on how busy the db is. I make backups as follow:

    1. lock table
    2. make a os file copy to an other disk
    3. unlock table

    This is suitable for us , because each table copy takes less than a few minutes.

    A better approach would be:
    setup an mysql slave on an other machine an configure a replication between you actual system and that slave.
    1. shutdown the slave
    2. make offline backup of slave
    3. restart slave
    4. watch replication (should start automatically)

    Greetings, Martin

  3. #3
    Join Date
    Jul 2004
    Posts
    30
    hi msueper,
    what do you mean by
    2. make a os file copy to an other disk?

    i've thought us copying all the FRM, MYD, MYI files to another database data directory in another server

    couldnt find any good site explaning ways of doing it
    what should i do after copying?

    any advice?

    thanks

    Quote Originally Posted by msueper
    hi,
    it depend on how busy the db is. I make backups as follow:

    1. lock table
    2. make a os file copy to an other disk
    3. unlock table

    This is suitable for us , because each table copy takes less than a few minutes.

    A better approach would be:
    setup an mysql slave on an other machine an configure a replication between you actual system and that slave.
    1. shutdown the slave
    2. make offline backup of slave
    3. restart slave
    4. watch replication (should start automatically)

    Greetings, Martin

Posting Permissions

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