RE: Replication VS Cluster

Neil -- Neil Aggarwal, (281)846-8957 FREE trial: Wordpress VPS with unmetered bandwidth http://UnmeteredVPS.net/wordpress -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Can't drop index

Krishna: > Just check it up that any active transaction is still there in innodb > internal data dictionary. Acutally I figured it out. There was a constraint on that column as well. Once I dropped the constraint, I was able to drop the index. Thanks for the help, Neil -- Neil Ag

Can't drop index

x? Thanks, Neil -- Neil Aggarwal, (281)846-8957 MySQL pre-installed on a virtual private server for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

RE: Can't open file error number 24

> problem, Suddenly we noticed an error stating " Can't open file error > number 24". If I recall correctly, error 24 means the disk partition is full. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net MySQL pre-installed on a virtual private server

RE: mysql load balancing

rs) to talk to either database in case one fails. That is not necessary but it adds a extra layer of proctection. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS virtual server for $25/mo Unmetered bandwidth = no overage charges, 7 day free

RE: Help Save MySQL

y owns it. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS virtual server for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: CSV pain and suffering with punctuation and non-ASCII characters

I don't know if there is an off the shelf tool to do what you want. Maybe someone has one. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS virtual server for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQ

RE: How to not lock anything?

be faster to clear the table, insert your data, and then put the indexes back. Try those to see if they help. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS virtual server for $25/mo Unmetered bandwidth = no overage charges, 7 day free tr

RE: How to not lock anything?

you should go with it. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS virtual server for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: Help saving MySQL

all amount of the worldwide earnings from on the product he created. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For li

RE: Help saving MySQL

do to hurt MySQL? I am not against what Micheal is proposing. I already sent my letter to the EC. I am asking this for my own edification. Thanks, Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no o

RE: Missing Entries

would do that firt, but it is good to be clear. Thanks, Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http

RE: Missing Entries

delete from user where Password=''; flush privileges; quit; It removes those accounts. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL

RE: Select from remote server from stored procedure

he remote database 2. Tell the remote server to create a binary log 3. Tell the local server to be a slave of the remote 4. Start the slave It should take less than 1 hour to set it up. I have done it many times. It is probably not as hard as you are thinking it will be. Neil

RE: Join on a where clause.

Joerg: > A matching column is called an "equijoin" > However, that is not mandatory / the only form. > As long as the problem can be solved using ranges (or multiple ranges) > which do not overlap, the join should solve it. I just learned something. Thanks for the info!

RE: Select from remote server from stored procedure

an/5.0/en/federated-use.html Once you do that, you are accessing it like a local table. I hope this helps. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQ

RE: Join on a where clause.

That is not the case for you. I think you are going to have to do this in your application code. I hope this helps, Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial

RE: Innodb buffer pool size filling up

u see any more info in the logs? Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

RE: MySQL On ipv6

Pramod: > I want to know whether MySQL Server runs on ipv6 machine. Apparently, IPv6 is going to be a version 6 feature: http://bugs.mysql.com/bug.php?id=8836 Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL driven app on a CentOS VPS for $25/mo Unmete

RE: Is a view efficient in joins?

the summary table is actually a good one in > many instances, > especially if it's not vital that it contain the most up-to-date data. I think I will go that direction. It will be OK for the summary data to be delayed by a short interval. Thanks, Neil -- Neil Aggarw

Is a view efficient in joins?

-- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL driven app on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

RE: How to concatenate a constant to an int?

pect p on c.contact_id = p.prospect_id left join client l on p.prospect_id = l.client_id Any ideas how to do this? Thanks Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host Joomla!, Wordpress, phpBB, or vBulletin for $25/mo Unmetered bandwidth = no overage charges, 7

How to concatenate a constant to an int?

Hello: This seems like it should be simple, but I am having trouble figuring it out. I have a table contact which has: nameString contact_id int Lets assume the contact table has this row: name: Neil Aggarwal contact_id: 1 I want to create a

RE: mysql not able to import mysqldump file

Martin: Both tables have double for the column. Neil -- Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com Eliminate junk email and reclaim your inbox. Visit http://www.spammilter.com for details. > -Original Message- > From: Martin Gainty [mailto:mgai...@hotma

RE: mysql not able to import mysqldump file

Double.MAX_VALUE constant over JDBC. There should not be this inconsistency between what mysqldump creates and what the server can handle since the platform and version are exactly the same. Having said that, there is an easy fix so it is not a big deal. Thanks, Neil -- Neil Aggarwal

mysql not able to import mysqldump file

am getting this error: Illegal double '1.79769313486232e+308' value found during parsing Any ideas how to fix this? Thanks, Neil -- Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com Eliminate junk email and reclaim your inbox. Visit http://www.spammilter.com for details.

C-JDBC (Was RE: Has anyone heard of SafeKit?)

avoid that being a single point of failure. I am more interested in a homogenous MySQL environment instead of a heterogenous one. If you have any insights into potential probles with their approach, I would really like to hear them. Thanks, Neil -- Neil Aggarwal, JAMM Consulting, (972)612

Has anyone heard of SafeKit?

Hello: According to this company: http://www.evidian.com/safekit/index.htm They have a way to create a cluster out of two distinct machines running MySQL. Has anyone heard of this? Has anyone used it? Is it just pure marketing hype? Thanks, Neil -- Neil Aggarwal, JAMM Consulting, (972

Password problem

| newsletter | newsletter | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Any ideas? Thanks, Neil. -- Neil Aggarwal JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com Custom Internet Development

Problem installing 3.23.43 (@HOSTNAME@ command not found)

, Neil. -- Neil Aggarwal JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com Custom Internet DevelopmentWebsites, Ecommerce, Java, databases - Before posting, please check: http://www.mysql.com

Starting value for an auto increment column?

Hello: Is there a way to specify a starting value for an auto increment column? I tried this: id INTEGER DEFAULT 1001 PRIMARY KEY AUTO_INCREMENT But, that did not work. Thanks, Neil. -- Neil Aggarwal JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com