게시판 복사 에러

게시판 복사 에러

QA

게시판 복사 에러

답변 2

본문

CREATE TABLE g4_write_online_back ( wr_id int(11) NOT NULL auto_increment, wr_num int(11) DEFAULT '0' NOT NULL, wr_reply varchar(10) NOT NULL, wr_parent int(11) DEFAULT '0' NOT NULL, wr_is_comment tinyint(4) DEFAULT '0' NOT NULL, wr_comment int(11) DEFAULT '0' NOT NULL, wr_comment_reply varchar(5) NOT NULL, ca_name varchar(255) NOT NULL, wr_option set('html1','html2','secret','mail') NOT NULL, wr_subject varchar(255) NOT NULL, wr_content text NOT NULL, wr_link1 text NOT NULL, wr_link2 text NOT NULL, wr_link1_hit int(11) DEFAULT '0' NOT NULL, wr_link2_hit int(11) DEFAULT '0' NOT NULL, wr_trackback varchar(255) NOT NULL, wr_hit int(11) DEFAULT '0' NOT NULL, wr_good int(11) DEFAULT '0' NOT NULL, wr_nogood int(11) DEFAULT '0' NOT NULL, mb_id varchar(255) NOT NULL, wr_password varchar(255) NOT NULL, wr_name varchar(255) NOT NULL, wr_email varchar(255) NOT NULL, wr_homepage varchar(255) NOT NULL, wr_datetime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, wr_last varchar(19) NOT NULL, wr_ip varchar(255) NOT NULL, wr_1 varchar(255) NOT NULL, wr_2 varchar(255) NOT NULL, wr_3 varchar(255) NOT NULL, wr_4 varchar(255) NOT NULL, wr_5 varchar(255) NOT NULL, wr_6 varchar(255) NOT NULL, wr_7 varchar(255) NOT NULL, wr_8 varchar(255) NOT NULL, wr_9 varchar(255) NOT NULL, wr_10 varchar(255) NOT NULL, PRIMARY KEY (wr_id), KEY wr_num_reply_parent (wr_num, wr_reply, wr_parent), KEY wr_is_comment (wr_is_comment, wr_id) ) DEFAULT CHARSET=utf8

1874 : InnoDB is in read only mode.

error file : /adm/board_copy_update.php

 

이렇게 뜹니다.

mysql 서버에서 무언가 바꿔줘야하나요?

같은 서버에 같은 mysql을 쓰고 있는데도 그누5 복사는 잘되는데 4는 안되네요..

 

 

이 질문에 댓글 쓰기 :

답변 2

my.cnf 에서

innodb_force_recovery = 1

 

이부분 확인해보셨나요?

답변을 작성하시기 전에 로그인 해주세요.
QA 내용 검색
질문등록
전체 1
© SIRSOFT
현재 페이지 제일 처음으로