
[mysqld]=\windows\my.ini; [client]=\user..\my.ini
/etc/my.cnf

[client]
default-character-set = utf8
init_connect = 'SET NAMES utf8'

[mysqld]
#==== server ====
default-character-set = utf8
set-variable = key_buffer=8M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache_size=8
set-variable = thread_concurrency=8
set-variable = lower_case_table_names=1  (Unix=0  Windows=2 ɷ|jpg; =1ɳ,showtableWOpg)
#bind-address = localhost 127.0.0.1

#==== InnoDB ====
#set-variable = innodb_data_file_path = ibdata1:20M
set-variable = innodb_log_buffer_size=2M
set-variable = innodb_buffer_pool_size=32M
set-variable = innodb_additional_mem_pool_size=8M

#========================================
#1G
max_connections = 500
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M
#---Try number of CPU's*2 for thread_concurrency----
#thread_concurrency = 8
#---INNODB----
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
#innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50





#========================================
mysqldump -uroot -p123456 --opt e3010001 > c:\data\e3010001.bp
mysql -uroot -p123456 e3010001 < c:\data\e3010001.bp


#========================================
-------bp.bat-------
c:\mysql\bin\mysqldump -uroot -pnasar --opt e3010001 %1 > c:\data\%1.txt
pause

-------1.bat-------
echo off
for /R "c:\mysql\data\e3010001" %%i in (*.frm) do echo call bp %%~ni >> backup.bat





#========================================
select @xcount := count(*) from stk;
update bjn_tableState set count=@xcount, last=UNIX_TIMESTAMP() where id='stk';



#========================================
tomcat5.5> jsp for Vector, edit web.xml <org.apache.jasper.servlet.JspServlet>
         <init-param>
             <param-name>compilerSourceVM</param-name>
             <param-value>1.5</param-value>
         </init-param>
         <init-param>
             <param-name>compilerTargetVM</param-name>
             <param-value>1.5</param-value>
         </init-param>

#========================================
tomcat5.5> download file lost, edit web.xml <org.apache.catalina.servlets.DefaultServlet>
        <init-param>
	    <!-- close sendfile -->
            <param-name>sendfileSize</param-name>
            <param-value>-1</param-value>
        </init-param> 

#========================================
   4.0 backup ----> 5.0 mysql
(1). edit 3010001.sql add, "SET NAMES utf8"
(2). my.ini add, "default-character-set = utf8"


#========================================
--skip-grant-table
use mysql;
update user set password=PASSWORD('123456') where user='root';
flush privileges;


#========================================
#shO@mysqldumpƥ
mkdir dasamx_data
vi e3backup.sh
chmod u+x e3backup.sh

#!/bin/sh
cd /dasamx_data
SQL_FILE=`date +%Y_%m_%d.sql`
echo ">>>>mysqldump to $SQL_FILE ............"
/usr/bin/mysqldump -uroot -p551231 --opt e3010001 > $SQL_FILE
rm $SQL_FILE.gz
gzip -v $SQL_FILE



