[mysqld] language=/usr/share/mysql/japanese default-character-set=sjis character-set-server = utf8
[mysqld] datadir = /var/lib/mysql
mysql --user=hoge -p -S /var/lib/mysql/mysql.sock
[Service] ProtectHome=false
binlog_format=mixed
# mysql mysqld : 172.16.0.0/255.255.0.0 mysqld : 202.171.139.208/255.255.255.248
[mysqld] log-bin expire_logs_days=14 server-id=1
+-------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +-------------------+----------+--------------+------------------+ | mysqld-bin.000001 | 70214 | | | +-------------------+----------+--------------+------------------+ 1 row in set (0.00 sec)
[mysqld] server-id=2 expire_logs_days=14 read_only
$cfg['blowfish_secret'] = 'NANIKA NAGAI TEKITOUNA MOJIWO IRERU'
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.8.5/i386-linux-thread-multi /usr/lib/perl5/5.8.5 /usr/lib/perl5 /site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5 /usr/lib /perl5/site_perl .) at (eval 2) line 3. Perhaps the DBD::mysql perl module hasn't been fully installed, or perhaps the capitalisation of 'mysql' isn't right. Available drivers: DBM, ExampleP, File, Pg, Proxy, Sponge. at (スクリプトパス) line 17
# 接続 # DBI:DBMS名(MySQL,Oracle...):データベース名:ホスト名:ポート名 $dsn = "DBI:$DBI_dbtype:$DBI_dbname:$DBI_sqlname:$DBI_sqlport"; #$dsn = 'DBI:mysql:iptag:mysql.jamfunk.jp:3306'; $dbh = DBI->connect($dsn, $DBI_user, $DBI_password); if(!$dbh) { &error("CANNOT CONNECT DB server"); } # SQL投げ # 文字列クォート $strsql = $dbh->quote($strsql); # SQL文 $strsql = "select * from tbl_ipseg where ip_seg rlike '192.168.';"; # SQL文実行 $sth = $dbh->prepare($strsql); $sth->execute; # カラム数取得 $fcnt = $sth->{NUM_OF_FIELDS}; # カラム名への配列リファレンス $ref_field_name = $sth->{NAME}; # 返ってきた結果をHTMLで出力 # カラム名表示 print "<TABLE><TBODY>\n<TR>\n"; for($i = 0; $i < $fcnt; $i++) { print "<TH>$$ref_field_name[$i]</TH>"; } print "\n</TR>\n"; # データ表示 while(@rows = $sth->fetchrow_array) { print "<TR>\n"; foreach(@rows) { print "<TD>$_</TD>"; } print "</TR>\n"; } print "</TBODY></TABLE>\n";
mysql_upgrade -f -p
set global innodb_file_per_table=1;
set global innodb_file_format=Barracuda;
+------------------+-----------+ | Log_name | File_size | +------------------+-----------+ | mysql-bin.000023 | 715932752 | | mysql-bin.000024 | 15548 | +------------------+-----------+ 2 rows in set (0.00 sec)
expire_logs_days=30