I can't understans it though.
I did a mysql dump and transported that to the new server and then
created the tables that way.
So the two must be absolutely identical. (I include them @ the bottom of
post)
Again I get the same error.
Could it be that the status of that particular username has changed ??
mysql> show slave status;
+---------------+-------------+-------------+---------------+-------------------+--------+---------------+-----------------+---------------------+------------+-----------------------------------------------------------------------------------------------------------------------------------+--------------+
| Master_Host | Master_User | Master_Port | Connect_retry | Log_File
| Pos | Slave_Running | Replicate_do_db |
Replicate_ignore_db | Last_errno | Last_error
| Skip_counter |
+---------------+-------------+-------------+---------------+-------------------+--------+---------------+-----------------+---------------------+------------+-----------------------------------------------------------------------------------------------------------------------------------+--------------+
| 196.25.84.193 | replicate | 3306 | 60 |
ais-rad02-bin.004 | 987471 | Yes | |
| 1054 | error 'Unknown column 'status' in 'field
list'' on query 'update radcheck set status = 'active' where username =
'atlantic23419'' | 0 |
+---------------+-------------+-------------+---------------+-------------------+--------+---------------+-----------------+---------------------+------------+-----------------------------------------------------------------------------------------------------------------------------------+--------------+
1 row in set (0.00 sec)
MASTER SERVER--->
mysql> desc radcheck;
+-----------+-------------+------+-----+----------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+----------+----------------+
| id | int(10) | | PRI | NULL | auto_increment |
| UserName | varchar(30) | | MUL | | |
| Attribute | varchar(30) | | | Password | |
| Value | varchar(40) | YES | | NULL | |
| status | varchar(16) | | | active | |
| op | char(2) | | | := | |
+-----------+-------------+------+-----+----------+----------------+
6 rows in set (0.00 sec)
SLAVE SERVER ---->
ysql> desc radcheck;
+-----------+-------------+------+-----+----------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+----------+----------------+
| id | int(10) | | PRI | NULL | auto_increment |
| UserName | varchar(30) | | MUL | | |
| Attribute | varchar(30) | | | Password | |
| Value | varchar(40) | YES | | NULL | |
| status | varchar(16) | | | active | |
| op | char(2) | | | := | |
+-----------+-------------+------+-----+----------+----------------+
6 rows in set (0.00 sec)
Ralf Narozny wrote:
>
> Mozzi schrieb:
>
>> Hallo all
>> I am setting up replication.
>> Now I am sure my servers can connect but I still have a problem.
>> I setup my slave server to only replicate one table
>> The error I get is copy'd underneath here.
>> I am sure it is easey to solve I have just started thinking in loops now
>>
>> Tnx
>>
>> Mozzi
>>
>> +---------------+-------------+-------------+---------------++--------------+
>>
>>
>> | Master_Host | Master_User | Master_Port | Connect_retry | Log_File
>> | Pos | Slave_Running | Replicate_do_db |
>> Replicate_ignore_db | Last_errno | Last_error
>> | Skip_counter |
>> +---------------+-------------+-------------+---------------+--+--------------+
>>
>>
>> | 192.168.2.1 | replicate | 3306 | 60 |
>> my-rad02-bin.004 | 987471 | Yes | |
>> | 1054 | error 'Unknown column 'status' in 'field
>> list'' on query 'update radcheck set status = 'active' where username
>> = 'myrad23419'' | 0 |
>> +---------------+-------------+-------------+---------------+--+--------------+
>>
>>
>> 1 row in set (0.00 sec)
>>
>
> As far as I can see the message is quite obvious: On your replication
> machine the table radcheck has no column of the name 'status'....
>
> --
> Ralf Narozny
>
> Besuchen Sie uns auf der DMS-Expo. SAP, Dokumenten-
> management oder das komplette Office ins Portal einbinden?
> Wir zeigen es Ihnen - vom 3. bis 5.9. auf der Messe Essen
> Halle 3, Stand 3255
>
> SPLENDID Internet GmbH & Co KG
> Skandinaviendamm 212, 24109 Kiel, Germany
> fon: +49 431 660 97 0, fax: +49 431 660 97 20
> mailto:[EMAIL PROTECTED], http://www.splendid.de
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
