Professional Web Applications Themes

Backup a part of a table - MySQL

Hello, what is the recommendet way to backup only the rows of a single table that have i.e. a timestamp older than 5 months? Thanks! Regards, Martin O....

  1. #1

    Default Backup a part of a table

    Hello,

    what is the recommendet way to backup only the rows of a single table
    that have i.e. a timestamp older than 5 months?

    Thanks!

    Regards,

    Martin O.

    mo@ekontrol.com Guest

  2. #2

    Default Re: Backup a part of a table

    [email]moekontrol.com[/email] wrote:
    > what is the recommendet way to backup only the rows of a single table
    > that have i.e. a timestamp older than 5 months?
    mysqldump [options] --where="timestampcolumn < CURDATE() - INTERVAL 5
    MONTH" databasename tablename

    Regards,
    Bill K.
    Bill Karwin Guest

  3. #3

    Default Re: Backup a part of a table

    Thank you all for the answears. I will try with mysqldump ...
    --where...

    Regards,

    Martin

    mo@ekontrol.com Guest

Similar Threads

  1. Replies: 0
    Last Post: August 24th, 10:13 AM
  2. Replies: 0
    Last Post: September 10th, 05:29 PM
  3. Replies: 2
    Last Post: August 12th, 07:55 AM
  4. Replies: 2
    Last Post: July 17th, 11:59 PM
  5. loop - begin backup, end backup Oracle 8.1.7
    By Matthias Arth in forum Oracle Server
    Replies: 1
    Last Post: December 27th, 08:53 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139