List:Bugs« Previous MessageNext Message »
From:sasha Date:August 10 2000 5:06pm
Subject:Re: Trouble with replication.
View as plain text  
Peter Zaitsev wrote:
> 
> I'm now trying to setup a replication between two mysql servers. Both are
> running
> mysql 3.23.22 on linux RH 6.2
> 
> The problem I found is the following:
> 
> master:
> mysql> select count(*) from counter_info;
> +----------+
> | count(*) |
> +----------+
> |    28489 |
> +----------+
> 1 row in set (0.00 sec)
> 
> slave:
> 
> mysql> drop table counter_info;
> Query OK, 0 rows affected (0.00 sec)
> 
> mysql> load table counter_info from master;
> Query OK, 0 rows affected (3.26 sec)
> 
> mysql> select count(*) from counter_info;
> +----------+
> | count(*) |
> +----------+
> |        0 |
> +----------+
> 1 row in set (0.00 sec)
> 
> So somehow the table didn't come to the slave !
> 
> and the most funny thing is the followings - table files on the slave are
> exactly the same as on master:
> 
> -rw-rw----    1 root     root     11794446 Aug 10 13:18 counter_info.MYD
> -rw-rw----    1 root     root       235520 Aug 10 13:18 counter_info.MYI
> -rw-rw----    1 root     root        11390 Aug 10 13:18 counter_info.frm
> 
> (this is not zero record at least)
> 
> [root@cesar counter]# myisamchk -dv *.MYI
> 
> MyISAM file:         counter_info.MYI
> Record format:       Fixed length
> Character set:       win1251 (17)
> File-version:        1
> Creation time:       2000-08-10 13:18:22
> Recover time:        2000-08-10 13:18:25
> Status:              checked
> Auto increment key:              1  Last value:                     0
> Data records:                    0  Deleted blocks:                 0
> Datafile parts:                  0  Deleted data:                   0
> Datafile pointer (bytes):        4  Keyfile pointer (bytes):        3
> Datafile length:                 0  Keyfile length:              1024
> Max datafile length: 1778116460542  Max keyfile length:   17179868159
> Recordlength:                  414
> 
> table description:
> Key Start Len Index   Type                     Rec/key         Root
> Blocksize
> 1   2     4   unique  unsigned long                  0
> 1024
> 
> I've tried the followings several time and have the same result all the time
> !.
> There are no errors in mysqld error log.

Petya - can you ftp counter_info table to
ftp://support.mysql.com/pub/mysql/secret/ ?


-- 
Sasha Pachev

+------------------------------------------------------------------+
|      ____  __     _____   _____  ___     http://www.mysql.com    |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sasha Pachev            |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     sasha@stripped         |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Provo, Utah, USA        |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                         |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                        |
|             /*/             \*\ Developers Team                  |
+------------------------------------------------------------------+
Thread
Trouble with replication.Peter Zaitsev10 Aug
  • Re: Trouble with replication.sasha10 Aug