정보기술/일반399 mysql 손상된 table 복구 net stop mysql 데몬 중지 후 myisamchk --extend-check table_name myisamchk --safe-recover table_name ./mysql/bin/myisamchk --safe-recover ../data/XXXXXXXXX.MYI net start mysql http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=97333&sca=&sfl=wr_subject%7C%7Cwr_content&stx=sql+can%5C%27t+open&sop=and 2006. 4. 29. MySQL 4.0 - > 5.0 업그레이드시 고려할 사항 구버전 mysql 4.0 에서 dump .\mysql\bin>mysqldump --opt -u root --password="암호" --default-character-set=euc_kr DB이름 > blog.sql 신버전 mysql 5.0 에서 restore .\MySQL\MySQL Server 5.0\bin>mysql -u root --password="암호" --default-character-set=euckr DB이름 old_password().. 2006. 4. 19. phpMyAdmin 설정 주의 사항 http://www.phpmyadmin.net/documentation/#quick_install If you don't like setup or want to fine tune resulting configuration, open (or create in case of starting from scratch) config.inc.php in your favorite editor and fill in there values for host, user, password and authentication mode to fit your environment. Look at libraries/config.default.php how these fields should be defined. 1. ./librari.. 2006. 4. 5. PHP 5+ 에 MySQL Extension 설치시 주의 사항 http://kr2.php.net/manual/en/ref.mysql.php PHP 5+ MySQL is no longer enabled by default, so the php_mysql.dll DLL must be enabled inside of php.ini. Also, PHP needs access to the MySQL client library. A file named libmysql.dll is included in the Windows PHP distribution and in order for PHP to talk to MySQL this file needs to be available to the Windows systems PATH. See the FAQ titled "How do I.. 2006. 4. 5. 이전 1 ··· 51 52 53 54 55 56 57 ··· 100 다음