iconv 설치 -
# http://www.gnu.org/software/libiconv/
최신 iconv를 다운로드 받은후 압축을 푼 후
./configure --prefix=/usr/local
make
make install
make
make install
iconv 설치 -
최신 iconv를 다운로드 받은후 압축을 푼 후
[root@local user] /usr/bin/mysqld_safe --user=mysql &
nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
081003 15:37:16 mysqld ended
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
081003 15:37:16 mysqld ended
yum을 이용해서 mysql 설치후 mysql 데몬이 실행되지 않을 경우
vi /etc/my.conf
에서 mysql의 에러가 어디에 남는지 확인 후 에러를 확인
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
090704 19:17:04 mysqld started
nohup: ignoring input
090704 19:17:04 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090704 19:17:04 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
090704 19:17:04 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
090704 19:17:04 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
InnoDB: Apply batch completed
090704 19:17:05 InnoDB: Started; log sequence number 0 43655
090704 19:17:05 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
090704 19:17:05 mysqld ended
/usr/bin/mysql_install_db --user=mysql
mysql_install_db ==> mysql 권한 테이블을 생성
위 명령어를 실행 후 mysql 데몬 실행을 다시 한다.
명령어 : uptime
$ uptime
10:52:55 up 210 days, 23:18, 1 user, load average: 0.99, 0.63, 0.46
현재시간 | 가동시간 | 접속유저 | load average : 1분, 5분, 15분 동안 발생한 로드의 평균
10:52:55 up 210 days, 23:18, 1 user, load average: 0.99, 0.63, 0.46
현재시간 | 가동시간 | 접속유저 | load average : 1분, 5분, 15분 동안 발생한 로드의 평균
