Circular replication

2007-12-04 Thread Krishna Chandra Prajapati
Hi All, Is circular replication or chain replication is suitable for production environment. Whether any testing has been done. If yes then, Please let me know. There is any other issue related to circular replication. Thanks -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd

Is it Bug in Mysql?

2007-12-04 Thread Gaurav Pruthi
Hi, I created mysql database using following command: create database db_dbname; grant create,update,delete,delete on db_dbname.* to [EMAIL PROTECTED] by 'abcxyz'; I used to access mysql database using phpmyadmin frontend. Now the user 'gaurav' can only edit the current db and can't create datab

Re: mysqldump (in crontab) failing with 'errno 32' even though it worked last week

2007-12-04 Thread Baron Schwartz
Hi, On Dec 4, 2007 2:58 PM, Rolando Edwards <[EMAIL PROTECTED]> wrote: > 'errno 32 on write' > > That's a broken pipe error (Run 'perror 32' in Linux) > Maybe too much data is being pumped in through the pipe. > > Instead of this : > /usr/bin/mysqldump --all-databases -u root | /usr/bin/gzip -c >

RE: mysqldump (in crontab) failing with 'errno 32' even though it worked last week

2007-12-04 Thread Rolando Edwards
'errno 32 on write' That's a broken pipe error (Run 'perror 32' in Linux) Maybe too much data is being pumped in through the pipe. Instead of this : /usr/bin/mysqldump --all-databases -u root | /usr/bin/gzip -c /backups/mysql_backup.gz Try it this way : /usr/bin/mysqldump --all-databases -u roo

mysqldump (in crontab) failing with 'errno 32' even though it worked last week

2007-12-04 Thread FMGreen
I use the mysqldump command (as below) in crontab to do a dump of my database each night. Up until last week this was working fine. Last week (when I was out of the office) there was a problem with the db and a colleague of mine had to do a manual dump. When he tried to run mysqldump (using the

Re: Maybe a bit OT: MySQL forum recommendation?

2007-12-04 Thread Chris Sansom
At 19:19 -0500 3/12/07, David T. Ashley wrote: You might check out vBulletin. They might waive the license fee if you ask nicely, or they may also have a policy when it is in support of open-source software. Hmmm - thanks for the suggestion, but this is strictly speaking a commercial site, a