2012년 5월 18일 금요일

Mysql error "InnoDB: Unable to lock ./ibdata1, error: 11"

find / -name ibdata1해봐서 원본파일 찾은다음 복사해준다

mv ibdata1 ibdata1.bak
cp -a ibdata1.bak ibdata1

출처: http://cglreport.zhenhua.info/2008/08/mysql-error-unable-to-lock-ibdata1.html

 

mv /var/lib/mysql/ibdata1 /var/lib/mysql/ibdata1.bak
cp -a /var/lib/mysql/ibdata1.bak /var/lib/mysql/ibdata1

출처: http://help-php.com/mysql-error-innodb/

sudo /etc/init.d/mysql stop

sudo apt-get purge mysql*

2012년 5월 13일 일요일

열려있는 포트 확인

#netstat -na | grep LISTEN

tcp        0      0 127.0.0.1:53            0.0.0.0:*               LISTEN    
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN    
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN    
tcp6       0      0 :::80                   :::*                    LISTEN    
tcp6       0      0 ::1:631                 :::*                    LISTEN    
unix  2      [ ACC ]     STREAM     LISTENING     8421     /tmp/.X11-unix/X0
unix  2      [ ACC ]     STREAM     LISTENING     8196     /var/run/cups/cups.sock
unix  2      [ ACC ]     STREAM     LISTENING     13368    /tmp/ssh-sLojxCbr2290/agent.2290
unix  2      [ ACC ]     STREAM     LISTENING     12393    /tmp/keyring-uJCsHZ/control
unix  2      [ ACC ]     STREAM     LISTENING     12394    /tmp/keyring-uJCsHZ/ssh
unix  2      [ ACC ]     STREAM     LISTENING     13419    /tmp/.menu-cached-:0-jin
unix  2      [ ACC ]     STREAM     LISTENING     12505    /tmp/.pcmanfm-socket--0-jin
unix  2      [ ACC ]     STREAM     LISTENING     12991    /home/jin/.pulse/d353481a31e38a8575d3e37b00000006-runtime/native
unix  2      [ ACC ]     STREAM     LISTENING     293091   /tmp/.lxterminal-socket:0.0-jin
unix  2      [ ACC ]     STREAM     LISTENING     12381    @/tmp/dbus-IDhaHEUXgF
unix  2      [ ACC ]     STREAM     LISTENING     6612     @/com/ubuntu/upstart
unix  2      [ ACC ]     STREAM     LISTENING     7830     @/org/bluez/audio
unix  2      [ ACC ]     STREAM     LISTENING     8420     @/tmp/.X11-unix/X0
unix  2      [ ACC ]     SEQPACKET  LISTENING     6761     /run/udev/control
unix  2      [ ACC ]     STREAM     LISTENING     7817     /var/run/sdp
unix  2      [ ACC ]     STREAM     LISTENING     7049     /var/run/dbus/system_bus_socket
unix  2      [ ACC ]     STREAM     LISTENING     9114     /var/run/mysqld/mysqld.sock
unix  2      [ ACC ]     STREAM     LISTENING     7128     /var/run/avahi-daemon/socket