binlog-ignore-db replicate-ignore-db problem
Hi All, I am trying to set up a replication ignoring a given database, but unfortunatly it doesn't works (for me). In my.cnf of my master I have at the end : log-bin server-id= 1 binlog-ignore-db=access The line: binlog-ignore-db=access is supposed to make the master not to log updates for db access, but but it doesn't, and I can see it examinig my bin log with mysqlbinlog In the other hand on my repication in my.cnf I have: replicate-ignore-db=access which is supposed to make the repication to not replicate for db access, but again it doesn't do this. I know that it should works, so I suppose there is some misudrestanding at my side, so please help me with that. There are a couple of my update queries in my bin-log: update access.lastCheck set id = '7147671' where id = '123'; update access.lastCheck set id = '7147670' where id = '345'; . Best regards Vlady - 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
Innodb autoextended
Hi all, I am using mysql-4.0.1. I am trying to set up a second innodb datafile. Following the instructions in the manual I added : innodb_data_file_path=ibdata1:64M;ibdata2:100M:autoextend in my my.cnf file, but when I restart the mysql I get the error: InnoDB: syntax error in innodb_data_file_path I found that the reason for that is the last field autoextend. Can some one has had the same problem or somthing is wrong with my instalation? Vlady - 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
grant ALL on *.* to ... Error
Hi all, I have a strange problem, I am startirng my mysql-4.0.1 with option --skip-grant-tables. I am using mysql and when I try : grant ALL on *.* to admin@localhost identified by passwd i get the following errot: ERROR 1047: Unknown command Can some one felp me with that? Gregards Vlady - 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
Replication problem
Hi all, I have master - Linux 7.2, mysql-4.0.1 and slave - win2000, mysql-4.0.1. I have the following error on my replication server: Table 'access.pagespromo' doesn't exist. Slave error 'Table 'access.pagespromo' doesn't exist.' on query '%' error-code=1146. Error running query, slave aborted. But on my slave I make replication only on database fdf: [mysqld] server-id=2 master-host=mymaster.com master-user=muser master-password=mpasswd master-port=3306 replicate-do-db=fdf and on my master I am logging only database fdf [mysqld] port=3306 log-bin binlog-do-db=fdf server-id=1 socket=/tmp/mysql.sock set-variable = key_buffer_size=16M set-variable = max_allowed_packet=1M I can understand why I get this error. Can some one help my with that? Thank's in advance. Vlady - 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
Replication problem
Hi all, I have master - Linux 7.2, mysql-4.0.1 and slave - win2000, mysql-4.0.1. I have the following error on my slave server: Table 'access.pagespromo' doesn't exist. Slave error 'Table 'access.pagespromo' doesn't exist.' on query '%' error-code=1146. Error running query, slave aborted. But on my slave I make replication only on database fdf: [mysqld] server-id=2 master-host=mymaster.com master-user=muser master-password=mpasswd master-port=3306 replicate-do-db=fdf and on my master I am logging only database fdf [mysqld] port=3306 log-bin binlog-do-db=fdf server-id=1 socket=/tmp/mysql.sock set-variable = key_buffer_size=16M set-variable = max_allowed_packet=1M I can understand why I get this error. Can some one help my with that? Thank's in advance. Vlady - 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
replication problem
Hi all, I have master - Linux 7.2, mysql-4.0.1 and slave - win2000, mysql-4.0.1. I have the following error on my slave server: Table 'access.pagespromo' doesn't exist. Slave error 'Table 'access.pagespromo' doesn't exist.' on query '%' error-code=1146. Error running query, slave aborted. But on my slave I make replication only on database fdf: [mysqld] server-id=2 master-host=mymaster.com master-user=muser master-password=mpasswd master-port=3306 replicate-do-db=fdf and on my master I am logging only database fdf [mysqld] port=3306 log-bin binlog-do-db=fdf server-id=1 socket=/tmp/mysql.sock set-variable = key_buffer_size=16M set-variable = max_allowed_packet=1M I can understand why I get this error. Can some one help my with that? Thank's in advance. Vlady - 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
replication
Hi all, I would like to know how often (delay in sec.) the slave checks the master for new records in the log, and if one can control that . Thanks in advance Vlady (mysql) - 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
repication
Hi all, I would like to know how often (delay in sec.) the slave checks the master for new records in the log, and if one can control that . Thanks in advance Vlady (mysql) - 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
need help for REPLICATION
Hello, I am new in mysql, and I am trying to set an reclication. I followed the instruction in the manual but steel I have a problem. The problem is that even the replication thread works on my slave it is not doing eny updates. The master.info file is updating every minute and there is not errors in the error file. But I dont have any log file for the replication activities even I set log-slave-updates on my slave. Can some one felp me with that? Thanks in advance Vlady This is my my.cnf files on the master and the slave: On my master I have in my.cnf : [mysqld] port=3306 log-bin binlog-do-db=fdf server-id=1 On my slave I have in my.cnf : [mysqld] server-id=3 master-host=my.master master-user=replica master-password=the_passwd master-port=3306 replicate-do-db=fdf log-bin log-slave-updates - 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
replication
Hi, Setting an replication for the first time, I get the following error message in my slave: 020424 13:59:28 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020424 13:59:29 Slave: did not get the expected error running query from master - expected: 'Invalid error code' (256), got 'no error' (0) 020424 13:59:29 Slave: error running query '' 020424 13:59:29 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'FIRST' position 31632 020424 13:59:29 Slave thread exiting, replication stopped in log 'FIRST' at position 31632 If some one knows what can be the reason? I have the following configuration on the master and the slave: On my master I have in my.cnf : [mysqld] port=3306 log-bin binlog-do-db=fdf server-id=1 On my slave I have in my.cnf : [mysqld] server-id=3 master-host=cc.uc.uni-sofia.bg master-user=replica master-password=the_passwd master-port=3306 log-slave-updates - 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