back log     50
basedir    /usr/local/
bdb cache size    8,388,600
bdb home    /var/db/mysql/
bdb log buffer size    131,072
bdb logdir    
bdb max lock    10,000
bdb shared data    OFF
bdb tmpdir    /var/tmp/
binlog cache size    32,768
bulk insert buffer size    8,388,608
character set client    utf8
(Глобальное значение)    latin1
character set connection    utf8
(Глобальное значение)    latin1
character set database    latin1
character set results    utf8
(Глобальное значение)    latin1
character set server    latin1
character set system    utf8
character sets dir    /usr/local/share/mysql/charsets/
collation connection    utf8_unicode_ci
(Глобальное значение)    latin1_swedish_ci
collation database    latin1_swedish_ci
collation server    latin1_swedish_ci
concurrent insert    ON
connect timeout    5
datadir    /var/db/mysql/
date format    %Y-%m-%d
datetime format    %Y-%m-%d %H:%i:%s
default week format    0
delay key write    ON
delayed insert limit    100
delayed insert timeout    300
delayed queue size    1,000
expire logs days    0
flush    OFF
flush time    86,400
ft boolean syntax    + -><()~*:""&|
ft max word len    84
ft min word len    4
ft query expansion limit    20
ft stopword file    (built-in)
group concat max len    1,024
have archive    NO
have bdb    YES
have blackhole engine    NO
have compress    YES
have crypt    YES
have csv    NO
have example engine    NO
have geometry    YES
have innodb    YES
have isam    NO
have merge engine    YES
have ndbcluster    NO
have openssl    NO
have query cache    YES
have raid    NO
have rtree keys    YES
have symlink    YES
init connect    
init file    
init slave    
innodb additional mem pool size    1,048,576
innodb autoextend increment    8
innodb buffer pool awe mem mb    0
innodb buffer pool size    8,388,608
innodb data file path    ibdata1:10M:autoextend
innodb data home dir    
innodb fast shutdown    ON
innodb file io threads    4
innodb file per table    OFF
innodb flush log at trx commit    1
innodb flush method    
innodb force recovery    0
innodb lock wait timeout    50
innodb locks unsafe for binlog    OFF
innodb log arch dir    
innodb log archive    OFF
innodb log buffer size    1,048,576
innodb log file size    5,242,880
innodb log files in group    2
innodb log group home dir    ./
innodb max dirty pages pct    90
innodb max purge lag    0
innodb mirrored log groups    1
innodb open files    300
innodb table locks    ON
innodb thread concurrency    8
interactive timeout    600
join buffer size    131,072
key buffer size    134,217,728
key cache age threshold    300
key cache block size    1,024
key cache division limit    100
language    /usr/local/share/mysql/english/
large files support    ON
lc time names    en_US
license    GPL
local infile    ON
locked in memory    OFF
log    OFF
log bin    OFF
log error    
log slave updates    OFF
log slow queries    OFF
log update    OFF
log warnings    1
long query time    10
low priority updates    OFF
lower case file system    OFF
lower case table names    0
max allowed packet    1,047,552
max binlog cache size    4,294,967,295
max binlog size    1,073,741,824
max connect errors    1,000
max connections    1,024
max delayed threads    20
max error count    64
max heap table size    16,777,216
max insert delayed threads    20
max join size    16,777,216
max length for sort data    1,024
max prepared stmt count    16,382
max relay log size    0
max seeks for key    4,294,967,295
max sort length    1,024
max tmp tables    32
max user connections    1,000
max write lock count    4,294,967,295
myisam data pointer size    4
myisam max extra sort file size    2,147,483,648
myisam max sort file size    2,147,483,647
myisam recover options    DEFAULT
myisam repair threads    1
myisam sort buffer size    16,777,216
myisam stats method    nulls_unequal
net buffer length    16,384
net read timeout    30
net retry count    1,000,000
net write timeout    60
new    OFF
old passwords    OFF
open files limit    11,095
pid file    /var/db/mysql/MC101196.pid
port    3,306
preload buffer size    32,768
prepared stmt count    0
protocol version    10
query alloc block size    8,192
query cache limit    1,048,576
query cache min res unit    4,096
query cache size    67,108,864
query cache type    ON
query cache wlock invalidate    OFF
query prealloc size    8,192
range alloc block size    2,048
read buffer size    1,044,480
read only    OFF
read rnd buffer size    262,144
relay log purge    ON
relay log space limit    0
rpl recovery rank    0
secure auth    OFF
server id    0
skip external locking    ON
skip networking    OFF
skip show database    OFF
slave net timeout    3,600
slave transaction retries    0
slow launch time    2
socket    /tmp/mysql.sock
sort buffer size    1,048,568
sql mode    
sql notes    ON
sql warnings    ON
storage engine    MyISAM
sync binlog    0
sync frm    ON
sync replication    0
sync replication slave id    0
sync replication timeout    0
system time zone    MSK
table cache    256
table type    MyISAM
thread cache size    8
thread stack    196,608
time format    %H:%i:%s
time zone    SYSTEM
tmp table size    33,554,432
tmpdir    
transaction alloc block size    8,192
transaction prealloc size    4,096
tx isolation    REPEATABLE-READ
version    4.1.22
version bdb    Sleepycat Software: Berkeley DB 4.1.24: (November 3, 2006)
version comment    FreeBSD port: mysql-server-4.1.22
version compile machine    i386
version compile os    portbld-freebsd5.2.1
wait timeout    300

INSERT table1 (f1,f2) SELECT f1,f2 FROM table2