Re: Replication slave repeatedly gets error 1159 from master

2002-07-15 Thread Pierre Baridon
i have the same probem since i ugraded my slave from 3.23.50 to 3.23.51 Pierre - Original Message - From: "David Harper" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 15, 2002 1:26 PM Subject: Replication slave repeatedly gets error 1159 from master > >Description: >

slave server in readonly

2002-07-10 Thread Pierre Baridon
is it possible to start a server in 'read only' mode ? so that users cannot write in my slave server ? thanks, Pierre --sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) htt

debian package

2002-07-10 Thread Pierre Baridon
is there any debian package of mysql supporting innodb ? thanks, Pierre -- sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archiv

Re: Implementing commit,transaction in isam table type

2002-07-10 Thread Pierre Baridon
why not using innodb tables ? smart chandar wrote: > I am using Mysql Db that contains Isam table types,I > am developing a project > that is using interrelated tables,unfortunatily isam > table type doesn't support > the commit and transaction,but i should implement > that,can anyone give a >

innodb database schema dump

2002-07-04 Thread Pierre Baridon
how can i dump innodb tables schema with foreign key references so that the tables are created in the right order ? thanks, Pierre -- sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manua

remove foreign key constraint

2002-06-25 Thread Pierre Baridon
how to remove a foreign key constraint without recreating the innodb table ? thanks, Pierre sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (t

replication

2002-06-21 Thread Pierre Baridon
hi, i am running mysql-max-log 32.23.50 on Solaris as slave and mysql-max-log 32.23.51 on linux as a master i often happend that slave stop because of a grant query it can't execute. a flush privileges in the slave is enough to make it restart. does anyone have this problem ?? thanks Pierr

replication

2002-06-14 Thread Pierre Baridon
i am trying to setup a slave server (3.23.50) on solaris 2.7 i follow the manual to set it up but when i start this slave server, i have the following error message from mysqld : bin/mysqld: option `--master' is ambiguous where does this --master come from thanks, Pierre -- sql, que

on delete cascade

2002-06-11 Thread Pierre Baridon
does mysql-max 3.23.50 support the option on delete cascade for the foreign key, the documentation is not very clear on this point Pierre -- sql,query - Before posting, please check: http://www.mysql.com/manual.php (th

mysql 3.23.50

2002-06-11 Thread Pierre Baridon
where can i get the 3.23.50 packages with innodb support ? Pierre -- sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To