Re: MySQL Replication

f the slaves switch to a "master" role when the master is unavailable. -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 http://www.otg-nc.com Phone: 877-258-8987/919-463-0999 Fax: 919-386-0158 -- MySQL General Mailing List For list

Re: Which Engine?

(where you may implement business logic). Assuming you stick with grant statements, it shouldn't be too difficult to maintain integrity when you want to do your "pseudo-transactions". Use InnoDB everywhere else. -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway,

Re: logging issue

see (for example, the mailscanner could be trying to connect to the wrong port on the server - the (110) makes me wonder if it's trying to connect to port 110). This would help diagnose a lot of those. -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisvill

Re: Problem installing MySQL 5.0

l it, then install MySQL - that would be the easiest course of action... -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 Phone: 877-258-8987/919-463-0999 http://www.otg-nc.com Francesco Vincenti wrote: Hello everybody, This is the first tim

Re: removing ibdata1 if some/all tables are not InnoDB?

simple matter of switching to 'tablespace per table', migrating the data to the individual tables (which would shrink the ibdata files), re-structuring the ibdata files (to use other partitions, etc.) an the moving the data back into the tablespace. Thanks -- Chander Ganesan Open T

Re: removing ibdata1 if some/all tables are not InnoDB?

27;d be best off doing an export, trash your InnoDB tables, and then import . -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 http://www.otg-nc.com Phone: 877-258-8987/919-463-0999 Fax: 919-386-0158 Expert MySQL Training Carl Brewer wrote: