WordPress数据库错误: [Got error 28 from storage engine]
SHOW FULL COLUMNS FROM `wp_options`

WordPress数据库错误: [Got error 28 from storage engine]
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (57) ORDER BY t.name ASC

JSP 环境搭置(for Linux) – Crazy knowledge base
Crazy knowledge base

JSP 环境搭置(for Linux)

一、软件准备
java运行环境jdk1.6:jdk-6u4-linux-i586-rpm.bin
jsp服务器tomcat6.0:apache-tomcat-6.0.14.tar.gz
mysql数据库服务器:mysql-5.1.14-beta-linux-i686-glibc23.tar.gz
jsp中必须的mysql驱动:mysql-connector-java-5.1.6.tar.gz
以上软件在sun,mysql,apache的官方网站上都可以找到的。

二、jdk的安装与配置
shell> chmod +x jdk-6u4-linux-i586-rpm.bin
shell> ./jdk-6u4-linux-i586-rpm.bin
会有提示,一步一步来做就行了,最后的安装目录是/usr/java/jdk1.6.0_04

因为系统中集成了gcj,所以我们要用jdk代替gcj,如下:
shell> cd /usr/bin #进入/usr/bin创建快捷命令
shell> ln -sf /usr/java/jdk1.6.0_04/jre/bin/java
shell> ln -sf /usr/java/jdk1.6.0_04/bin/javac
#在/usr/bin中创建java和javac的链接
#f参数表示覆盖原来的,因为原来的java是gcj
在配置文件(/etc/profile)添加如下几行

JAVA_HOME=/usr/java/jdk1.6.0_10
PATH=$PATH:$JAVA_HOME/bin
CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/htmlconverter.jar:$JAVA_HOME/jre/lib:/usr/java/apache-tomcat-6.0.18/lib/servlet-api.jar
CATALINA_HOME=/usr/java/apache-tomcat-6.0.18
export JAVA_HOME PATH CLASSPATH CATALINA_HOM
CATALINA_HOME是tomcat的路径,见下一步安装步骤和路径
#这里将tomcat中的servlet-api.jar添加到CLASSPATH中了
#因为jsp要使用到servlet技术,所以必须要把tomcat中的servlet-api.jar包添加到CLASSPATH中去

使配置文件立即生效:shell> source /etc/profile
在命令行里输入java -version,得到版本型号即表示安装成功。

三、tomcat6.0的安装与配置
shell> tar -xzvf apache-tomcat-6.0.14.tar.gz
shell> mv apache-tomcat-6.0.14 /usr/java/ #方便使用,当然你可以不移动
解压即可,然后将解压的文件apache-tomcat-6.0.14移动到的/usr/java/中
进入到文件apache-tomcat-6.0.14/bin,执
shell> ./startup.sh #即可可以启动服务器了
打开firefox,输入http://localhost:8080看到小猫的LOGO就表示启动成功

在/etc/rc.d/rc.local中添加(开机自动启动tomcat服务器):
export JAVA_HOME=/usr/java/jdk1.6.0_04
/usr/java/apache-tomcat-6.0.14

四、mysql的安装与配置

# groupadd mysql
# useradd -g mysql mysql
# wget http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-4.1.11.tar.gz/from/http://mysql.new21.com/
# tar -zxvf mysql-4.1.11.tar.gz
# cd mysql-4.1.11
# ./configure –prefix=/usr/local/mysql –with-charset=gbk
# make
# make install
# cp support-files/my-medium.cnf /etc/my.cnf
设置自启动
# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# chmod 700 /etc/rc.d/init.d/mysqld
# chkconfig –add mysqld
安装完以后要初始化数据库,要是升级安装的请跳过
# cd /usr/local/mysql
# /usr/local/mysql/bin/mysql_install_db –user=mysql
# chown -R root .
# chown -R mysql var
# chgrp -R mysql .
# /usr/local/mysql/bin/mysqld_safe –user=mysql &
好了,至此mysql安装完毕,你可以这样起动你的mysql服务
# /etc/rc.d/init.d/mysqld start
# ln -s /usr/local/mysql/bin/mysql /sbin/mysql
# ln -s /usr/local/mysql/bin/mysqladmin /sbin/mysqladmin
为了能让系统找到mysql,请运行如下命令
# PATH=$PATH:/usr/local/mysql/bin
# export PATH
# echo “/usr/local/mysql/lib/mysql” >;>; /etc/ld.so.conf
# ldconfig
日志管理
开启错误日志 (在[safe_mysqld]项下添加)
# vi /etc/my.cnf
[safe_mysqld]
err-log=/var/log/mysqld/err.log
开启常规日志和更新日志 (在[mysqld]项下添加)
# vi /etc/my.cnf
[mysqld]
log=/var/log/mysqld/log.log
log-update=/var/log/mysqld/update.log
创建日志文件并设置权限
# mkdir /var/log/mysqld
# touch /var/log/mysqld/err.log /var/log/mysqld/log.log /var/log/mysqld/update.log
# chown -R mysql.mysql /var/log/mysqld
# service mysqld restart
说明:
错误日志包含了服务器写入标准错误输出设备的所有消息,同时还包括了mysql服务的启动和关闭事件
常规日志用来记录有关mysql服务器运行的常规信息,包括用户的连接、查询及其他各种时间
更新日志用来记录修改数据库的查询信息,包括所有涉及数据库修改的SQl语句的查询记录
建议调试结束后关闭日志

 

JSP 环境搭置(for Linux)

WordPress数据库错误: [Got error 28 from storage engine]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (54) ORDER BY t.name ASC

WordPress数据库错误: [Got error 28 from storage engine]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (58) ORDER BY t.name ASC

滚动到顶部