May
17
以前一个表中的字段忘记记录了,想修复数据。可以用一个Sql文的Update来实现。
方法有两种:
update adv_dat set adv_type=adv_mst.adv_type, adv_target=adv_mst.adv_target
from adv_mst where adv_media_total_day_dat.adv_id=adv_mst.id;
另外一种就是用 left join来实现
方法有两种:
update adv_dat set adv_type=adv_mst.adv_type, adv_target=adv_mst.adv_target
from adv_mst where adv_media_total_day_dat.adv_id=adv_mst.id;
另外一种就是用 left join来实现
Mar
16
SVN坏了有段时间了。刚才整理了一些重要数据,到了不得不处理的时候了。
现象:
svn: Repository moved temporarily to...
解决方法:
要添加一个参数ErrorDocument 404 default ,具体如下:
DAV svn
SVNPath /var/svn/repository/
AuthzSVNAccessFile /var/svn/repository/conf/authz
AuthType Basic
AuthName "Subversion repository"
AuthUserFile /var/svn/repository/conf/passwd
Require valid-user
ErrorDocument 404 default
现象:
svn: Repository moved temporarily to...
解决方法:
要添加一个参数ErrorDocument 404 default ,具体如下:
DAV svn
SVNPath /var/svn/repository/
AuthzSVNAccessFile /var/svn/repository/conf/authz
AuthType Basic
AuthName "Subversion repository"
AuthUserFile /var/svn/repository/conf/passwd
Require valid-user
ErrorDocument 404 default
Mar
12
有VPS商将一块用来存放用户数据(即网站数据等),一块用来存放系统,这样在您的系统出现问题之后后台选择重装系统,另外一个磁盘分区的数据就不会丢失了,所以在购买VPS之后,要手动将另外一块硬盘挂载到用户数据的目录。
挂载方法:
[root@MyVPS ~]# fdisk -l (查看磁盘分区)
Disk /dev/xvdb: 7516 MB, 7516192768 bytes
255 heads, 63 sectors/track, 913 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk /dev/xvdb doesn't contain a valid partition table
Disk /dev/xvda: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/xvda1 * 1 13 104391 83 Linux
/dev/xvda2 14 1044 8281507+ 8e Linux LVM
/dev/xvda3 1045 1305 2096482+ 8e Linux LVM
[root@MyVPS ~]# df -hal //*查看已划分区空间使用情况*//
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
9.3G 1.2G 7.7G 13% /
proc 0 0 0 - /proc
sysfs 0 0 0 - /sys
devpts 0 0 0 - /dev/pts
/dev/xvda1 99M 29M 66M 31% /boot
tmpfs 151M 0 151M 0% /dev/shm
none 0 0 0 - /proc/sys/fs/binfmt_misc
sunrpc 0 0 0 - /var/lib/nfs/rpc_pipefs
[root@MyVPS ~]# fdisk /dev/xvdb //*对硬盘/dev/xvdb进行增加分区操作*//
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.
挂载方法:
[root@MyVPS ~]# fdisk -l (查看磁盘分区)
Disk /dev/xvdb: 7516 MB, 7516192768 bytes
255 heads, 63 sectors/track, 913 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk /dev/xvdb doesn't contain a valid partition table
Disk /dev/xvda: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/xvda1 * 1 13 104391 83 Linux
/dev/xvda2 14 1044 8281507+ 8e Linux LVM
/dev/xvda3 1045 1305 2096482+ 8e Linux LVM
[root@MyVPS ~]# df -hal //*查看已划分区空间使用情况*//
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
9.3G 1.2G 7.7G 13% /
proc 0 0 0 - /proc
sysfs 0 0 0 - /sys
devpts 0 0 0 - /dev/pts
/dev/xvda1 99M 29M 66M 31% /boot
tmpfs 151M 0 151M 0% /dev/shm
none 0 0 0 - /proc/sys/fs/binfmt_misc
sunrpc 0 0 0 - /var/lib/nfs/rpc_pipefs
[root@MyVPS ~]# fdisk /dev/xvdb //*对硬盘/dev/xvdb进行增加分区操作*//
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.
Mar
10
今天在CentOS 6 32bit放了个gb2312 的代码,但不管怎么声明强制,总是乱码……
最后觉得应该是系统问题!
# vi httpd.conf
#AddDefaultCharset UTF-8
AddDefaultCharset off
网上有说:
AddDefaultCharset UTF-8 GB2312 .ZH-CN .zh-cn 可以支持多语言编码,但这样Apache启动不了!
最后觉得应该是系统问题!
# vi httpd.conf
#AddDefaultCharset UTF-8
AddDefaultCharset off
网上有说:
AddDefaultCharset UTF-8 GB2312 .ZH-CN .zh-cn 可以支持多语言编码,但这样Apache启动不了!
Mar
8






