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 2514 Chydik Sam 09/11/2011 08:40AM
Re: Error in replication with time update 00:60:00 504 Adam Donnison 09/12/2011 05:35AM
Re: Error in replication with time update 00:60:00 566 Rick James 09/12/2011 09:46PM
Re: Error in replication with time update 00:60:00 543 Chydik Sam 09/13/2011 01:59PM
Re: Error in replication with time update 00:60:00 517 Chydik Sam 09/13/2011 03:56PM
Re: Error in replication with time update 00:60:00 479 Rick James 09/14/2011 08:23PM
Re: Error in replication with time update 00:60:00 479 Chydik Sam 09/15/2011 02:13AM
Re: Error in replication with time update 00:60:00 492 Rick James 09/15/2011 10:03PM
Re: Error in replication with time update 00:60:00 512 Chydik Sam 09/18/2011 11:43PM
Re: Error in replication with time update 00:60:00 576 Chydik Sam 10/08/2011 04:54AM
Re: Error in replication with time update 00:60:00 457 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.