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