Thank you for your quick reply Adam. I add mysql.log as attachment
hoping doing so is OK here.
tail is :
6 Query show table status from `mythconverg`
like "videotypes"
6 Query show table status from `mythconverg`
like "websites"
6 Query /*!40101 SET
@OLD_SQL_MODE=@@SQL_MODE, sql_mode='' */
6 Query use mysql
6 Init DB Access denied for user
'mythtv'@'192.168.178.%' to database 'mysql'
This looks strange to me. Is there a difference in behaviour between
mysql-admin 1.2.5rc-1 and 1.1.10-1 ?
The packages contain no readme files at all which could give a hint in
such case.
(BTW mysql.err is still empty and nothing special in syslog)
Adam Majer schrieb:
Enable logging on mysql-server, restart the service. Then start
mysql-admin's backup. Once you get an error, disable logging on
mysql-server and restart the service. Then look at the logged queries or
send them my way.
It will be in the configuration file somewhere like,
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log = /var/log/mysql.log
#log = /var/log/mysql/mysql.log
uncomment it to activate. Not sure, but mysql-admin probably has the
option if you run it on the same host as the server.
- Adam
/usr/sbin/mysqld, Version: 5.0.22-Debian_0ubuntu6.06.3-log. started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
070322 21:11:24 1 Connect [EMAIL PROTECTED] on
1 Quit
2 Connect [EMAIL PROTECTED] on
2 Quit
3 Connect [EMAIL PROTECTED] on
3 Query show /*!40003 GLOBAL */ variables
3 Quit
070322 21:11:25 4 Connect [EMAIL PROTECTED] on mysql
4 Query set storage_engine=MyISAM
4 Query CREATE TABLE IF NOT EXISTS func (
name char(64) binary DEFAULT '' NOT NULL,
ret tinyint(1) DEFAULT '0' NOT NULL,
dl char(128) DEFAULT '' NOT NULL,
type enum ('function','aggregate') COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (name)
) CHARACTER SET utf8 COLLATE utf8_bin
4 Query ALTER TABLE user add File_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL
4 Query SET @hadGrantPriv:=0
4 Query SELECT @hadGrantPriv:=1 FROM user WHERE Grant_priv LIKE '%'
4 Query ALTER TABLE user add Grant_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add References_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Index_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Alter_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL
4 Query ALTER TABLE host add Grant_priv enum('N','Y') NOT NULL,add References_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Index_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Alter_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL
4 Query ALTER TABLE db add Grant_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add References_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Index_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Alter_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL
4 Query UPDATE user SET Grant_priv=File_priv,References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv WHERE @hadGrantPriv = 0
4 Query UPDATE db SET References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv WHERE @hadGrantPriv = 0
4 Query UPDATE host SET References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv WHERE @hadGrantPriv = 0
4 Query ALTER TABLE user
ADD ssl_type enum('','ANY','X509', 'SPECIFIED') COLLATE utf8_general_ci NOT NULL,
ADD ssl_cipher BLOB NOT NULL,
ADD x509_issuer BLOB NOT NULL,
ADD x509_subject BLOB NOT NULL
4 Query ALTER TABLE user MODIFY ssl_type enum('','ANY','X509', 'SPECIFIED') NOT NULL
4 Query CREATE TABLE IF NOT EXISTS tables_priv (
Host char(60) binary DEFAULT '' NOT NULL,
Db char(64) binary DEFAULT '' NOT NULL,
User char(16) binary DEFAULT '' NOT NULL,
Table_name char(64) binary DEFAULT '' NOT NULL,
Grantor char(77) DEFAULT '' NOT NULL,
Timestamp timestamp(14),
Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') COLLATE utf8_general_ci DEFAULT '' NOT NULL,
Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL,
PRIMARY KEY (Host,Db,User,Table_name)
) CHARACTER SET utf8 COLLATE utf8_bin
4 Query ALTER TABLE tables_priv
modify Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') COLLATE utf8_general_ci DEFAULT '' NOT NULL,
modify Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL
4 Query ALTER TABLE procs_priv ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin
4 Query ALTER TABLE procs_priv
modify Proc_priv set('Execute','Alter Routine','Grant') COLLATE utf8_general_ci DEFAULT '' NOT NULL
4 Query ALTER TABLE procs_priv
add Routine_type enum('FUNCTION','PROCEDURE') COLLATE utf8_general_ci NOT NULL AFTER Routine_name
4 Query ALTER TABLE procs_priv
modify Timestamp timestamp(14) AFTER Proc_priv
4 Query CREATE TABLE IF NOT EXISTS columns_priv (
Host char(60) DEFAULT '' NOT NULL,
Db char(64) DEFAULT '' NOT NULL,
User char(16) DEFAULT '' NOT NULL,
Table_name char(64) DEFAULT '' NOT NULL,
Column_name char(64) DEFAULT '' NOT NULL,
Timestamp timestamp(14),
Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL,
PRIMARY KEY (Host,Db,User,Table_name,Column_name)
) CHARACTER SET utf8 COLLATE utf8_bin
4 Query ALTER TABLE columns_priv
MODIFY Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL
4 Query ALTER TABLE columns_priv change Type Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL
4 Query ALTER TABLE func add type enum ('function','aggregate') COLLATE utf8_general_ci NOT NULL
4 Query SET @hadShowDbPriv:=0
4 Query SELECT @hadShowDbPriv:=1 FROM user WHERE Show_db_priv LIKE '%'
4 Query ALTER TABLE user
ADD Show_db_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Alter_priv,
ADD Super_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Show_db_priv,
ADD Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Super_priv,
ADD Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Create_tmp_table_priv,
ADD Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Lock_tables_priv,
ADD Repl_slave_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Execute_priv,
ADD Repl_client_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Repl_slave_priv
4 Query UPDATE user SET Show_db_priv= Select_priv, Super_priv=Process_priv, Execute_priv=Process_priv, Create_tmp_table_priv='Y', Lock_tables_priv='Y', Repl_slave_priv=file_priv, Repl_client_priv=File_priv where user<>"" AND @hadShowDbPriv = 0
4 Query ALTER TABLE user
ADD max_questions int(11) NOT NULL DEFAULT 0 AFTER x509_subject,
ADD max_updates int(11) unsigned NOT NULL DEFAULT 0 AFTER max_questions,
ADD max_connections int(11) unsigned NOT NULL DEFAULT 0 AFTER max_updates
4 Query ALTER TABLE db
ADD Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
ADD Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL
4 Query ALTER TABLE host
ADD Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
ADD Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL
4 Query alter table user change max_questions max_questions int(11) unsigned DEFAULT 0 NOT NULL
4 Query alter table tables_priv add KEY Grantor (Grantor)
4 Query alter table db comment='Database privileges'
4 Query alter table host comment='Host privileges; Merged with database privileges'
4 Query alter table user comment='Users and global privileges'
4 Query alter table func comment='User defined functions'
4 Query alter table tables_priv comment='Table privileges'
4 Query alter table columns_priv comment='Column privileges'
4 Query ALTER TABLE user
MODIFY Host char(60) NOT NULL default '',
MODIFY User char(16) NOT NULL default '',
ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin
4 Query ALTER TABLE user
MODIFY Password char(41) character set latin1 collate latin1_bin NOT NULL default '',
MODIFY Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Reload_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Shutdown_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Process_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY File_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Show_db_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Super_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Repl_slave_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Repl_client_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY ssl_type enum('','ANY','X509', 'SPECIFIED') COLLATE utf8_general_ci DEFAULT '' NOT NULL
4 Query ALTER TABLE db
MODIFY Host char(60) NOT NULL default '',
MODIFY Db char(64) NOT NULL default '',
MODIFY User char(16) NOT NULL default '',
ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin
4 Query ALTER TABLE db
MODIFY Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL
4 Query ALTER TABLE host
MODIFY Host char(60) NOT NULL default '',
MODIFY Db char(64) NOT NULL default '',
ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin
4 Query ALTER TABLE host
MODIFY Select_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Insert_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Update_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Delete_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Create_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Drop_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Grant_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY References_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Index_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Alter_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Create_tmp_table_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
MODIFY Lock_tables_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL
4 Query ALTER TABLE func
ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin
4 Query ALTER TABLE func
MODIFY type enum ('function','aggregate') COLLATE utf8_general_ci NOT NULL
4 Query ALTER TABLE columns_priv
MODIFY Host char(60) NOT NULL default '',
MODIFY Db char(64) NOT NULL default '',
MODIFY User char(16) NOT NULL default '',
MODIFY Table_name char(64) NOT NULL default '',
MODIFY Column_name char(64) NOT NULL default '',
ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin
4 Query ALTER TABLE columns_priv
MODIFY Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL
4 Query ALTER TABLE tables_priv
MODIFY Host char(60) NOT NULL default '',
MODIFY Db char(64) NOT NULL default '',
MODIFY User char(16) NOT NULL default '',
MODIFY Table_name char(64) NOT NULL default '',
MODIFY Grantor char(77) NOT NULL default '',
ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin
4 Query ALTER TABLE tables_priv
MODIFY Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') COLLATE utf8_general_ci DEFAULT '' NOT NULL,
MODIFY Column_priv set('Select','Insert','Update','References') COLLATE utf8_general_ci DEFAULT '' NOT NULL
070322 21:11:26 4 Query SET @hadCreateViewPriv:=0
4 Query SELECT @hadCreateViewPriv:=1 FROM user WHERE Create_view_priv LIKE '%'
4 Query ALTER TABLE db ADD Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Lock_tables_priv
4 Query ALTER TABLE host ADD Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Lock_tables_priv
4 Query ALTER TABLE user ADD Create_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Repl_client_priv
4 Query ALTER TABLE db ADD Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Create_view_priv
4 Query ALTER TABLE host ADD Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Create_view_priv
4 Query ALTER TABLE user ADD Show_view_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Create_view_priv
4 Query ALTER TABLE tables_priv MODIFY Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view') COLLATE utf8_general_ci DEFAULT '' NOT NULL
4 Query UPDATE user SET Create_view_priv=Create_priv, Show_view_priv=Create_priv where user<>"" AND @hadCreateViewPriv = 0
4 Query SET @hadCreateRoutinePriv:=0
4 Query SELECT @hadCreateRoutinePriv:=1 FROM user WHERE Create_routine_priv LIKE '%'
4 Query ALTER TABLE db ADD Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Show_view_priv
4 Query ALTER TABLE host ADD Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Show_view_priv
4 Query ALTER TABLE user ADD Create_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Show_view_priv
4 Query ALTER TABLE db ADD Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Create_routine_priv
4 Query ALTER TABLE host ADD Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Create_routine_priv
4 Query ALTER TABLE user ADD Alter_routine_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Create_routine_priv
4 Query ALTER TABLE db ADD Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Alter_routine_priv
4 Query ALTER TABLE host ADD Execute_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Alter_routine_priv
4 Query UPDATE user SET Create_routine_priv=Create_priv, Alter_routine_priv=Alter_priv where user<>"" AND @hadCreateRoutinePriv = 0
4 Query UPDATE db SET Create_routine_priv=Create_priv, Alter_routine_priv=Alter_priv, Execute_priv=Select_priv where user<>"" AND @hadCreateRoutinePriv = 0
4 Query UPDATE host SET Create_routine_priv=Create_priv, Alter_routine_priv=Alter_priv, Execute_priv=Select_priv where @hadCreateRoutinePriv = 0
4 Query ALTER TABLE user ADD max_user_connections int(11) unsigned DEFAULT '0' NOT NULL AFTER max_connections
4 Query SET @hadCreateUserPriv:=0
4 Query SELECT @hadCreateUserPriv:=1 FROM user WHERE Create_user_priv LIKE '%'
4 Query ALTER TABLE user ADD Create_user_priv enum('N','Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL AFTER Alter_routine_priv
4 Query UPDATE user LEFT JOIN db USING (Host,User) SET Create_user_priv='Y'
WHERE @hadCreateUserPriv = 0 AND
(user.Grant_priv = 'Y' OR db.Grant_priv = 'Y')
4 Query CREATE TABLE IF NOT EXISTS procs_priv (
Host char(60) binary DEFAULT '' NOT NULL,
Db char(64) binary DEFAULT '' NOT NULL,
User char(16) binary DEFAULT '' NOT NULL,
Routine_name char(64) binary DEFAULT '' NOT NULL,
Routine_type enum('FUNCTION','PROCEDURE') NOT NULL,
Grantor char(77) DEFAULT '' NOT NULL,
Proc_priv set('Execute','Alter Routine','Grant') COLLATE utf8_general_ci DEFAULT '' NOT NULL,
Timestamp timestamp(14),
PRIMARY KEY (Host,Db,User,Routine_name,Routine_type),
KEY Grantor (Grantor)
) CHARACTER SET utf8 COLLATE utf8_bin comment='Procedure privileges'
4 Query CREATE TABLE IF NOT EXISTS help_topic (
help_topic_id int unsigned not null,
name varchar(64) not null,
help_category_id smallint unsigned not null,
description text not null,
example text not null,
url varchar(128) not null,
primary key (help_topic_id), unique index (name)
) CHARACTER SET utf8 comment='help topics'
4 Query CREATE TABLE IF NOT EXISTS help_category (
help_category_id smallint unsigned not null,
name varchar(64) not null,
parent_category_id smallint unsigned null,
url varchar(128) not null,
primary key (help_category_id),
unique index (name)
) CHARACTER SET utf8 comment='help categories'
4 Query CREATE TABLE IF NOT EXISTS help_relation (
help_topic_id int unsigned not null references help_topic,
help_keyword_id int unsigned not null references help_keyword,
primary key (help_keyword_id, help_topic_id)
) CHARACTER SET utf8 comment='keyword-topic relation'
4 Query CREATE TABLE IF NOT EXISTS help_keyword (
help_keyword_id int unsigned not null,
name varchar(64) not null,
primary key (help_keyword_id),
unique index (name)
) CHARACTER SET utf8 comment='help keywords'
4 Query CREATE TABLE IF NOT EXISTS time_zone_name (
Name char(64) NOT NULL,
Time_zone_id int unsigned NOT NULL,
PRIMARY KEY Name (Name)
) CHARACTER SET utf8 comment='Time zone names'
4 Query CREATE TABLE IF NOT EXISTS time_zone (
Time_zone_id int unsigned NOT NULL auto_increment,
Use_leap_seconds enum('Y','N') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL,
PRIMARY KEY TzId (Time_zone_id)
) CHARACTER SET utf8 comment='Time zones'
4 Query ALTER TABLE time_zone
MODIFY Use_leap_seconds enum('Y','N') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL
4 Query CREATE TABLE IF NOT EXISTS time_zone_transition (
Time_zone_id int unsigned NOT NULL,
Transition_time bigint signed NOT NULL,
Transition_type_id int unsigned NOT NULL,
PRIMARY KEY TzIdTranTime (Time_zone_id, Transition_time)
) CHARACTER SET utf8 comment='Time zone transitions'
4 Query CREATE TABLE IF NOT EXISTS time_zone_transition_type (
Time_zone_id int unsigned NOT NULL,
Transition_type_id int unsigned NOT NULL,
Offset int signed DEFAULT 0 NOT NULL,
Is_DST tinyint unsigned DEFAULT 0 NOT NULL,
Abbreviation char(8) DEFAULT '' NOT NULL,
PRIMARY KEY TzIdTrTId (Time_zone_id, Transition_type_id)
) CHARACTER SET utf8 comment='Time zone transition types'
4 Query CREATE TABLE IF NOT EXISTS time_zone_leap_second (
Transition_time bigint signed NOT NULL,
Correction int signed NOT NULL,
PRIMARY KEY TranTime (Transition_time)
) CHARACTER SET utf8 comment='Leap seconds information for time zones'
4 Query CREATE TABLE IF NOT EXISTS proc (
db char(64) collate utf8_bin DEFAULT '' NOT NULL,
name char(64) DEFAULT '' NOT NULL,
type enum('FUNCTION','PROCEDURE') NOT NULL,
specific_name char(64) DEFAULT '' NOT NULL,
language enum('SQL') DEFAULT 'SQL' NOT NULL,
sql_data_access enum('CONTAINS_SQL',
'NO_SQL',
'READS_SQL_DATA',
'MODIFIES_SQL_DATA'
) DEFAULT 'CONTAINS_SQL' NOT NULL,
is_deterministic enum('YES','NO') DEFAULT 'NO' NOT NULL,
security_type enum('INVOKER','DEFINER') DEFAULT 'DEFINER' NOT NULL,
param_list blob DEFAULT '' NOT NULL,
returns char(64) DEFAULT '' NOT NULL,
body longblob DEFAULT '' NOT NULL,
definer char(77) collate utf8_bin DEFAULT '' NOT NULL,
created timestamp,
modified timestamp,
sql_mode set(
'REAL_AS_FLOAT',
'PIPES_AS_CONCAT',
'ANSI_QUOTES',
'IGNORE_SPACE',
'NOT_USED',
'ONLY_FULL_GROUP_BY',
'NO_UNSIGNED_SUBTRACTION',
'NO_DIR_IN_CREATE',
'POSTGRESQL',
'ORACLE',
'MSSQL',
'DB2',
'MAXDB',
'NO_KEY_OPTIONS',
'NO_TABLE_OPTIONS',
'NO_FIELD_OPTIONS',
'MYSQL323',
'MYSQL40',
'ANSI',
'NO_AUTO_VALUE_ON_ZERO',
'NO_BACKSLASH_ESCAPES',
'STRICT_TRANS_TABLES',
'STRICT_ALL_TABLES',
'NO_ZERO_IN_DATE',
'NO_ZERO_DATE',
'INVALID_DATES',
'ERROR_FOR_DIVISION_BY_ZERO',
'TRADITIONAL',
'NO_AUTO_CREATE_USER',
'HIGH_NOT_PRECEDENCE'
) DEFAULT '' NOT NULL,
comment char(64) collate utf8_bin DEFAULT '' NOT NULL,
PRIMARY KEY (db,name,type)
) engine=MyISAM
character set utf8
comment='Stored Procedures'
4 Query ALTER TABLE proc MODIFY name char(64) DEFAULT '' NOT NULL,
MODIFY specific_name char(64) DEFAULT '' NOT NULL,
MODIFY sql_data_access
enum('CONTAINS_SQL',
'NO_SQL',
'READS_SQL_DATA',
'MODIFIES_SQL_DATA'
) DEFAULT 'CONTAINS_SQL' NOT NULL,
MODIFY body longblob DEFAULT '' NOT NULL,
MODIFY sql_mode
set('REAL_AS_FLOAT',
'PIPES_AS_CONCAT',
'ANSI_QUOTES',
'IGNORE_SPACE',
'NOT_USED',
'ONLY_FULL_GROUP_BY',
'NO_UNSIGNED_SUBTRACTION',
'NO_DIR_IN_CREATE',
'POSTGRESQL',
'ORACLE',
'MSSQL',
'DB2',
'MAXDB',
'NO_KEY_OPTIONS',
'NO_TABLE_OPTIONS',
'NO_FIELD_OPTIONS',
'MYSQL323',
'MYSQL40',
'ANSI',
'NO_AUTO_VALUE_ON_ZERO',
'NO_BACKSLASH_ESCAPES',
'STRICT_TRANS_TABLES',
'STRICT_ALL_TABLES',
'NO_ZERO_IN_DATE',
'NO_ZERO_DATE',
'INVALID_DATES',
'ERROR_FOR_DIVISION_BY_ZERO',
'TRADITIONAL',
'NO_AUTO_CREATE_USER',
'HIGH_NOT_PRECEDENCE'
) DEFAULT '' NOT NULL,
DEFAULT CHARACTER SET utf8
4 Query ALTER TABLE proc CONVERT TO CHARACTER SET utf8
4 Query ALTER TABLE proc MODIFY db
char(64) collate utf8_bin DEFAULT '' NOT NULL,
MODIFY definer
char(77) collate utf8_bin DEFAULT '' NOT NULL,
MODIFY comment
char(64) collate utf8_bin DEFAULT '' NOT NULL
4 Query flush privileges
4 Quit
5 Connect [EMAIL PROTECTED] on
5 Query SHOW DATABASES
5 Init DB mysql
5 Query SHOW TABLES
5 Query CHECK TABLE `columns_priv` FAST
5 Query CHECK TABLE `db` FAST
5 Query CHECK TABLE `func` FAST
5 Query CHECK TABLE `help_category` FAST
5 Query CHECK TABLE `help_keyword` FAST
5 Query CHECK TABLE `help_relation` FAST
5 Query CHECK TABLE `help_topic` FAST
5 Query CHECK TABLE `host` FAST
5 Query CHECK TABLE `proc` FAST
5 Query CHECK TABLE `procs_priv` FAST
5 Query CHECK TABLE `tables_priv` FAST
5 Query CHECK TABLE `time_zone` FAST
5 Query CHECK TABLE `time_zone_leap_second` FAST
5 Query CHECK TABLE `time_zone_name` FAST
5 Query CHECK TABLE `time_zone_transition` FAST
5 Query CHECK TABLE `time_zone_transition_type` FAST
5 Query CHECK TABLE `user` FAST
5 Init DB mythconverg
5 Query SHOW TABLES
5 Query CHECK TABLE `archiveitems` FAST
5 Query CHECK TABLE `callsignnetworkmap` FAST
5 Query CHECK TABLE `capturecard` FAST
5 Query CHECK TABLE `cardinput` FAST
5 Query CHECK TABLE `channel` FAST
5 Query CHECK TABLE `codecparams` FAST
5 Query CHECK TABLE `credits` FAST
5 Query CHECK TABLE `customexample` FAST
5 Query CHECK TABLE `diseqc_config` FAST
5 Query CHECK TABLE `diseqc_tree` FAST
5 Query CHECK TABLE `dtv_multiplex` FAST
5 Query CHECK TABLE `dtv_privatetypes` FAST
5 Query CHECK TABLE `dvdinput` FAST
5 Query CHECK TABLE `dvdtranscode` FAST
5 Query CHECK TABLE `eit_cache` FAST
5 Query CHECK TABLE `favorites` FAST
5 Query CHECK TABLE `filemarkup` FAST
5 Query CHECK TABLE `gallerymetadata` FAST
5 Query CHECK TABLE `gamemetadata` FAST
5 Query CHECK TABLE `gameplayers` FAST
5 Query CHECK TABLE `housekeeping` FAST
5 Query CHECK TABLE `inuseprograms` FAST
5 Query CHECK TABLE `jobqueue` FAST
5 Query CHECK TABLE `jumppoints` FAST
5 Query CHECK TABLE `keybindings` FAST
5 Query CHECK TABLE `keyword` FAST
5 Query CHECK TABLE `music_albums` FAST
5 Query CHECK TABLE `music_artists` FAST
5 Query CHECK TABLE `music_genres` FAST
5 Query CHECK TABLE `music_playlists` FAST
5 Query CHECK TABLE `music_smartplaylist_categories` FAST
5 Query CHECK TABLE `music_smartplaylist_items` FAST
5 Query CHECK TABLE `music_smartplaylists` FAST
5 Query CHECK TABLE `music_songs` FAST
5 Query CHECK TABLE `music_stats` FAST
5 Query CHECK TABLE `musicmetadata` FAST
5 Query CHECK TABLE `musicplaylist` FAST
5 Query CHECK TABLE `mythlog` FAST
5 Query CHECK TABLE `mythweb_sessions` FAST
5 Query CHECK TABLE `networkiconmap` FAST
5 Query CHECK TABLE `oldfind` FAST
5 Query CHECK TABLE `oldprogram` FAST
5 Query CHECK TABLE `oldrecorded` FAST
5 Query CHECK TABLE `people` FAST
5 Query CHECK TABLE `phonecallhistory` FAST
5 Query CHECK TABLE `phonedirectory` FAST
5 Query CHECK TABLE `pidcache` FAST
5 Query CHECK TABLE `playgroup` FAST
5 Query CHECK TABLE `profilegroups` FAST
5 Query CHECK TABLE `program` FAST
5 Query CHECK TABLE `programgenres` FAST
5 Query CHECK TABLE `programrating` FAST
5 Query CHECK TABLE `recgrouppassword` FAST
5 Query CHECK TABLE `record` FAST
5 Query CHECK TABLE `record_tmp` FAST
5 Query CHECK TABLE `recorded` FAST
5 Query CHECK TABLE `recordedcredits` FAST
5 Query CHECK TABLE `recordedmarkup` FAST
5 Query CHECK TABLE `recordedprogram` FAST
5 Query CHECK TABLE `recordedrating` FAST
5 Query CHECK TABLE `recordedseek` FAST
5 Query CHECK TABLE `recordingprofiles` FAST
5 Query CHECK TABLE `recordmatch` FAST
5 Query CHECK TABLE `romdb` FAST
5 Query CHECK TABLE `schemalock` FAST
5 Query CHECK TABLE `settings` FAST
5 Query CHECK TABLE `tvchain` FAST
070322 21:11:27 5 Query CHECK TABLE `videocategory` FAST
5 Query CHECK TABLE `videocountry` FAST
5 Query CHECK TABLE `videogenre` FAST
5 Query CHECK TABLE `videometadata` FAST
5 Query CHECK TABLE `videometadatacountry` FAST
5 Query CHECK TABLE `videometadatagenre` FAST
5 Query CHECK TABLE `videosource` FAST
5 Query CHECK TABLE `videotypes` FAST
5 Query CHECK TABLE `websites` FAST
5 Quit
070322 21:12:16 6 Connect [EMAIL PROTECTED] on
6 Query SET SESSION interactive_timeout=1000000
6 Query SELECT @@sql_mode
6 Query SET SESSION sql_mode=''
6 Query SET NAMES utf8
6 Query SHOW VARIABLES LIKE 'datadir'
6 Query SHOW VARIABLES LIKE 'log_error'
070322 21:12:19 6 Query show databases
070322 21:12:21 6 Init DB mythconverg
6 Query SHOW TABLE STATUS
6 Query SHOW INDEX FROM `archiveitems`
6 Query DESCRIBE `archiveitems`
6 Query SHOW INDEX FROM `callsignnetworkmap`
6 Query DESCRIBE `callsignnetworkmap`
6 Query SHOW INDEX FROM `capturecard`
6 Query DESCRIBE `capturecard`
6 Query SHOW INDEX FROM `cardinput`
6 Query DESCRIBE `cardinput`
6 Query SHOW INDEX FROM `channel`
6 Query DESCRIBE `channel`
6 Query SHOW INDEX FROM `codecparams`
6 Query DESCRIBE `codecparams`
6 Query SHOW INDEX FROM `credits`
6 Query DESCRIBE `credits`
6 Query SHOW INDEX FROM `customexample`
6 Query DESCRIBE `customexample`
6 Query SHOW INDEX FROM `diseqc_config`
6 Query DESCRIBE `diseqc_config`
6 Query SHOW INDEX FROM `diseqc_tree`
6 Query DESCRIBE `diseqc_tree`
6 Query SHOW INDEX FROM `dtv_multiplex`
6 Query DESCRIBE `dtv_multiplex`
6 Query SHOW INDEX FROM `dtv_privatetypes`
6 Query DESCRIBE `dtv_privatetypes`
6 Query SHOW INDEX FROM `dvdinput`
6 Query DESCRIBE `dvdinput`
6 Query SHOW INDEX FROM `dvdtranscode`
6 Query DESCRIBE `dvdtranscode`
6 Query SHOW INDEX FROM `eit_cache`
6 Query DESCRIBE `eit_cache`
6 Query SHOW INDEX FROM `favorites`
6 Query DESCRIBE `favorites`
6 Query SHOW INDEX FROM `filemarkup`
6 Query DESCRIBE `filemarkup`
6 Query SHOW INDEX FROM `gallerymetadata`
6 Query DESCRIBE `gallerymetadata`
6 Query SHOW INDEX FROM `gamemetadata`
6 Query DESCRIBE `gamemetadata`
6 Query SHOW INDEX FROM `gameplayers`
6 Query DESCRIBE `gameplayers`
6 Query SHOW INDEX FROM `housekeeping`
6 Query DESCRIBE `housekeeping`
6 Query SHOW INDEX FROM `inuseprograms`
6 Query DESCRIBE `inuseprograms`
6 Query SHOW INDEX FROM `jobqueue`
6 Query DESCRIBE `jobqueue`
6 Query SHOW INDEX FROM `jumppoints`
6 Query DESCRIBE `jumppoints`
6 Query SHOW INDEX FROM `keybindings`
6 Query DESCRIBE `keybindings`
6 Query SHOW INDEX FROM `keyword`
6 Query DESCRIBE `keyword`
6 Query SHOW INDEX FROM `music_albums`
6 Query DESCRIBE `music_albums`
6 Query SHOW INDEX FROM `music_artists`
6 Query DESCRIBE `music_artists`
6 Query SHOW INDEX FROM `music_genres`
6 Query DESCRIBE `music_genres`
6 Query SHOW INDEX FROM `music_playlists`
6 Query DESCRIBE `music_playlists`
6 Query SHOW INDEX FROM `music_smartplaylist_categories`
6 Query DESCRIBE `music_smartplaylist_categories`
6 Query SHOW INDEX FROM `music_smartplaylist_items`
6 Query DESCRIBE `music_smartplaylist_items`
6 Query SHOW INDEX FROM `music_smartplaylists`
6 Query DESCRIBE `music_smartplaylists`
6 Query SHOW INDEX FROM `music_songs`
6 Query DESCRIBE `music_songs`
6 Query SHOW INDEX FROM `music_stats`
6 Query DESCRIBE `music_stats`
070322 21:12:22 6 Query SHOW INDEX FROM `musicmetadata`
6 Query DESCRIBE `musicmetadata`
6 Query SHOW INDEX FROM `musicplaylist`
6 Query DESCRIBE `musicplaylist`
6 Query SHOW INDEX FROM `mythlog`
6 Query DESCRIBE `mythlog`
6 Query SHOW INDEX FROM `mythweb_sessions`
6 Query DESCRIBE `mythweb_sessions`
6 Query SHOW INDEX FROM `networkiconmap`
6 Query DESCRIBE `networkiconmap`
6 Query SHOW INDEX FROM `oldfind`
6 Query DESCRIBE `oldfind`
6 Query SHOW INDEX FROM `oldprogram`
6 Query DESCRIBE `oldprogram`
6 Query SHOW INDEX FROM `oldrecorded`
6 Query DESCRIBE `oldrecorded`
6 Query SHOW INDEX FROM `people`
6 Query DESCRIBE `people`
6 Query SHOW INDEX FROM `phonecallhistory`
6 Query DESCRIBE `phonecallhistory`
6 Query SHOW INDEX FROM `phonedirectory`
6 Query DESCRIBE `phonedirectory`
6 Query SHOW INDEX FROM `pidcache`
6 Query DESCRIBE `pidcache`
6 Query SHOW INDEX FROM `playgroup`
6 Query DESCRIBE `playgroup`
6 Query SHOW INDEX FROM `profilegroups`
6 Query DESCRIBE `profilegroups`
6 Query SHOW INDEX FROM `program`
6 Query DESCRIBE `program`
6 Query SHOW INDEX FROM `programgenres`
6 Query DESCRIBE `programgenres`
6 Query SHOW INDEX FROM `programrating`
6 Query DESCRIBE `programrating`
6 Query SHOW INDEX FROM `recgrouppassword`
6 Query DESCRIBE `recgrouppassword`
6 Query SHOW INDEX FROM `record`
6 Query DESCRIBE `record`
6 Query SHOW INDEX FROM `record_tmp`
6 Query DESCRIBE `record_tmp`
6 Query SHOW INDEX FROM `recorded`
6 Query DESCRIBE `recorded`
6 Query SHOW INDEX FROM `recordedcredits`
6 Query DESCRIBE `recordedcredits`
6 Query SHOW INDEX FROM `recordedmarkup`
6 Query DESCRIBE `recordedmarkup`
6 Query SHOW INDEX FROM `recordedprogram`
6 Query DESCRIBE `recordedprogram`
6 Query SHOW INDEX FROM `recordedrating`
6 Query DESCRIBE `recordedrating`
6 Query SHOW INDEX FROM `recordedseek`
6 Query DESCRIBE `recordedseek`
6 Query SHOW INDEX FROM `recordingprofiles`
6 Query DESCRIBE `recordingprofiles`
6 Query SHOW INDEX FROM `recordmatch`
6 Query DESCRIBE `recordmatch`
6 Query SHOW INDEX FROM `romdb`
6 Query DESCRIBE `romdb`
6 Query SHOW INDEX FROM `schemalock`
6 Query DESCRIBE `schemalock`
6 Query SHOW INDEX FROM `settings`
6 Query DESCRIBE `settings`
6 Query SHOW INDEX FROM `tvchain`
6 Query DESCRIBE `tvchain`
6 Query SHOW INDEX FROM `videocategory`
6 Query DESCRIBE `videocategory`
6 Query SHOW INDEX FROM `videocountry`
6 Query DESCRIBE `videocountry`
6 Query SHOW INDEX FROM `videogenre`
6 Query DESCRIBE `videogenre`
6 Query SHOW INDEX FROM `videometadata`
6 Query DESCRIBE `videometadata`
6 Query SHOW INDEX FROM `videometadatacountry`
6 Query DESCRIBE `videometadatacountry`
6 Query SHOW INDEX FROM `videometadatagenre`
6 Query DESCRIBE `videometadatagenre`
6 Query SHOW INDEX FROM `videosource`
6 Query DESCRIBE `videosource`
6 Query SHOW INDEX FROM `videotypes`
6 Query DESCRIBE `videotypes`
6 Query SHOW INDEX FROM `websites`
6 Query DESCRIBE `websites`
6 Init DB mythconverg
6 Query SHOW TABLE STATUS
6 Init DB mythconverg
6 Init DB mythconverg
6 Query SHOW PROCEDURE STATUS
6 Query SHOW FUNCTION STATUS
6 Init DB mythconverg
070322 21:12:33 6 Init DB mythconverg
6 Query SHOW FULL TABLES
6 Query SHOW PROCEDURE STATUS WHERE DB='mythconverg'
6 Query SHOW FUNCTION STATUS WHERE DB='mythconverg'
6 Query select TRIGGER_NAME from information_schema.TRIGGERS where TRIGGER_SCHEMA = 'mythconverg'
6 Query show table status from `mythconverg` like "archiveitems"
6 Query show table status from `mythconverg` like "callsignnetworkmap"
6 Query show table status from `mythconverg` like "capturecard"
6 Query show table status from `mythconverg` like "cardinput"
6 Query show table status from `mythconverg` like "channel"
6 Query show table status from `mythconverg` like "codecparams"
6 Query show table status from `mythconverg` like "credits"
6 Query show table status from `mythconverg` like "customexample"
6 Query show table status from `mythconverg` like "diseqc_config"
6 Query show table status from `mythconverg` like "diseqc_tree"
6 Query show table status from `mythconverg` like "dtv_multiplex"
6 Query show table status from `mythconverg` like "dtv_privatetypes"
6 Query show table status from `mythconverg` like "dvdinput"
6 Query show table status from `mythconverg` like "dvdtranscode"
6 Query show table status from `mythconverg` like "eit_cache"
6 Query show table status from `mythconverg` like "favorites"
6 Query show table status from `mythconverg` like "filemarkup"
6 Query show table status from `mythconverg` like "gallerymetadata"
6 Query show table status from `mythconverg` like "gamemetadata"
6 Query show table status from `mythconverg` like "gameplayers"
6 Query show table status from `mythconverg` like "housekeeping"
6 Query show table status from `mythconverg` like "inuseprograms"
070322 21:12:34 6 Query show table status from `mythconverg` like "jobqueue"
6 Query show table status from `mythconverg` like "jumppoints"
6 Query show table status from `mythconverg` like "keybindings"
6 Query show table status from `mythconverg` like "keyword"
6 Query show table status from `mythconverg` like "music_albums"
6 Query show table status from `mythconverg` like "music_artists"
6 Query show table status from `mythconverg` like "music_genres"
6 Query show table status from `mythconverg` like "music_playlists"
6 Query show table status from `mythconverg` like "music_smartplaylist_categories"
6 Query show table status from `mythconverg` like "music_smartplaylist_items"
6 Query show table status from `mythconverg` like "music_smartplaylists"
6 Query show table status from `mythconverg` like "music_songs"
6 Query show table status from `mythconverg` like "music_stats"
6 Query show table status from `mythconverg` like "musicmetadata"
6 Query show table status from `mythconverg` like "musicplaylist"
6 Query show table status from `mythconverg` like "mythlog"
6 Query show table status from `mythconverg` like "mythweb_sessions"
6 Query show table status from `mythconverg` like "networkiconmap"
6 Query show table status from `mythconverg` like "oldfind"
6 Query show table status from `mythconverg` like "oldprogram"
6 Query show table status from `mythconverg` like "oldrecorded"
6 Query show table status from `mythconverg` like "people"
6 Query show table status from `mythconverg` like "phonecallhistory"
6 Query show table status from `mythconverg` like "phonedirectory"
6 Query show table status from `mythconverg` like "pidcache"
6 Query show table status from `mythconverg` like "playgroup"
6 Query show table status from `mythconverg` like "profilegroups"
6 Query show table status from `mythconverg` like "program"
6 Query show table status from `mythconverg` like "programgenres"
6 Query show table status from `mythconverg` like "programrating"
6 Query show table status from `mythconverg` like "recgrouppassword"
6 Query show table status from `mythconverg` like "record"
6 Query show table status from `mythconverg` like "record_tmp"
6 Query show table status from `mythconverg` like "recorded"
6 Query show table status from `mythconverg` like "recordedcredits"
6 Query show table status from `mythconverg` like "recordedmarkup"
6 Query show table status from `mythconverg` like "recordedprogram"
6 Query show table status from `mythconverg` like "recordedrating"
6 Query show table status from `mythconverg` like "recordedseek"
6 Query show table status from `mythconverg` like "recordingprofiles"
6 Query show table status from `mythconverg` like "recordmatch"
6 Query show table status from `mythconverg` like "romdb"
6 Query show table status from `mythconverg` like "schemalock"
6 Query show table status from `mythconverg` like "settings"
6 Query show table status from `mythconverg` like "tvchain"
6 Query show table status from `mythconverg` like "videocategory"
6 Query show table status from `mythconverg` like "videocountry"
6 Query show table status from `mythconverg` like "videogenre"
6 Query show table status from `mythconverg` like "videometadata"
6 Query show table status from `mythconverg` like "videometadatacountry"
6 Query show table status from `mythconverg` like "videometadatagenre"
6 Query show table status from `mythconverg` like "videosource"
6 Query show table status from `mythconverg` like "videotypes"
6 Query show table status from `mythconverg` like "websites"
6 Query /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, sql_mode='' */
6 Query use mysql
6 Init DB Access denied for user 'mythtv'@'192.168.178.%' to database 'mysql'
