Hi, > *************************** 1. row *************************** > Master_Host: 10.2.12.224 > Master_User: rep > Master_Port: 3306 > Connect_retry: 60 > Master_Log_File: ef224-bin.020 > Read_Master_Log_Pos: 409223612 > Relay_Log_File: ef242-relay-bin.016 > Relay_Log_Pos: 330063332 > Relay_Master_Log_File: ef224-bin.020 > Slave_IO_Running: Yes > Slave_SQL_Running: No > Replicate_do_db: > Replicate_ignore_db: > Last_errno: 25 > Last_error: Error 'Can't create symlink > './ff_recent/#sql-17f7_c.MYI' pointing at > '/var/lib/mysql/ff_recent/#sql-17f7_c.MYI' (Error 17)' on query 'ALTER > TABLE recentmembers_20 add have_children tinyint unsigned not NULL > default 0'. Default database: 'ff_recent' > Skip_counter: 0 > Exec_master_log_pos: 348632736 > Relay_log_space: 390689457
Are the master and slave located on two different machines, or on one single machine? Are you using symlinks to place tables or databases at other locations than the datadir? If yes: * How did you do it (with manual Unix 'ln -s', with CREATE TABLE ... DATA DIRECTORY= INDEX DIRECTORY=, another way?). * Did you do it the same way on master and slave? Do master and slave have the same tree structure (i.e. do the directories ./ff_recent/ and /var/lib/mysql/ff_recent all exist on the 2 machines?). If you could provide a simple complete testcase like: "create a symlinked table on the master by following these steps, then do this ALTER, then do that ALTER", this could surely help us. Thank you. -- For technical support contracts, visit https://order.mysql.com/?ref=mgbi Are you MySQL certified? visit http://www.mysql.com/certification/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Guilhem Bichot <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Software Developer /_/ /_/\_, /___/\___\_\___/ Bordeaux, France <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]