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 |
+------------------------------------------------------------------+
