Re: MySQL Replication

2006-01-06 Thread Chander Ganesan
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 archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Which Engine?

2006-01-04 Thread Chander Ganesan
, 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, Suite 210 Morrisville, NC 27560 Phone: 877-258-8987/919-463-0999 http://www.otg-nc.com -- MySQL

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

2006-01-03 Thread Chander Ganesan
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 Technology Group, Inc. One Copley Parkway

Re: Problem installing MySQL 5.0

2006-01-03 Thread Chander Ganesan
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 time I try

Re: logging issue

2006-01-03 Thread Chander Ganesan
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 Morrisville, NC 27560 Phone: 877-258-8987/919-463

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

2006-01-02 Thread Chander Ganesan
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: Hello, I'm stuck