Professional Web Applications Themes

Inoddb Database - table corrupt? - MySQL

hello im using a inoddb database, when i try to dump the database this error is the result -- mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `Attachments` at row: 166498 -- any ideas how i can fix it? i can edit and change the values in the row but it does not fix the failure....

  1. #1

    Default Inoddb Database - table corrupt?

    hello
    im using a inoddb database, when i try to dump the database this error is
    the result
    --
    mysqldump: Error 2013: Lost connection to MySQL server during query when
    dumping
    table `Attachments` at row: 166498
    --

    any ideas how i can fix it? i can edit and change the values in the row but
    it does not fix the failure.



    richard Guest

  2. #2

    Default Re: Inoddb Database - table corrupt?

    "richard" <com> wrote in
    news:b79fc$45f52e6d$506cda6b$chello.at:
     

    just a shot, but try increasing the max_packet_size in the configuration
    file
    Good Guest

  3. #3

    Default Re: Inoddb Database - table corrupt?

    hello
    thx for your answer, i set it to max_allowed_packet=300M but the same
    failure is coming again, is there a way to "check" how big the size should
    be?
     
    >
    > just a shot, but try increasing the max_packet_size in the configuration
    > file[/ref]


    richard Guest

  4. #4

    Default Re: Inoddb Database - table corrupt?

    "richard" <com> wrote in
    news:d543f$45f67061$506cda6b$chello.at:
     

    300M is more than enough, so that's not the problem. Google a bit about
    "losing MySQL connection" in the middle of a dump.... the error message
    says more about the server set-up than it does about the data being
    corrupted (so far there is no reason to think it is corrupt).

    Good Guest

  5. #5

    Default Re: Inoddb Database - table corrupt?

    "richard" <com> wrote:
     

    Error 2013 is a crashed MySQL server. Have a look at the mysqld error
    log for a hint what went wrong.


    XL
    --
    Axel Schwenke, Support Engineer, MySQL AB

    Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
    MySQL User Forums: http://forums.mysql.com/
    Axel Guest

Similar Threads

  1. Database corrupt, can we use the transaction log?
    By Rene in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: October 8th, 10:57 AM
  2. Corrupt Table Error Mx 6,1,0,83762
    By Gargamel in forum Coldfusion Server Administration
    Replies: 2
    Last Post: August 23rd, 05:35 PM
  3. Repeated Corrupt Tables and Table Crashes
    By Leonard Megliola in forum MySQL
    Replies: 0
    Last Post: March 23rd, 05:00 PM
  4. Using CSS header corrupt table height
    By AndrewJJ webforumsuser@macromedia.com in forum Macromedia Dynamic HTML
    Replies: 3
    Last Post: November 3rd, 11:21 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