List annoyance

Why is this list reply to sender and not reply to list? Its annoying getting duplicated responses when someone replies to a message you send to the list. Its annoying getting single responses that are out of context and its annoying if responses go to the questioner personally, when the response

Re: Error After Upgrading 3.23.58 -> 4.1.7

Jason Williard wrote: I recently upgraded MySQL from 3.23.58 to 4.1.7 on a Fedora Core 1 system. After the upgrade, I ran into the following error with a previously installed copy of Bugzilla. I think the core of the error is "Client does not support authentication protocol requested by server". [s

Re: union, intersct and except operation?

SELECT DISTINCT study FROM table WHERE keyword='chemistry'; - Of course if it's 'chemistry' it IS <> ''computers' or anything else 'chemistry' <> 'computers' so last part ot your SQL statement is obsolete L a n a wrote: Hello, I've had a problem trying to get working except operator in mysql: sta

Error After Upgrading 3.23.58 -> 4.1.7

I recently upgraded MySQL from 3.23.58 to 4.1.7 on a Fedora Core 1 system. After the upgrade, I ran into the following error with a previously installed copy of Bugzilla. I think the core of the error is "Client does not support authentication protocol requested by server". -[ERROR]---

Re: union, intersct and except operation?

L a n a wrote: Hello, I've had a problem trying to get working except operator in mysql: statement "SELECT study from table WHERE keyword = 'chemistry' NOT keyword = 'computers'" returns SQL error Of course. NOT is an operator, not a connector. That is, "NOT keyword = 'computers'" has the oppo

mysq query browser

hey guys i have tried to compile the tarball of the mysql query browser but i am getting problems with the .pc files , i had to look all over bugzilla's and the like to get a file called libxml-2.0-uninstalled.pc , which was one of the files i needed to put in the pkconfig directory so tha

Re: Posting Question

On Tue, 9 Nov 2004 13:21:54 -0600, Lewick, Taylor <[EMAIL PROTECTED]> wrote: > I am asking before I post so I don't anger everyone... > > Is this list okay to post a specific question regarding multiple row > inserts.. > > I am doing this in perl, and I need some help with the perl part... There

Re: Select Statement Query

How about SELECT * FROM queLog WHERE accessed = "Y" AND targetApp = "acadreg" AND enteredQue >= '2004-11-09 18:00:00'; (You said greater than first, then you said greater than or equal to. I went with the latter.) Michael Kory Wheatley wrote: I'm trying to do a select statement where: fi

Select Statement Query

I'm trying to do a select statement where: field "targetApp" equals the value "acadreg" and field accessed equals the value "Y" and filed enteredQue is like "2004-11-09 18%" the whole "enterqueue" fieild is something like "2004-11-09 16:00:34" Here's what I'm trying to accomplish, I want to

Re: InnoDB data files keep growing with innodb_file_per_table

Heikki, Heikki Tuuri wrote: > John, > > please post what SHOW INNODB STATUS says. The probable reason is that > there are long transactions, or that purge is falling behind. > > Best regards, > > Heikki Tuuri Actually, I have no idea why purge was falling behind, since no row has ever been deleted

union, intersct and except operation?

Hello, I've had a problem trying to get working except operator in mysql: statement "SELECT study from table WHERE keyword = 'chemistry' NOT keyword = 'computers'" returns SQL error I've got the following not working solutions to my problem: SELECT [distinct] study FROM table WHERE keyword = 'ch

Re: UTF-8 compliance

On Tue, 2004-11-09 at 23:17, [EMAIL PROTECTED] wrote: > What does this all entail? You can use Arabic/Chinese etc characters >Can we use Under_Scores in table names. Yes. This is not effected by UTF8 anyway. -- Edward A. Macnaghten http://www.edlsystems.com -- MySQL General Mailing Li

Re: Best Practices

Have you thought about locking the reporting database for write? You could eliminate the dirty reads. If you are using InnoDB on the reporting tables, you could use a transaction for the update operation. That would accomplish the same thing. You could use replication to move the load to another

Best Practices

I am working on a data warehousing solution involving mysql and have a question about best practices. We are standardized on mysql 4.1, and this is for a rather picky client. We have a relational transaction database that stores the results of customer calls and a dimensional reporting database us

Re: replication problems

At 9:49 -0800 11/9/04, ian douglas wrote: Except that changes made on the master are not automatically picked up by the slaves. My bad, I wasn't running "START SLAVE" to get them going. Seems odd that this has to be done manually. Perhaps you have the --skip-slave-start option in an option file?

Re: using mysqldump to export BLOB tables

At 12:06 -0500 11/9/04, Caron, Christian wrote: Hi, I have been looking around (manual, google, etc.) to find out if I can use mysqldump with BLOB tables, but to no avail. Is it possible to do so, and if yes, is there any flag I need to give to mysqldump? Or can you point me to the manual page that

Re: error importing from mysqldump output

At 10:33 +1100 11/10/04, Daniel Kasak wrote: Russell E Glaue wrote: 'order' is a reserved word. I would rename that field, pronto! In my opinion the bug is not in mysqldump, but in mysql allowing you to use a fieldname that is a reserved word. And yes I know about the backticks that mysqlcc uses,

Complex Query: Best way to write it?

Hi, I am trying to come up with the most optimal way to write a query to select out the following fields: test_username.username_name test_subprofile_details.subprofile_details_headline test_profile.profile_birthday test_profile_gender.profile_gender_name test_subprofile.subprofile_picture test_c

Re: error importing from mysqldump output

Russell E Glaue wrote: 'order' is a reserved word. I would rename that field, pronto! In my opinion the bug is not in mysqldump, but in mysql allowing you to use a fieldname that is a reserved word. And yes I know about the backticks that mysqlcc uses, but surely this causes more problems than it

Re: error importing from mysqldump output

Daniel Kasak wrote: Russell E Glaue wrote: ERROR 1064 at line 14071: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order int(1) NOT NULL default '0', PRIMARY KEY (moduleID), Would this possibly be a bu

Re: error importing from mysqldump output

Russell E Glaue wrote: ERROR 1064 at line 14071: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order int(1) NOT NULL default '0', PRIMARY KEY (moduleID), Would this possibly be a bug with mysqldump ? -

Re: Subject Headings in Tables

Oops, I forgot my follow up question... I now have two tables: TABLE 1 Alabama Alaska Arizona Arkansas California Colorado Connecticut TABLE 2 Far North New England Pacific Coast South Southwest Rocky Mountains If I had put all of the above in one table, then it would be easy to display them

UTF-8 compliance

What does this all entail?   Can we use Under_Scores in table names. ThanksDonny LairsonPresidenthttp://www.gunmuse.com469 228 2183

Re: Subject Headings in Tables

OK; thanks! --- [EMAIL PROTECTED] wrote: > Normalize, David. Normalize. Your Regions get their > own table. If a > country/state can belong to more than one region you > will need another > table to hold that association. > > I can't remember if this was ever recommended to > you but I had a

error importing from mysqldump output

I did a mysqldump from serverA, took that output and did the following as illustrated below to import into serverB. why did I get an error? Did mysqldump output the wrong SQL syntax? I would not think so, but I got this error which says so. I am using mysql-4.0.20 on both servers. I am importi

Re: replication problems

On Tuesday 09 November 2004 03:23 pm, ian douglas wrote: > GRANT SUPER,REPLICATION CLIENT to 'syscheck'@'mywebserver.domain.org' > IDENTIFIED BY 'mypasswd' ; I have no idea how this script is gonna help, but your having permission problems. The last message you wrote was permission problems as w

Re: Alter table only on the master?

Hey, As I found out on the list, you want to SET SQL_LOG_BIN=0 in your session. The user making the changes needs have the SUPER privilege. http://dev.mysql.com/doc/mysql/en/SET_SQL_LOG_BIN.html On Tue, 9 Nov 2004 20:35:22 +0100, harm <[EMAIL PROTECTED]> wrote: > Hello, > > I want to convert a

Re: replication problems

If a slave dies, is there any way to determine that state from an external point of view (ie: via Perl/DBD) so we can write a script of some kind to either connect to the slave and issue a "START SLAVE" or send the last xx lines of the .err log file to our tech staff? I tried writing a Perl scri

Re: InnoDB data files keep growing with innodb_file_per_table

John, please post what SHOW INNODB STATUS says. The probable reason is that there are long transactions, or that purge is falling behind. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also

Re: Subject Headings in Tables

Normalize, David. Normalize. Your Regions get their own table. If a country/state can belong to more than one region you will need another table to hold that association. I can't remember if this was ever recommended to you but I had a chance to re-read it recently and think this could help

error after installing mysql 4.1

After installing mysql 4.1 over an existing mysql 4.0.x, the service refuses to start with this complaint: Fatal error: Can't open privilege tables: File '\\pumpkin\f\mysql\share\charsets\?.conf' not found (Errcode: 22) This is windows, with mysql installed in a nondefault directory. -- MySQ

Re: data deleted in MySQL but table file (.MYD) remains same size

At 11:53 -0800 11/9/04, Fredrick Bartlett wrote: Why not "TRUNCATE" table... If you want an empty table, yes. The goal below appears to be to retain the records after changing one of the columns after an empty string. - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> > At 13:0

Re: data deleted in MySQL but table file (.MYD) remains same size

Why not "TRUNCATE" table... - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "gerald_clark" <[EMAIL PROTECTED]>; "Craig Cummings" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, November 09, 2004 11:21 AM Subject: Re: data deleted in MySQL but table file (.MYD)

Re: select for text within a field.

On Tuesday 09 November 2004 09:21 am, Shanta McBain wrote: > > [% FOREACH link = DBI.query("SELECT * FROM url_tb > > WHERE products LIKE 'honey' > > AND (site_name = 'Apis' OR > > site_name = 'All') > >

Re: Posting Question

Post it, I'll help. On Tue, 2004-11-09 at 19:21, Lewick, Taylor wrote: > I am asking before I post so I don't anger everyone... > > Is this list okay to post a specific question regarding multiple row > inserts.. > > I am doing this in perl, and I need some help with the perl part... > > >

InnoDB data files keep growing with innodb_file_per_table

Hello, I have a DB of about 100 tables, and MySQL is configured to keep them in separate files. Total size of the files is ~2GB. Most of the tables are of similar format and consist of many short fixed-length rows (~50 bytes/row). The database size is increased for several MB a day. Initial conf

Re: data deleted in MySQL but table file (.MYD) remains same size

That did the trick. Thanks for the advice. -Craig On Tue, 9 Nov 2004, Paul DuBois wrote: > At 13:06 -0600 11/9/04, gerald_clark wrote: > >Craig Cummings wrote: > > > >>Hi there, > >> > >>I have a table with three columns, two varchar(12) identifiers and a > >>longtext column with very long (som

Alter table only on the master?

Hello, I want to convert a table from innodb to myisam on the _master only_, not on the slaves. Is there a secret 'do this alter table only on the master' command, or do I really have to do some voodoo-replication-queries-skipping on the slaves? Thanks, Harmen --

Posting Question

I am asking before I post so I don't anger everyone... Is this list okay to post a specific question regarding multiple row inserts.. I am doing this in perl, and I need some help with the perl part... Thanks, Taylor

Re: data deleted in MySQL but table file (.MYD) remains same size

At 13:06 -0600 11/9/04, gerald_clark wrote: Craig Cummings wrote: Hi there, I have a table with three columns, two varchar(12) identifiers and a longtext column with very long (some > 50 MB) strings. The size of the chromosomes.MYD table was about 2.8 GB. The table was used transiently and I no l

Re: data deleted in MySQL but table file (.MYD) remains same size

Craig Cummings wrote: Hi there, I have a table with three columns, two varchar(12) identifiers and a longtext column with very long (some > 50 MB) strings. The size of the chromosomes.MYD table was about 2.8 GB. The table was used transiently and I no longer needed to store the strings, so in th

data deleted in MySQL but table file (.MYD) remains same size

Hi there, I have a table with three columns, two varchar(12) identifiers and a longtext column with very long (some > 50 MB) strings. The size of the chromosomes.MYD table was about 2.8 GB. The table was used transiently and I no longer needed to store the strings, so in the interest of freeing

Trans.: Re: Read locks with InnoDB?

Date : Tue, 9 Nov 2004 18:35:40 +0100 De : Julien ALLANOS <[EMAIL PROTECTED]> Adresse de retour :Julien ALLANOS <[EMAIL PROTECTED]> Sujet : Re: Read locks with InnoDB? À : Gleb Paharenko <[EMAIL PROTECTED]> > Julien ALLANOS <[EMAIL PROTECTED]> wrote: > > Hello, > > > > Basically,

[ANN] Webyog releases FREE edition of SQLyog

Hello, Webyog, the creator of SQLyog - the most popular GUI for MySQL has released SQLyog v4.0. Starting from v4.0, SQLyog is available in two editions: SQLyog and SQLyog Enterprise. SQLyog is FREE for personal and commercial use. SQLyog contains all features of SQLyog Enterprise - except the

[ANN] Webyog releases FREE edition of SQLyog

Hello, Webyog, the creator of SQLyog - the most popular GUI for MySQL has released SQLyog v4.0. Starting from v4.0, SQLyog is available in two editions: SQLyog and SQLyog Enterprise. SQLyog is FREE for personal and commercial use. SQLyog contains all features of SQLyog Enterprise - except the

Re: replication problems

On Tuesday 09 November 2004 11:49 am, ian douglas wrote: > My bad, I wasn't running "START SLAVE" to get them going. Seems odd that > this has to be done manually. I never do.. once its started, it should be fine.. Your just getting errors making it stop. > Also, overnight, my slaves reported

Re: replication problems

Except that changes made on the master are not automatically picked up by the slaves. My bad, I wasn't running "START SLAVE" to get them going. Seems odd that this has to be done manually. Also, overnight, my slaves reported this error: 041108 19:06:42 [Note] Slave I/O thread: connected to maste

Re: Emulating timediff in 4.0 ?

You need to be careful when subtracting dates-- if you treat them like integers, you'll probably not get the results you were expecting. Here's more discussion from the archive: http://lists.mysql.com/mysql/172921 Eamon Daly - Origin

mysql

MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: select for text within a field.

>Shanta McBain >on Wednesday, October 20, 2004 9:29 AM said: Sorry to take so long to get back. I have been putting by bees to bed for the winter. Now I can program again. > [% FOREACH link = DBI.query("SELECT * FROM url_tb > WHERE

using mysqldump to export BLOB tables

Hi, I have been looking around (manual, google, etc.) to find out if I can use mysqldump with BLOB tables, but to no avail. Is it possible to do so, and if yes, is there any flag I need to give to mysqldump? Or can you point me to the manual page that describes that? The page http://dev.mysql.c

Re: Emulating timediff in 4.0 ?

Thanks Eamon, I was trying with something like: SELECT stamp,now()+0, if ((now() - stamp)<6000, (now() - stamp) /60,0) as waitminutes from smstablademotaxi //I'm interested to get it only for the last 60 minutes result: +++-+ | stamp | now()

Re: Emulating timediff in 4.0 ?

A combination of UNIX_TIMESTAMP and SEC_TO_TIME should do it: SELECT UNIX_TIMESTAMP('1997-12-31 23:59:59.01') as `date 1 in seconds`, UNIX_TIMESTAMP('1997-12-30 01:01:01.02') as `date 2 in seconds`, UNIX_TIMESTAMP('1997-12-31 23:59:59.01') - UNIX_TIMESTAMP('1997-12-30 01:01:01.02')

Re: How to bring up local replication / socket-error

Hello. See: http://bugs.mysql.com/bug.php?id=3310 "Lutz Maibach" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm trying to set up a replication client on the same server as the > master is running. Master is port 3306 and its socket > /mymaster/mysql.sock. I set up the repl-client to co

Re: Read locks with InnoDB?

Hello. Transactions are usually used for such purposes, just as 'select ... for update'. You may have interest in: http://dev.mysql.com/doc/mysql/en/InnoDB_locking_reads.html http://dev.mysql.com/doc/mysql/en/Transactional_Commands.html Julien ALLANOS <[EMAIL PROTECTED]> wrote:

Read locks with InnoDB?

Hello, Basically, I have multiple MySQL clients that have to delete entries from a InnoDB table in a concurrent environment. What they do is: 1 - getting the first entry of the table that needs to by deleted, by executing a "SELECT ... LIMIT 1" query, 2 - doing stuff with the query result, 3 - del

How to bring up local replication / socket-error

Hi, I'm trying to set up a replication client on the same server as the master is running. Master is port 3306 and its socket /mymaster/mysql.sock. I set up the repl-client to connect to localhost (tried the ip-address too) on port 3306. When I start the replication I get the following error: Er

Emulating timediff in 4.0 ?

TIMEDIFF(expr,expr2) TIMEDIFF() returns the time between the start time expr and the end time expr2. expr and expr2 are time or date-and-time expressions, but both must be of the same type. mysql> SELECT TIMEDIFF('1997-12-31 23:59:59.01', -> '1997-12-30 01:01:01.02'

Re: connection problem with 4.1.7

P.V.Anthony wrote: Hi, I am having an intermitten connection problem with MySQL 4.1.7 . Here is the setup. Intel P4 with HT Fedora Core 1 kernel 2.4.27 smp MySQL version 4.1.7 (RPM install from mysql.org) Qmail with vpopmail using mysql (www.qmailtoaster.com) Sometimes I cannot login to qmail to ch

Re: Temporary Upgrade for Cpanel?

Hello. Usually config file means "my.cnf" (my.ini on Windows). >As I don't have the [mysqld-4.0] in the my.cnf just [mysqld] See: http://dev.mysql.com/doc/mysql/en/Option_files.html >And how do I know that it is actually running? Start by checking whether there is a process named

Re: Installation of system tables failed

Hello. Not enough info to make a conclusion. Did you look at: http://dev.mysql.com/doc/mysql/en/mysql_install_db.html http://dev.mysql.com/doc/mysql/en/FreeBSD.htm ? Maybe that will help. Vincent Blondel <[EMAIL PROTECTED]> wrote: > Hello, > > I am trying to install the sys

Re: Fast method needed to determine if a table is corrupt

Hello. I assume that MyISAM tables are checked thorougly, i.e. each record is read and compared to the table definition. How big your table is and what kind of storage it is on? If the time to check is comparable to the time needed to actually read the whole data from the storage - then it'

Re: Problem connecting to MySQL server

Hello. See: http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html Schalk Neethling <[EMAIL PROTECTED]> wrote: > Hey there > > I have upgraded the MySQL server on my Windows machine to 4.0.22 > following the docs at: > http://dev.mysql.com/doc/mysql/en/Windows_upgrading

Re: Temporary Upgrade for Cpanel?

Hello. See: http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html >btw new worked --new gave me this error >DBI connect('mysql:localhost','root',...) failed: Can't connect to local >MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at >/scripts/restartsrv_mysql line

Re: how to use except operation (corrections for the return results)?

Better: select * from table as t1 left join table as t2 on t1.study=t2.study and not t2.keyword ='K2' where t1.keyword = 'K1' Santino At 23:23 +0100 8-11-2004, Santino wrote: Something like: select * from table as t1, table as t2 where t1.study=t2.study and t1.keyword = 'K1' and not t2.keyword ='K