Replication problem

[sasha@xxxxxxxxx]

>------=_NextPart_000_0059_01C06BD0.8B839580
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Hi,
>
>I've set up a master and a slave machine.
>I've followed all instructions in the manual and read about all common =
>problems in the
>past months discussions on the list (and seems to avoided all of them).
>
>I can't find any mail with the same error that I got in my .err file :
>
>001222 04:32:24  mysqld started
>001222  4:32:24  Warning: setrlimit returned ok, but didn't change =
>limits. Max open files is 552
>001222  4:32:24  Warning: Changed limits: max_connections: 100  =
>table_cache: 221
>/usr/local/libexec/mysqld: ready for connections
>001222  4:32:44  create_table_from_dump::failed in =
>handler::net_read_dump()
>001222  4:32:44  fetch_nx_table: failed on create table
>
>The two last lines is appearing in the slave machine's .err file when a =
>LOAD TABLE tablename FROM MASTER
>is executed.
>The error appearing in the client is: ERROR 1189: Net error reading from =
>master
>Currently I'm so frustrated with this matter that I now just giving up =
>the replication part til I get
>some feedback on this. :-(  (I really need to set this up, u know)
>
>Both servers are configured with the same hardware:
>P-III 800 MHz, 512 Mb RAM, 2 x Ultra2 LVD harddisks (one for db's and =
>one for logs)
>OS is FreeBSD 4.1-RELEASE
>
>I've tried several times to test other configurations on the slave =
>machine, by not including the log-slave-updates
>etc., with no further results.=20
>
>Master /etc/my.cnf:
>[mysqld]
>log-bin=3D/db2/mysql/replication.log
>log-bin-index=3D/db2/mysql/db.index
>
>binlog-do-db=3Ddbname
>server-id=3D1
>
>port            =3D 3306
>socket          =3D /tmp/mysql.sock
>set-variable    =3D key_buffer=3D384M
>set-variable    =3D max_allowed_packet=3D1M
>set-variable    =3D table_cache=3D512
>set-variable    =3D sort_buffer=3D2M
>set-variable    =3D record_buffer=3D2M
>set-variable    =3D thread_cache=3D8
>set-variable    =3D thread_concurrency=3D8  # Try number of CPU's*2
>set-variable    =3D myisam_sort_buffer_size=3D64M
>--EOF--
>
>Slave /etc/my.cnf
>[mysqld]
>master-host=3Dlinda
>master-user=3Dslave
>master-password=3Dslave
>
>master-info-file=3D/db2/mysql/master.info
>replicate-do-db=3Ddbname
>replicate-wild-do-table=3Ddbname.%
>
>log-bin=3D/db2/mysql/replication.log
>log-bin-index=3D/db2/mysql/db.index
>
>log-slave-updates
>

How big is the table you are trying to transfer?

If LOAD TABLE FROM MASTER does not work, you can just copy the table across the network manually. In the meantime, I'll take a look at the code and try to find out what is wrong with LOAD TABLE FROM MASTER...
-- 
Sasha Pachev

+------------------------------------------------------------------+
|      ____  __     _____   _____  ___     http://www.mysql.com    |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sasha Pachev            |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     sasha@xxxxxxxxx         |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Provo, Utah, USA        |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                         |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                        |
|             /*/             \*\ Developers Team                  |
+------------------------------------------------------------------+


-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60324@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php