Professional Web Applications Themes

Problem with back-up/recover - MySQL

I'd like to know if MySQL performs a table integrity check based on storage file date... Yesterday I copied an entire database directory and when I finished I got a 127 error. I tried also to recover previously backed-up files but the fatal error continued to appear... Is there a solution, or I have to set mysql (and its databases) again ? Thank you ! -- Giuseppe Bonaccorso WWW: http://www.giuseppebonaccorso.it NewsID: it...

  1. #1

    Default Problem with back-up/recover

    I'd like to know if MySQL performs a table integrity check
    based on storage file date... Yesterday I copied an entire
    database directory and when I finished I got a 127 error. I
    tried also to recover previously backed-up files but the fatal
    error continued to appear... Is there a solution, or I have
    to set mysql (and its databases) again ?
    Thank you !

    --
    Giuseppe Bonaccorso

    WWW: http://www.giuseppebonaccorso.it
    NewsID: it
    Giuseppe Guest

  2. #2

    Default Re: Problem with back-up/recover

    Giuseppe Bonaccorso wrote: 

    You can't just copy a directory (or files) unless MySQL is completely
    shut down. Even then you must ensure you have *everything* - for
    instance MySQL also keeps information on available databases in its own
    tables.

    And no, I don't believe the integrity check is based on the file date.
    That would be very unreliable. Rather I believe it's based on
    information kept internal to the files.

    If you don't have a good backup of the entire system, chances are you're
    going to have to set up MySQL again.

    And next time I'd suggest you use mysqldump to dump your database. It
    ensures a good copy.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

Similar Threads

  1. Browser Back button problem
    By GMK in forum ASP.NET Security
    Replies: 6
    Last Post: April 25th, 01:42 PM
  2. History.back...problem
    By Bob Bedford in forum PHP Development
    Replies: 2
    Last Post: December 12th, 09:26 AM
  3. ASP and Back Button problem.
    By GW in forum Web Design
    Replies: 1
    Last Post: November 6th, 06:41 PM
  4. back button problem
    By Hypo in forum ASP.NET General
    Replies: 3
    Last Post: July 24th, 09:19 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