Professional Web Applications Themes

recovering frome a server crash - MySQL

Removed by Administrator...

Sponsored Links
  1. Moderated Post

    Default recovering frome a server crash

    Removed by Administrator
    Sponsored Links
    pdc124@yahoo.co.uk Guest
    Moderated Post

  2. #2

    Default Re: recovering frome a server crash

    "co.uk" <co.uk> wrote: 

    Sure. A MyISAM table is 3 files on disk: $TABLENAME.{frm,MYD,MYI}.
    Those files must be owned and writable by the user that mysqld is
    running as (usually: mysql).


    XL
    --
    Axel Schwenke, Senior Software Developer, MySQL AB

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

  3. #3

    Default Re: recovering frome a server crash



    nervada OR2 # ls -la |grep trach
    -rw-r--r-- 1 mysql mysql 1265 Aug 21 09:48 trachy.MYD
    -rw-r--r-- 1 mysql mysql 2048 Aug 21 23:30 trachy.MYI
    -rw-r--r-- 1 mysql mysql 8620 Aug 6 2005 trachy.frm
    nervada OR2 #
    same problem when i try and repair the table

    pdc124@yahoo.co.uk Guest

  4. #4

    Default Re: recovering frome a server crash

    >> Sure. A MyISAM table is 3 files on disk: $TABLENAME.{frm,MYD,MYI}. 
    >
    > nervada OR2 # ls -la |grep trach
    > -rw-r--r-- 1 mysql mysql 1265 Aug 21 09:48 trachy.MYD
    > -rw-r--r-- 1 mysql mysql 2048 Aug 21 23:30 trachy.MYI
    > -rw-r--r-- 1 mysql mysql 8620 Aug 6 2005 trachy.frm
    > nervada OR2 #
    > same problem when i try and repair the table[/ref]

    What's the output of the ls -ld of the upper directory ( ls -ld
    .../<up_dir> )


    Regards
    Dimitre


    Radoulov, Guest

  5. #5

    Default Re: recovering frome a server crash

    nervada mysql # ls -la
    total 26052
    drwxr-x--- 7 mysql mysql 608 Nov 2 12:41 .
    OR2 and ccmds are the 2 DBs ive copied in ( this is an old machine that
    has been resurrected for an emergency

    drwxr-xr-x 20 root root 496 Nov 1 15:05 ..
    -rw-r--r-- 1 mysql mysql 0 Oct 31 19:22 .keep
    drwxr-xr-x 2 mysql mysql 5832 Nov 1 13:28 OR2
    drwxr-xr-x 2 root root 5832 Nov 2 10:21 OR2-backup
    drwxr-xr-x 2 root root 1440 Nov 1 13:27 ccmds
    -rw-rw---- 1 mysql mysql 5242880 Nov 2 12:41 ib_logfile0
    -rw-rw---- 1 mysql mysql 5242880 Nov 1 12:36 ib_logfile1
    -rw-rw---- 1 mysql mysql 10485760 Nov 2 12:41 ibdata1
    drwx------ 2 mysql mysql 1584 Nov 1 12:34 mysql
    -rw-rw---- 1 mysql mysql 10063 Nov 1 12:34 nervada-bin.000001
    -rw-rw---- 1 mysql mysql 376852 Nov 1 12:34 nervada-bin.000002
    -rw-rw---- 1 mysql mysql 5249529 Nov 1 12:34 nervada-bin.000003
    -rw-rw---- 1 mysql mysql 79 Nov 1 12:36 nervada-bin.000004
    -rw-rw---- 1 mysql mysql 79 Nov 2 10:28 nervada-bin.000005
    -rw-rw---- 1 mysql mysql 998 Nov 2 12:40 nervada-bin.000006
    -rw-rw---- 1 mysql mysql 953 Nov 2 15:43 nervada-bin.000007
    -rw-rw---- 1 mysql mysql 147 Nov 2 12:41 nervada-bin.index
    drwx------ 2 mysql mysql 48 Nov 1 12:34 test
    nervada mysql # ls -ld
    drwxr-x--- 7 mysql mysql 608 Nov 2 12:41 .
    nervada mysql #

    pdc124@yahoo.co.uk Guest

  6. #6

    Default Re: recovering frome a server crash

    "co.uk" <co.uk> wrote:
     
    >
    > nervada OR2 # ls -la |grep trach
    > -rw-r--r-- 1 mysql mysql 1265 Aug 21 09:48 trachy.MYD
    > -rw-r--r-- 1 mysql mysql 2048 Aug 21 23:30 trachy.MYI
    > -rw-r--r-- 1 mysql mysql 8620 Aug 6 2005 trachy.frm
    > nervada OR2 #
    > same problem when i try and repair the table[/ref]

    Hmm. Strange.

    How about the directory where those files live? Normal REPAIR
    (that is: not using the QUICK option) creates a temporary file.

    How about other processes? Another mysqld or myisamchk running?


    XL
    --
    Axel Schwenke, Senior Software Developer, MySQL AB

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

  7. #7

    Default Re: recovering frome a server crash

     

    The upper ( .. ) and ccmds are root:root:
     

    Try to change the owner, for example, if it's /var/lib/mysql:

    chown -R mysql:mysql /var/lib/mysql


    Regards
    Dimitre





    Radoulov, Guest

  8. #8

    Default Re: recovering frome a server crash

     
    >
    > Try to change the owner, for example, if it's /var/lib/mysql:
    >
    > chown -R mysql:mysql /var/lib/mysql[/ref]

    .... and restart mysql.


    Dimitre


    Radoulov, Guest

  9. #9

    Default Re: recovering frome a server crash

    ive changed the permissions of /var/lib/mysql .Same thing
    nervada lib # ls -la |grep my
    drwxr-x--- 7 mysql mysql 608 Nov 2 12:41 mysql
    nervada lib # ps -A |grep my
    30713 ? 00:00:00 mysqld
    nervada lib #

    pdc124@yahoo.co.uk Guest

  10. #10

    Default Re: recovering frome a server crash

    and fixed once mysql was restarted
    thanks for the help

    pdc124@yahoo.co.uk Guest

Similar Threads

  1. Crash FMS server
    By GGcc in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: February 4th, 06:47 PM
  2. Server crash
    By Nebu23 in forum Macromedia Flash Flashcom
    Replies: 9
    Last Post: September 18th, 10:46 PM
  3. InDesign CS CE non-stop CRASH, CRASH, CRASH, CRASH, CRASH, CRASH
    By kajzica@adobeforums.com in forum Adobe Indesign Windows
    Replies: 15
    Last Post: July 2nd, 07:57 PM
  4. Replies: 0
    Last Post: July 22nd, 08:03 PM
  5. recovering configuration after crash
    By Gary White in forum Macromedia Dreamweaver
    Replies: 2
    Last Post: July 20th, 11:25 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