Skip navigation links

MySQL Forums :: Replication :: Error in replication with time update 00:60:00


Advanced Search

Re: Error in replication with time update 00:60:00
Posted by: Chydik Sam ()
Date: September 15, 2011 02:13AM

mysql> SHOW VARIABLES LIKE 'binlog_format';
+---------------+-----------+
| Variable_name | Value |
+---------------+-----------+
| binlog_format | STATEMENT |
+---------------+-----------+
1 row in set (0.00 sec)


mysql> show create table sunrav_tests \g

sunrav_tests | CREATE TABLE `sunrav_tests` (
`test_id` int(4) unsigned NOT NULL auto_increment,
`test_description` text collate utf8_unicode_ci,
`test_name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`test_type` tinyint(1) NOT NULL default '0',
`test_author` varchar(255) collate utf8_unicode_ci default NULL,
`test_questions_count` int(11) unsigned NOT NULL default '1',
`test_is_exam_mode` char(1) collate utf8_unicode_ci default 'F',
`test_is_random_answers` char(1) collate utf8_unicode_ci default 'F',
`test_is_time_limit` char(1) collate utf8_unicode_ci default 'F',
`test_time_limit` time NOT NULL default '00:00:00',
`test_is_back` char(1) collate utf8_unicode_ci NOT NULL default 'F',
`test_is_show_score` char(1) collate utf8_unicode_ci default 'T',
`test_is_show_results_message` char(1) collate utf8_unicode_ci default 'T',
`test_is_next_when_right` char(1) collate utf8_unicode_ci default 'F',
`test_is_show_reference` char(1) collate utf8_unicode_ci default 'F',
`test_is_response_on_right` char(1) collate utf8_unicode_ci default 'F',
`test_is_response_on_wrong` char(1) collate utf8_unicode_ci default 'F',
`test_text_of_right_message` varchar(255) collate utf8_unicode_ci default NULL
,
`test_text_of_wrong_message` varchar(255) collate utf8_unicode_ci default NULL
,
`test_is_show_explanation` char(1) collate utf8_unicode_ci default 'F',
`test_concl_type` tinyint(2) unsigned NOT NULL default '0',
`test_is_stat_total` char(1) collate utf8_unicode_ci default 'T',
`test_is_stat_current` char(1) collate utf8_unicode_ci default 'T',
`test_is_stat_rights` char(1) collate utf8_unicode_ci default 'F',
`test_is_stat_time` char(1) collate utf8_unicode_ci default 'F',
`test_media_storage` varchar(255) collate utf8_unicode_ci default NULL,
`test_is_sort_by_theme` char(1) collate utf8_unicode_ci default 'F',
`test_max_count` int(11) default '0',
PRIMARY KEY (`test_id`),
UNIQUE KEY `test_name` (`test_name`)
) ENGINE=MyISAM AUTO_INCREMENT=508 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
ROW_FORMAT=FIXED |

=)

Options: ReplyQuote


Subject Views Written By Posted
Error in replication with time update 00:60:00 2480 Chydik Sam 09/11/2011 08:40AM
Re: Error in replication with time update 00:60:00 477 Adam Donnison 09/12/2011 05:35AM
Re: Error in replication with time update 00:60:00 535 Rick James 09/12/2011 09:46PM
Re: Error in replication with time update 00:60:00 521 Chydik Sam 09/13/2011 01:59PM
Re: Error in replication with time update 00:60:00 496 Chydik Sam 09/13/2011 03:56PM
Re: Error in replication with time update 00:60:00 452 Rick James 09/14/2011 08:23PM
Re: Error in replication with time update 00:60:00 440 Chydik Sam 09/15/2011 02:13AM
Re: Error in replication with time update 00:60:00 475 Rick James 09/15/2011 10:03PM
Re: Error in replication with time update 00:60:00 488 Chydik Sam 09/18/2011 11:43PM
Re: Error in replication with time update 00:60:00 527 Chydik Sam 10/08/2011 04:54AM
Re: Error in replication with time update 00:60:00 442 Chydik Sam 10/11/2011 12:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.