Re: which mysql 64 bit binary for PowerEdge 1950 ?

2009-11-09 Thread Sanjeev Sagar
Is there anyone, who is using the mysql 64 bit on Intel(R) Xeon(R) CPU processors? Will it be *IntelEM64T* ? Regards, Sanjeev Sagar wrote: Hello Everyone, I would like to verify that which mysql 64 bit binary i need to use for PowerEdge 1950 ? Will it be *IntelEM64T* ? Following is the

which mysql 64 bit binary for PowerEdge 1950 ?

2009-10-30 Thread Sanjeev Sagar
Hello Everyone, I would like to verify that which mysql 64 bit binary i need to use for PowerEdge 1950 ? Will it be *IntelEM64T* ? Following is the cpu info Processor 1 Processor Brand: Intel(R) Xeon(R) CPU E5310 @ 1.60GHz Processor Version : Model 15 Stepping

RE: Problems with replication restarting

2004-12-20 Thread Sanjeev Sagar
First of all MySQL replication do not mismatch position in simply starting and stopping the slave as long as you have all relay and info files. Secondly, change master recreates the master.info file. Third...one can implement the log_position table on slave inserting a record every minute to rec

RE: Load data question in cross database replication

2004-12-09 Thread Sanjeev Sagar
ewrite-db is not taken into account while executing LOAD > DATA > FROM MASTER. See: > http://dev.mysql.com/doc/mysql/en/LOAD_DATA_FROM_MASTER.html > > > > "Sanjeev Sagar" <[EMAIL PROTECTED]> wrote: > > > --=20 > For technical suppor

Master_log_pos in replication

2004-12-06 Thread Sanjeev Sagar
Hello All, I am having problem in finding out the exact position in master bin log file in replication setup for point-in-time recovery process. Let me explain the problem in detail. I have log_position table on all slaves, see the definition below Table: log_position Create Tab

RE: Load data question in cross database replication

2004-12-06 Thread Sanjeev Sagar
/LOAD_DATA_FROM_MASTER.html "Sanjeev Sagar" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /

Load data question in cross database replication

2004-12-02 Thread Sanjeev Sagar
Hello Everyone, I have a question on using LOAD DATA command in cross database replication setup. MySQL version is 4.0.21 I have replication farm where few slaves have been set up as cross database replication slave by using (replicate-rewrite-db). When Load data command get executed on

Binlog question in replication setup

2004-12-02 Thread Sanjeev Sagar
Hello everyone, I have a question on how MySQL database write to binlogs in replication environment. My table type is MyISAM. MySQL version is 4.0.21. I have a replication farm. Let's suppose I am running a ALTER TABLE statement on central master and had a syntax error in table name. Replic

RE: how to connect to MyDBPAL from MySQL

2004-11-23 Thread Sanjeev Sagar
connection is going through. -Original Message- From: Sanjeev Sagar [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 23, 2004 3:55 PM To: Victor Pendleton Cc: [EMAIL PROTECTED] Subject: RE: how to connect to MyDBPAL from MySQL YES ODBC work perfect. I am using same data source for MySQL

RE: how to connect to MyDBPAL from MySQL

2004-11-23 Thread Sanjeev Sagar
: Tuesday, November 23, 2004 3:32 PM To: Sanjeev Sagar Cc: [EMAIL PROTECTED] Subject: Re: how to connect to MyDBPAL from MySQL Are there any MySQL errors being logged? Did you confirm that the ODBC connection is working? Sanjeev Sagar wrote: >I have seen mails talking about MydbPAL. I downloaded

how to connect to MyDBPAL from MySQL

2004-11-23 Thread Sanjeev Sagar
I have seen mails talking about MydbPAL. I downloaded it and I have MySQL ODBC data source too but not able to connect to MydbPal at all. I have tested my odbc data source, it work just fine. My machine is having Linux and Windows through vmvare workstation. I installed dbpal on windows and try to

RE: Change master on replication

2004-10-22 Thread Sanjeev Sagar
Master A has Slave 1 and Slave 2 Master B has Slave 3 and Slave 4 Master A is ahead of Master B, and Master A goes down, we want to repoint Slave 3 and Slave 4 to Master B. Since the data is large, we don't want to do a fresh resync of Slave 3 and 4 from scratch. And A and B may not have be

RE: Ignore a single query in replication

2004-10-21 Thread Sanjeev Sagar
Try SET SQL_LOG_BIN=0 before you run your queires on master. This will be valid for that connection only. -Original Message- From: Gary Richardson [mailto:[EMAIL PROTECTED] Sent: Thu 10/21/2004 11:24 AM To: Mysql General (E-mail) Subject: Ignore a single query in replication Hey, Is

how to use mysql client source command through DBI/DBD

2004-10-18 Thread Sanjeev Sagar
Hello All, I am trying to create a perl DBI/DBD script for creating a database initial build. My input is a extract file, which is a mysqldump result file with --opt and -B option. I am using DBIx::DWIW. I am able to open a successful database handler. I am having code like my $dropsql="DR

empty user catalog entry for user column

2004-09-22 Thread Sanjeev Sagar
Hello All, For a new build I am seeing that mysql_install_db is putting entries in user table where user="" in addition to the correct entries for root. See below mysql> select * from user where user=""; +-+--+--+-+-+-+-

RE: Installing DBIx::DWIW on CPAN

2004-09-15 Thread Sanjeev Sagar
9/15/2004 1:18 PM To: Sanjeev Sagar Cc: [EMAIL PROTECTED] Subject: Re: Installing DBIx::DWIW on CPAN On Wed, Sep 15, 2004 at 01:10:35PM -0700, Sanjeev Sagar wrote: > I am trying on cpan.yahoo.com and it's giving me following error > > The requested URL /authors/id/J/JZ/JZAWODNY/DB

RE: Installing DBIx::DWIW on CPAN

2004-09-15 Thread Sanjeev Sagar
I am trying on cpan.yahoo.com and it's giving me following error The requested URL /authors/id/J/JZ/JZAWODNY/DBIx-DWIW-0.41.tar.gz was not found on this server. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Wed 9/15/2004 1:05 PM To: Sanjeev Sagar Cc: [

Installing DBIx::DWIW on CPAN

2004-09-15 Thread Sanjeev Sagar
Hello All, I am trying to install DBIx::DWIW but giving me following error. No such file `DBIx-DWIW-0.41.tar.gz' I am trying to install from CPAN cpan> install DBIx::DWIW Could not fetch authors/id/J/JZ/JZAWODNY/DBIx-DWIW-0.41.tar.gz Giving up on '/root/.cpan/sources/authors/id/J/JZ/JZAWODNY

RE: Local Master replication issue

2004-09-10 Thread Sanjeev Sagar
--log-slave-updates did the job. Regards, -Original Message- From: Sanjeev Sagar [mailto:[EMAIL PROTECTED] Sent: Fri 9/10/2004 3:36 PM To: [EMAIL PROTECTED] Subject: Local Master replication issue Hello All, I am seeing a small problem in Ring replication where one slave is acting as

Local Master replication issue

2004-09-10 Thread Sanjeev Sagar
Hello All, I am seeing a small problem in Ring replication where one slave is acting as Local Master. See below M - Super Master S1/LM1 - Slave of super Master and act as Local Master for S2 S2 - slave of LM1 I ran one Insert on M, it showd up on S1/LM1 but it did not showed up in S2. What I c

RE: Multiple MysQL servers with different IP address on same machine

2004-09-09 Thread Sanjeev Sagar
: Thu 9/9/2004 9:51 AM To: [EMAIL PROTECTED]; Sanjeev Sagar Cc: [EMAIL PROTECTED]; Sanjeev Sagar Subject: RE: Multiple MysQL servers with different IP address on same machine Hi We have a machine with 2 IP addresses and mysql 3.23 on one and 4.10 on the other. Both using port 3306 One instance

Multiple MysQL servers with different IP address on same machine

2004-09-08 Thread Sanjeev Sagar
Hello All, MySQL : Standar Binary 4.0.20 O/S : Red Hat Linux release 9 (Shrike) Linux 2.4.20-31.9smp #1 SMP Tue Apr 13 17:40:10 EDT 2004 i686 i686 i386 GNU/Linux I already have setup of Three Multiple MySQL servers listening on different ports and sockets on same machine Option File: [mysqld