读书人

linux上mysql自动备份shell脚本

发布时间: 2013-03-01 18:33:02 作者: rapoo

linux下mysql自动备份shell脚本

CREATE TABLE IF NOT EXISTS general_log (  event_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,  user_host mediumtext NOT NULL,  thread_id int(11) NOT NULL,  server_id int(10) unsigned NOT NULL,  command_type varchar(64) NOT NULL,  argument mediumtext NOT NULL) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='General log';CREATE TABLE IF NOT EXISTS slow_log (  start_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,  user_host mediumtext NOT NULL,  query_time time NOT NULL,  lock_time time NOT NULL,  rows_sent int(11) NOT NULL,  rows_examined int(11) NOT NULL,  db varchar(512) NOT NULL,  last_insert_id int(11) NOT NULL,  insert_id int(11) NOT NULL,  server_id int(10) unsigned NOT NULL,  sql_text mediumtext NOT NULL) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log';



读书人网 >UNIXLINUX

热点推荐