Install Microsoft.Jet

Hi all, I have tried to import the excel to db , but i get the following error, The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. how can i install the Microsoft.Jet? System Info: OS Name Microsoft(R) Windows(R) Server 2003, Enterprise Edition for 64-Bit Itanium-based Sys

Re: Possible bug in mysqldump?

Thanks Rolando, I'm using InnoDB tables. According to the docs, the single-transaction option: Creates a consistent snapshot by dumping all tables in a single transaction. Works ONLY for tables stored in storage engines which suppor

RE: Possible bug in mysqldump?

This is an excerpt from http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html#option_mysqldump_master-data The --master-data option automatically turns off --lock-tables. It also turns on --lock-all-tables, unless --single-transaction also is specified, in which case, a global read lock is acqui

Re: Possible bug in mysqldump?

Thanks for the reply Rolando. In both the examples I provided (pipe and text file) the CHANGE MASTER command appears at the top of the data import and is uncommented and therefore executes before the data is imported. I don't think this is a problem because the slave only starts replicating from t

RE: Possible bug in mysqldump?

When you use --master-data=1, it executes the CHANGE MASTER command first before adding data. Do the following to verify this: Run 'mysqldump --single-transaction --master-data=1 -h... -u... -p... > DataDump1.sql Run 'mysqldump --single-transaction --master-data=2 -h... -u... -p... > DataDump2

Problems with sessions from Cicso CSM

Hi there, We've installed a MySQL NDB Cluster which is running fine. There are two Cisco CSM loadbalacer which shall distribute the workload over the query nodes. The loadbalancers also are doing TCP probes to the MySQL Ports (3306) on both querynodes. Each such probe generates a sessio

Re: Too many connections

you can do this set global max_connections=2500; On 8/5/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > Thanks a lot. > > Is there any way to increase the maximum no of connections without > restarting mysql server. > > On Tue, Aug 5, 2008 at 2:39 PM, Vladislav Vorobiev googlemai

Re: Too many connections

Thanks a lot. Is there any way to increase the maximum no of connections without restarting mysql server. On Tue, Aug 5, 2008 at 2:39 PM, Vladislav Vorobiev <[EMAIL PROTECTED] > wrote: > 2008/8/5 Krishna Chandra Prajapati <[EMAIL PROTECTED]>: > > Hi All, > > > > I am trying to connect to mysql

Re: Too many connections

2008/8/5 Krishna Chandra Prajapati <[EMAIL PROTECTED]>: > Hi All, > > I am trying to connect to mysql server. Buts, Its giving " too many > connections". How to increase the max_connection on mysql server. > > When i am giving mysql -u root -p > Still, its giving too many connections. > > How to s

Too many connections

Hi All, I am trying to connect to mysql server. Buts, Its giving " too many connections". How to increase the max_connection on mysql server. When i am giving mysql -u root -p Still, its giving too many connections. How to solve this problem. --Thanks Krishna Chandra Prajapati

Possible bug in mysqldump?

Hi all, I'm busy setting up replication and have encountered what looks like a bug in mysqldump. The following commands work perfectly: Running the following commands in the mysql client on the slave: stop slave; reset slave; create database dbName; CHANGE MASTER TO MASTER_HOST='masterHost', MAST