Unsubscribing my sql mailing list

Dear Sirs, I'd like to unsubscribe my subscription to this mailing list. Thank you so much. Regards Andrea Fanni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

multiple instances in win 7 -- any idea

I'm trying to install multiple instances of mysql on windows 7, 64bit. 3hrs into the job, I'm not making progress. Does anyone have an idea? This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and C

Re: InnoDB and Memory Allocation

or increase the percentage (via /proc/sys/vm/overcommit_ratio, which isn't as well-known, though it is in the kernel documentation). Hope that helps. Charles -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

RE: Myisam won't support replication in an MySQL Cluster environment

Hello Mr Reindl, Interestingly, over the years, I've been reading your postings and threads - without a doubt you're a major contributor. You've been very resourceful and helpful to your peers. We may never know what caused you to violently snap this time. However, I would encourage you to co

Myisam won't support replication in an MySQL Cluster environment

Does anyone have idea or experienced in MySQL Cluster configured for bi-directional replication. Please advise me if you have to use NDBcluster engine in order to get replication between the data nodes. I'm using MYISAM on several tables that will not replicate. ***

Myisam won't support replication in an MySQL Cluster environment

Does anyone have idea or experienced in MySQL Cluster configured for bi-directional replication. Please advise me if you have to use NDBcluster engine in order to get replication between the data nodes. I'm using MYISAM on several tables that will not replicate. ***

Myisam won't support replication

I noticed that my replication stopped working after migrating to MySQL cluster. My current engine is myisam. Does anyone have an idea why repl won't work. Do I have to use the ndbengine? This message is intended only for the use of the Addressee and

Re: mixing and matching mysql & mssql whileloop within an if case

Sent from my iPhone On May 3, 2012, at 1:02 PM, "Haluk Karamete" wrote: > Please take a look at the following code and tell me if there is a way > around it. > > if ($current_server_is_mysql): >while ($row = mysql_fetch_assoc($RS)) { > else: >while( $row = sqlsrv_fetch_array( $RS, SQL

master BIN-LOG maintenace

Hi Gurus, I would like to set BIN-LOG maintenance procedure for my master. The master is on a windows platform. I’m all for make it simple and clean therefore I’ve been leaning toward the automatic BIN-LOG removal “expire-logs-days=7”. The problem is for this option to work, it should be pre

RE: using the bin-log approach on the master side, how can I accomplish my replication objectives

Hello Nitin, Please give Nitin a prize. What a quiet genius she is. Now, I get it. Now, I can see clearly. I’ve tried it and it worked. Thanks so much. From: Nitin Mehta [mailto:ntn...@yahoo.com] Sent: Wednesday, May 02, 2012 11:25 PM To: Brown, Charles Cc: mysql@lists.mysql.com Subject: Re

using the bin-log approach on the master side, how can I accomplish my replication objectives

Hello Rick, I think I'll go with your recommendations - but help me here a little bit. Because all look fuzzy like a brain surgery. So make it simple and clean for me. For the sake of simplicity, here is what my master has: Database: db1 Tables: db1tb1, db1tb2, db1tb3 Database: db2 Table

RE: Can the mysql replication limited to one database

Hello Rick, What goes into your my.cnf slave ? Given dbname1 and dbname2 -Original Message- From: Rick James [mailto:rja...@yahoo-inc.com] Sent: Wednesday, May 02, 2012 12:05 PM To: Brown, Charles Cc: mysql@lists.mysql.com Subject: RE: Can the mysql replication limited to one

Re: engine is now innoDB instead of MyISAM.

Well said. Thanks so much. Sent from my iPhone On Apr 29, 2012, at 8:02 AM, "Reindl Harald" wrote: > > > Am 29.04.2012 14:50, schrieb Brown: >> is a complain I received from one of my developer that after following our >> MySQL >> Cluster migration, tables are now defaulting to innodb (how

RE: engine is now innoDB instead of MyISAM.

are parameters that have sustain me over the years. Now, I'm doing MySql Cluster are they any more relevant. Best regards, From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: Sunday, April 29, 2012 4:29 AM To: Brown, Charles Cc: mysql@lists.mysql.com Subject: Re: engine is now

RE: engine is now innoDB instead of MyISAM.

The question is, is it advisable to change the default engine of a cluster setting to Myisam? Does anyone have an opinion or experience on this issue? Do I have choice when it comes to clustering on which type engine supports clustering. Thanks -Original Message- From: Reindl Harald

engine is now innoDB instead of MyISAM.

Hello all, We recently switched from MySQL community to Mysql clustered using Oracle supported MySQl. The problem is, during our testing phase, we observed the default engine is now innoDB instead of MyISAM. Any thoughts on that? We're not getting the performance that we expected - any thoughts

RE: One inst has 39 columns- the other 40

Thanks all -- it was a version problem. My sysprog person is going to re down load from Oracle. Thanks again for all the wonderful help. -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Thursday, March 22, 2012 4:25 AM To: mysql@lists.mysql.com Subject: Re: O

RE: One inst has 39 columns- the other 40

Look man, there has to be someone out there that can tell me why one user table has 5 extra columns. Is it version related or my sysprog person missed out on a step. Its hard to believe that this problem is unique to my site. Hostchar(60)NO PRI Userchar(16)NO

tables do not have the same number of columns.

I have two mysql instances in my mysql cluster. I noticed that their MysSQL.user tables do not have the same number of columns. See below for their attributes. Is anyone out there has any idea why these tables are not the same? Can someone help me. Hostchar(60)NO

RE: One inst has 39 columns- the other 40

I have two mysql instances in my mysql cluster. I noticed that their MysSQL.user tables do not have the same number of columns. Their USER table attributes are not the same. One instance has 39 columns while the other has 42 columns. Can someone please help me here. Could it be because I'm runn

One inst has 39 columns- the other 40

I have two mysql instances in my mysql cluster. I noticed that their MysSQL.user tables do not have the same number of columns. Their USER table attributes are not the same. One instance has 39 columns while the other has 42 columns. Can someone please help me here. Could it be because I'm runni

One inst has 39 columns- the other 40

I have two mysql instances in my mysql cluster. I noticed that their MysSQL.user tables do not have the same number of columns. Their USER table attributes are not the same. One instance has 39 columns while the other has 42 columns. Can someone please help me here. Could it be because I'm runni

RE: how to sync mysql.user table between to two mysql instances

Hello johan Here is what did the trick for me: 1. in mysql-inst1, I created like table called test.user 2. I used mysqldump to pipe test.user table from mysql-inst1 to mysql-inst2 3. in mysql-inst2, I did insert into mysql.user select from test.user We are migrating from master-slave replication

RE: how to sync mysql.user table between to two mysql instances

dious. Help me I'm running out of time. -Original Message- From: David Lerer [mailto:dle...@us.univision.com] Sent: Friday, March 16, 2012 1:36 PM To: Baron Schwartz; MySql; Brown, Charles Subject: RE: how to sync mysql.user table between to two mysql instances As a follow up ques

how to sync mysql.user table between to two mysql instances

Can someone instruct me on how to sync mysql.user table between to two mysql instances. In other words, I wouild like to copy mysql.user from mysql-inst1 to mysql-inst2 + Thanks This message is intended only for the use of the Addressee and may con

RE: need help with -- unknown variable

t for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid From: Andrew Moore [mailto:eroomy...@gmail.com] Sent: Monday, June 13, 2011 11:13 AM To: Brown, Charles Cc: mysql@lists.mysq

need help with -- unknown variable

Hello All ~ I attempted to do a mysqldump when I got this message -- see below: mysqldump: unknown variable 'datadir=/var/lib/mysql' Please can someone help me. Thanks This message is intended only for the use of the Addressee and may contain in

RE: high load averages on mysql server ...

Hello All ~ I'm experiencing some high load averages on mysql server between the hrs 9am - noon. We don't have the MySQL optimal performance monitor. I'm wondering whether if there's a log or an area that I should be looking at to get an idea of what the problem going on with MySQL. Thanks

high load averages on mysql server ...

Hello All ~ I'm experiencing some high load averages on mysql server between the hrs 9am - noon. We don't have the MySQL optimal performance monitor. I'm wondering whether if there's a log or an area that I should be looking at to get an idea of what the problem going on with MySQL. Thanks

mysqld_safe

Hello All. when I issued this command: ps -e | grep, I noticed that mysqld_safe was up running in my system. My question is: what is mysqld_safe and why was it running. Please help. [sp...@naxbmisq03 ~]$ ps -e | grep -i mysql 11989 ?00:00:00 mysqld_safe 12025 ?13:28:39 mysqld

host variables

Can someone help me. I am trying to make calls to Mysql from VBscript via ASP But I'm experiencing difficulties with passing host variables to mysql See examples below isbn =34373 sql= "select isbn, book_title, publisher_name FROM cs443.books_available where isbn= " &isbn The above works but

with passing host variables to mySQL

Can someone help me. I am trying to make calls to Mysql from VBscript via= =20ASP But I'm experiencing difficulties with passing host variables to my SQL=20 See example below isbn =3D 717192=20 sql=3D "select isbn, book_title, publisher_name FROM cs443.books_availabl= e where isbn=3D " &isbn

RE: cannot find my.cnf file

Please look in /etc/my.cnf If not found create one. Of cause, MySQL can start and run without a 'my.cnf' file that’s why you couldn't find one. In the absence of the my.cnf file, MySQL will use default for every parameter . Charles, -Original Message- Fro

RE: socket '/tmp/mysql.sock' (2)

From: Brown, Charles Sent: Tuesday, November 03, 2009 2:54 PM To: Ramsey, Robert L; mysql@lists.mysql.com Subject: socket '/tmp/mysql.sock' (2) Hello All, I desperately need your help. I migrated from version 5.0.27 To version 5.0.77 H

socket '/tmp/mysql.sock' (2)

Hello All, I desperately need your help. I migrated from version 5.0.27 To version 5.0.77 Here is the command I used to migrate my databases: mysqldump -ux -px --all-databases --master-data | mysql -h88.88.89.889 -ur -px Problem: after the migration, I have been getting t

RE: MYSQL slow query log in table.

Jaime Crespo Rincón [mailto:jcre...@warp.es] Sent: Thursday, October 08, 2009 10:17 AM To: Brown, Charles Cc: Daevid Vincent; mysql@lists.mysql.com Subject: Re: MYSQL slow query log in table. 2009/10/7 Brown, Charles : > Hello All. I would like to implement  MYSQL slow query log in table. Can &

MYSQL slow query log in table.

Hello All. I would like to implement MYSQL slow query log in table. Can someone kindly assist me with the table definition and implementation. Thanks so much in advance This message is intended only for the use of the Addressee and may contain inf

Questions on un-index searches and slow-query-log

Questions Folks: (1) What do you about un-index searches. How can one report and monitor them? (2) What do you do with the slow-query log. Are there any utilities or scripts out there to filter and manage this log? Thanks This message is intended

Re: Patch for mysql

what patch this might be), I'd avoid this method of getting things done -- Colin Charles, http://bytebot.net/blog/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Failed to initialize the master info structure

Can someone tell me why I am getting this message whenever I issued a "CHANGE MASTER" command? @4000489f38462d0bedd4 080810 13:49:32 [ERROR] Failed to initialize the master info structure Thanks This message is intended only for the use of the Add

RE: can some please help me -- REPLICATION

Here is what I'm getting mysql> change master to master_host = 'naxbmisq01.bmi.com', master_user = 'repl', master_password = 'repl'; ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log mysql> reset slave; Query OK, 0 rows affecte

RE: can some please help me -- REPLICATION

Re: You can tell mysql to not keep relay logs that have already been used. What command does this -Original Message- From: David Giragosian [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION On

can some please help me -- REPLICATION

The background: We are doing replication. The file-system containing the SLAVE's relay-log got filled to capacity. Later on, I noticed replication has not been working for the last month or more. My Action: I deleted the 2 oldest relay-log then attempted to restart SLAVE. Now, the SLAVE will not

Could not initialize master info structure;

Could not initialize master info structure; Can someone help me. I am getting the above message This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended re

relay-bin.000157' not found

Please advise me on how to restart MYSQL slave instance. All efforts have failed. When I issued the "START SLAVE" command it came back with an error -- see below. ERROR 29 (HY000): File './naxbmisq02-relay-bin.000157' not found (Errcode: 2 I inadvertently deleted this file. Tha

How to know the maximum length of a field

d create a Perl script to do it, but I wonder if there's a mySQL command which does it automatically. Thank you very much, --Charles

Re: Optimizing table (shall I create a primary field?)

values for "key_len" parameter when doing EXPLAIN? Regards, --Charles ISBN field is way too long, I think they just changed it to 13 characters. > Depending on your application leading '0' may be important so you may be > stuck with a character field. As was suggeste

Re: Migration from 32-bit to 64-bit MySQL

e any longer kind regards -- Colin Charles, Community Relations Manager, APAC Database Group, Sun Microsystems Inc., http://www.mysql.com/ Tel: +6012 204 3201 (Malaysia) | colincharles (Skype) Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing

Re: Migration from 32-bit to 64-bit MySQL

32-bit and 64-bit? Is this a good idea? Can it be done? What would make this go wrong? Addressing more RAM currently is your only gain... On a 32-bit system, you tend to only have 2.5-2.7GB of RAM available to MySQL (your OS needs the remainder) Kind Regards -- Colin Charles

Re: Optimizing table (shall I create a primary field?)

type=const possible_keys=PRIMARY key=PRIMARY key_len=302 ref=const rows=1 Extra= -- Regards, --Charles On 4/27/08, Rob Wultsch <[EMAIL PROTECTED]> wrote: > > On Sun, Apr 27, 2008 at 3:59 AM, Charles Lambach > <[EMAIL PROTECTED]> wrote: > > I do _always_

Optimizing table (shall I create a primary field?)

Hi. My hosting provider recommended me to optimize my 200,000 record table in order to save resources. I do _always_ this query: SELECT * FROM books WHERE isbn='foo' LIMIT 1 The primary key of this table was 'id', and 'isbn' was and INDEX field. I've modified this: ALTER TABLE books DROP PRIMAR

'mysql.servers' doesn't exist

Hey Folks. I'm getting this error -- I need your input or help. 080320 15:02:16 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 080320 15:02:16 [Note] Event Scheduler: Loaded 0 events 080320 15:02:16 [Note] E:\Apps\Standard\HPRUM\MYSQL\bin\mysqld: ready for con

Security overrides in mysql.cnf

I inherited a mysql server database. Stuff are not documented. My question is: Are there any security work-arounds in mysql. I have access to the cnf file. I need to get in and dump the database. I was told that the cnf file allows security over rides. Please help I have tried mysql -uroot. It

Are user privileges included in MYSQLDUMP

Using mysqldump, I'm about to dump all databases and import to another instance - new . My question is do I need to define all security and users in the new mysql or the security definitions and privileges will be included in the dump file created by mysqldump. What is the function of mysql_fix_p

RE: mysql privileges

Here is a follow-up question: Using mysqldump, I'm about to dump all databases and import to another instance - new . My question is do I need to define all security and users in the new mysql or the security definitions and privileges will be included in the dump file created by mysqldump. Pl

If I downgrade MySQL from ver-5 to ver-4.

Hello. Can someone tell me if I will run into any problems? 1. If I downgrade MySQL from ver-5 to ver-4. 2. If I run replication between version 4 and version 5 of the software. Meaning slave is version 4 and the master is version 5. Some back ground: We have replication implemented. Currently,

show slave status

ail saying replication is in error. Charles This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any disseminat

RE: executing query from the command line -- need help

thanks -Original Message- From: obed [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 23, 2008 10:49 PM To: Jay Blanchard Cc: Brown, Charles; mysql@lists.mysql.com Subject: Re: executing query from the command line -- need help On Jan 23, 2008 2:36 PM, Jay Blanchard <[EMAIL PROTEC

executing query from the command line -- need help

Hello All. I'm new to mysql. I would like to issue a query from the command line and pass the result to an update done on the command line within the same script. See below. My question is how can I run a select from the command line and pass the values to an update SELECT SYS_ID, SYS_LOCATION,

Inter-version client/server compatibility

. If the mixed-version set-up is not OK, I have a more challenging task. I have to keep the clients and servers in step. P.S. I am more familiar with Oracle than with MySQL. I know that an Oracle 10 client can be used with with servers going back at least to Oracle 8. -- Charles Jardine

NFS

why I should not do as I plan? -- Charles Jardine - Computing Service, University of Cambridge [EMAIL PROTECTED]Tel: +44 1223 334506, Fax: +44 1223 334679 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql error

Hello all. I noticed that the last entry in mysql error log was two weeks ago. Can some one tell me why mysql is not writing to this log This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONF

max_connect_errors

Hello, Does MySQL store a current error count (for each host?) internally that I can enquire on? I did not find this information in the MySQL manual. If the current error count is available, so that I can monitor it for specific hosts and issue a alert when it crosses a threshold. Please help! Th

Show command for max_connection_errors. Any ?

Hello All. Is there a way to monitor the max_connection_errors. I'm asking because we had a problem the other day in MYSQL when slowed down and stopped accepting connections from one of the boxes. To resolve this problem, I issued FLUSH HOST and the problem went away. Is there a SHOW command that

General Query Log -- No Timestamp

The MYSQL general query log does not include timestamp of queries that it logs because queries are logged many many seconds before they are executed. Can someone help me associated queries found in the query log with wall clock? I am trying to get a list of queries that were executed within a give

Endianness

file formats are independent of endianness, so they can be copied between the two environments, and which are not. The categories of file I am interested in include: * MyISAM files * InnoDB files * Binary logs * mysqldump output -- Charles Jardine - Computing Service, University of Cambridge

batch mode

Because I am running on batch mode therefore I'm trying to direct my session output to a file -- meaning stdout. But I'm having a problem. For instance this input: "use test_db" gave me no output but this input "show tables" gave me an output. What is missing, what's the trick. Help me Y'all. Th

an't connect to local MySQL -- Help me!

I am getting this message from mysql. We had our binlog directory full. What is the resolution? Error 2002 (HY000) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) This message is intended only for the use of the Addressee and

My bin.log directory is getting full

Hello All. My bin.log directory is getting full with bin.log files. We are running out of space. What can I do in the short term? Is there a command that I can issue that will get rid of old bin log files not needed? This message is intended only for th

IBM, MySQL team up on database software

IBM, MySQL team up on database software BOSTON (Reuters) - International Business Machines Corp. plans to start selling products from smaller rival MySQL AB, a developer of an open-source database that is used to help run Web sites, Executives at IBM, the world's No. 2 software maker, and MySQL

RE: Stopping Replication

7;scratch'. Thanks -Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 24, 2007 4:26 PM To: Brown, Charles; Michael Dykman; Gerald L. Clark Cc: MySQL List Subject: Re: Stopping Replication Thanks, I've removed these files. Also, there are a BUN

RE: Stopping Replication

(Read ref manual: 6.4) Here's the best kept secret: The Slave has two files called master. info and relay-log.info. The slave uses these two files to keep track of how much of the master's binary log it has processed and all pertinent info about the master( i.e userid, password, hostname) are all

RE: Querying large table

Just for heck of it, I did a Big-O-notation for its efficiency -- as you predicted, it will take longer. I also factored-in the SORT required by the 'GROUP BY' -- say there are 64,000 categories therefore mysql may have to do 64,000 SORTs -- that's not cheap. My gut feelings are its doing a T/B

information_schema not found

Hi all. I just finished installing mysql on a new server. I noticed that database information_schema wasn't found. Can someone help me. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFI

Database replication -- switch role

Hello All. We have replication setup thus:- Master A --> Slave B. Now, the data center will like to implement ca-unicenter on server-A and do some testings for automation purpose. You've guessed it, Mysql-A will be up-and-down for the next couple weeks. To provide business continuity, I have be

a Linux -csh script to refresh test with production

Hello all. Does anyone out there (in mysql world) have a Linux -csh script to refresh test with production data. My developers would like their test database to be refreshed nightly with production data. The production and test mysql servers do not run in the same box. They run on different box

Re: Availability of 5.1 as production release ?

Q3/Q4 this year, I believe -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Ekiga/Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Users Conference: http://www.mysqluc.com/ -- MySQL General Mailing List For list archives:

RE: function based index

Hello Dan. Try it and see if you can: mysql> create index indx101 on tab101(min(c1),c2) ; Answer: Its not supported. -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 13, 2007 9:10 AM To: Ananda Kumar Cc: mysql@lists.mysql.com Subject: Re: function base

Re: incompatible libmysqld.a

is a problem. It compiles with glibc v2.5 on Fedora Core 6 This computer is a laptop Acer Aspire 5633WLMi, Intel Core Duo processor. Can you file a bug report at bugs.mysql.com? thanks -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12

copy data from prod to test - when database name is not the same name

Hello All, We have two mysql environment PROD and TEST. I would like to copy data from PROD to TEST. The PROD database name is Mysql_prod and the TEST database name is mysql_TEST. Using mysqldump or any applicable utility can someone show me how to migrate my production data from prod to test. Th

Re: incompatible libmysqld.a

lease provide more details. Also, what version of gcc is this? thanks -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing

Re: mysql_upgrade shows errors

Yves Goergen wrote: On 14.02.2007 08:00 CE(S)T, Colin Charles wrote: The MySQL 5.0 release is available as a binary and is currently at 5.0.27. Grab it at: http://dev.mysql.com/downloads/mysql/5.0.html#downloads I read in the news some time ago that MySQL 5.0 is only going to be available as

Re: Error MYI 1016 - damaged database table

mmand, which is part of the MySQL installation, can be executed on the server when the database server is no longer running: myisamchk /path/to/database/directory/.MYI Dans quel fichier devrais-je intervenir? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mob

Re: Setting up multiple daemons

might consider reading: http://dev.mysql.com/doc/refman/5.0/en/multiple-unix-servers.html There is also documentation if you wanted to do this on Windows -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http

Re: mysql_upgrade shows errors

a apt-get? Debian has very sensible packaging, and its currently at version 5.0.32 afaik What do the above error messages mean? The upgrade script picked up on the fact that you had duplicate column names -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, ww

Re: Repairing a table

me usually (Falcon is meant to fix this)... Do you know why the disk is filling up so fast? What MySQL version is this? And how much *actual* free space do you have? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles

max mysql under windows

Hello All. Is it possible to setup two instances of MySQL under windows? I am wondering because I would like to setup and test replication Thanks Charles This message is intended only for the use of the Addressee and may contain

MYSQL under windows -- Max number of instances

Hello All. Is it possible to setup two instances of MySQL under windows? I am wondering because I would like to setup and test replication Thanks Charles This message is intended only for the use of the Addressee and may contain information that

MYSQL on windows -- Max number

Hello All. Is it possible to setup two instances of MySQL under windows? I am wondering because I would like to setup and test replication Thanks Charles This message is intended only for the use of the Addressee and may contain information that

RE: Replication & LOAD DATA INFILE

During Replication the SLAVE reads data from its MASTER's log. Chances are LOAD DATA gets no logging -- I won't be surprised. -Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Friday, February 02, 2007 9:44 AM To: MySQL List Subject: Replication & LOAD DATA INFILE I've just

RE: Questions about delete and optimize

Re: I can't say that I've tried this, It works like a champ we do every day in Oracle, DB2 and MySQL. It takes less time because you're bypassing logging thus reduce I/O and locking, etc. -Original Message- From: Jerry Schwartz [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 20

RE: Password hash should be a 41-digit hexadecimal number

Try this: GRANT USAGE ON *.* TO 'openpne'@'locahost' IDENTIFIED BY 'openpne' ; Or try this: create user 'openpne'@'localhost' identified by password 'openpne'; - Spell domain correctly - there was a typo - put quote around userid and domain -Original Message- From:

RE: WHERE (NOT) EXISTS problem

Hello Michael. Here is the query you wanted - you were almost there. SELECT DISTINCT NAME FROM PEOPLE WHERE ID IN (SELECT PID FROM PEOPLE_CITY_MAP WHERE CID = 1) Thanks. -Original Message- From: Michael Fischer [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 11:53

RE: Database Layout (Design) Question

Hello, I think your major contributing problem is the database engine that you are using, MYISAM. For this type of processing, I would highly recommend you use INNODB to allow maximum concurrency and minimize your outage. With all things considered, your processing by all estimates, whether you a

Re: Log Warnings Level

ted connections -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: yum version 5.*

at is currently released -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Please help*

://dev.mysql.com/doc/refman/5.0/en/installing-source.html -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives

Re: mysqld_safe failing

server can't access /var/run/mysqld I suggest making sure the permissions are correct (using chown will fix it) -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge:

Re: Log Warnings Level

documentation there is on this? What kind of additional information are you looking about the --W (or --log-warnings=N) option? I'd pay attention to aborted connections, as MySQL Network's monitoring service actually does do so kind regards -- Colin Charles, Community Enginee

Re: MySQL Administrator problem

Ed Reed wrote: Unable to manage user accounts through MySQL Administrator 1.2.8. I've found that I'm not the only one with this problem but no one seems to have an answer for it. Have you reported a bug to bugs.mysql.com ? kind regards -- Colin Charles, Community Enginee

  1   2   3   >