Re: List archive?

of the links to the list, but I don't have any on hand at the moment.) see  it on the bottom of my post... thanks and sorry for noise It's also archived in many other places, such as GMANE[1] and MARC[2]. ^1: http://gmane.org/ ^2: http://marc.info/ -- /Daniel P. Brown Dedicated

Re: How can i subscribe

On Tue, Dec 14, 2010 at 13:58, omar zorgui omarzor...@gmail.com wrote: Hello, How can i subscribe for this list http://lists.mysql.com/mysql?sub=1 -- /Daniel P. Brown Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting (866-) 725-4321 http://www.parasane.net/ -- MySQL

Re: [PHP] mySQL query assistance...

...@lists.php.net. For your convenience, both have been CC'd on this email. -- /Daniel P. Brown Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting (866-) 725-4321 http://www.parasane.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

mysql vs postgresql -- is this list accurate?

relevant, or are overblown, or whatever, i'd appreciate it. again, i'm not taking sides, i just want to make sure the information is as accurate as possible. thanks. rday -- Robert P. J. Day

might need some help recovering tables from trashed DB

to and some of the tables still appear to be missing, there's not much i can do. or is there? rday -- Robert P. J. Day Waterloo, Ontario, CANADA Top-notch, inexpensive online Linux

multi crosstab

Hi Devs I have a tricky question and I want to know if its possible to accomplish it on mysql and how. The following query: SELECT fields.id AS field_id, data.user_id, fields.type, fields.name, data.value, entries.ip, entries.date, entries.user_agent FROM

Re: multi crosstab

| +-+---+-+ | 1 | 170332881 | Rodrigo | | 2 | 456465789 | felipe | +-+---+-+ :) 2009/4/5 Rodrigo Aliste P. rali...@gmail.com Hi Devs I have a tricky question and I want to know if its possible to accomplish it on mysql and how. The following query

Re: IN vs. OR on performance

2009/3/29 Oscar ro4...@gmail.com: Hi all- I want to know what the difference between IN and OR is under the hood. select * from dummy_table where id in (2, 3, 4, 5, 6, 7); select * from dummy_table where id=2 or id=3 or id=4 or id=5 or id=6 or id=7; I've have thought once the query is

Re: Server Setup Question

, it's no problem. MySQL couldn't care less if it's compiled for i586 or x86_64; that's only in how it relates to the OS on which it's installed, not how it interacts with sibling systems. -- /Daniel P. Brown http://www.parasane.net/ [EMAIL PROTECTED] || [EMAIL PROTECTED] Ask me about our current

Need help executing mysql stress test suite

Hi, For mysql stress test suite (mysql-stress-test.pl) to execute, it requires --stress-tests-file to be provided which contains the list of tests to be executed. As per the documentation the default name of the file is stress-test.txt and it will be located under ./mysql-test directory. But I

Compiling mysql-5.0.51a - `./t/*.disabled'?

Hello. I get a rather strange error which I so far not been able to find the cause of: --- /usr/bin/install: cannot stat `./t/*.disabled': No such file or directory make[4]: [install-data-local] Error 1 (ignored) --- I thought maybe it could be beacuse I run Debian Testing? So far I have not

[EMAIL PROTECTED] locations

Greetings, I've got a retail operation with mysql 5.0.22 on linux pc's across the country, and i need some input on setting up a backup strategy, preferrably without purchasing a package. We're currently using MyISAM, with the databases being dumped to a filesystem on a separate drive, in

Select rows containing identical values in two columns

column equals the value in the modification column? I don't want to specify a specific id in either of the columns. TIA Stephen P. Fracek, Jr. [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

seeding a slave from a slave

Hi All, How do I create a mysql data dump from a slave to seed another slave? Using --master-data with mysqldump from my existing slave sets the master to the slave I was dumping, not the real master. Many Thanks, Ian -- MySQL General Mailing List For list archives:

MySQL upgrade from 5.0.32 to 5.0.42 broke replication

will literally take days. -- Ian P. Christian ~ http://pookey.co.uk signature.asc Description: OpenPGP digital signature

Re: MySQL upgrade from 5.0.32 to 5.0.42 broke replication

Ian P. Christian wrote: I upgraded my slave server a few weeks ago, and the slave failed, with an error similar to the one shown below. I have figured out what happened here now - and I'm part of the way though fixing it. It turned out the defaults had changed somewhere, and rather

Re: MySQL upgrade from 5.0.32 to 5.0.42 broke replication

these defaults changed on a minor mysql release update is beyond me, however I suspect this is gentoo's fault, not MySQLs. -- Ian P. Christian ~ http://pookey.co.uk signature.asc Description: OpenPGP digital signature

Re: replication

doing this for some time, works fine. -- Ian P. Christian ~ http://pookey.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

a 'safe' way to move data?

limit to small numbers in the LIMIT, I/O gets too high, so I'm moving data slowly in batches) Thanks, -- Ian P. Christian ~ http://pookey.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: a 'safe' way to move data?

because any new records would get included in the LIMIT. Will it not always use the natural order of the table in selects/deletes, and therefore return results in the order in which they were inserted? -- Ian P. Christian ~ http://pookey.co.uk -- MySQL General Mailing List For list archives: http

Re: a 'safe' way to move data?

* FROM oldtable WHERE primarykey in ( your 50,000 keys ), then DELETE FROM oldtable WHERE primarykey in ( your 50,000 keys ), then COMMIT, which will cause your insertions and deletions to be truly atomic. Ah of course - a far better idea. Thanks :) -- Ian P. Christian ~ http://pookey.co.uk

Re: MD5()

Neil Tompkins wrote: I'm looking to use MD5() to encrypt credit card numbers. How do I unencrypt this when reading the value ? you can't. Google for MD5, or better still look at wikipedia, I'm sure they will have something -- Ian P. Christian ~ http://pookey.co.uk -- MySQL General

Re: MD5()

://forums.mysql.com/read.php?30,14020,14020 which honestly, I've not read - but you might want to :) -- Ian P. Christian ~ http://pookey.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MD5()

to never store the CVV number. -- Ian P. Christian ~ http://pookey.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump --single-transaction causes database to become unusable

updates/s, 0.21 deletes/s, 48500.03 reads/s Thanks again, -- Ian P. Christian ~ http://pookey.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump --single-transaction causes database to become unusable

Filip Krejci wrote: Hi, I suppose this is really I/O problem. You're right, it looks like it was just an I/O problem - your suggestion was spot on. I've now managed to dump my master data, and can get my slave back online! Thanks a lot for your suggestion, -- Ian P. Christian ~ http

mysqldump --single-transaction causes database to become unusable

for 15 minutes whilst the dump ran. As I'm sure you'll understand I'm not too keen on taking the website down again. Any suggestions as to why my database is stopping (could be I/O related maybe? it's on a good RAID setup though), and what I could do about it? Many Thanks, -- Ian P

Re: mysqldump --single-transaction causes database to become unusable

Marcus Bointon wrote: Hi Marcus :) On 7 Mar 2007, at 08:44, Ian P. Christian wrote: --single-transaction doesn't _do_ the dump as a transaction, it simply wraps the dump in begin/commit statements so it's atomic when restoring. If the dump is to preserve relational integrity then it has

Re: mysqldump --single-transaction causes database to become unusable

separating writes on another box? I did do this under the assumption it could simply be an I/O problem - however the problem persists. It might be because the network connection between the two hosts is pretty fast Thanks Filip! -- Ian P. Christian ~ http://pookey.co.uk -- MySQL General Mailing

Re: Strange table problem

I dont think product_beta.test is a table...It seems to be a view.. what is the create statement for it.. show create table product_beta.test; ??? -Lakshmi Ruan wrote: Hi everybody, I have a very strange table problem - a table was created in one of our databases, but I can't seem to drop

Collation (œ)

Is there a collation where 'œ' = 'oe' so that cœur is sorted between codirection and coffre? I am currently using latin1_swedish_ci and the 'œ' gets sorted to the end (cœur appears after czar). I am using MySQL 5.0.22-Debian_0ubuntu6.06.2. Thanks. -- Brian P. Giroux -- MySQL General Mailing

Re: arrays in stored procedures - pl. help

Chris, thank you for the response, but that was not my question. My question is how do I send multiple sets of data into a stored procedure without doing the things I had outlined. On 7/17/06, Chris [EMAIL PROTECTED] wrote: L P wrote: Folks, say I have a need to add multiple rows

[5.0] Left Join Problem

= tab_e.id2 AND tab_e.id3 = tab_f.id3 LIMIT 1; - this is ok Why doesn't the original query work in MySQL 5.0? What do I need to do to make it work? TIA Stephen P. Fracek, Jr. [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: [5.0] Left Join Problem

and the join, I realized there was a simple fix and that I had misinterpreted the section on the first read. The revised query works. Stephen P. Fracek, Jr. [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

arrays in stored procedures - pl. help

Folks, say I have a need to add multiple rows at the same time. for instance, say I'm collecting customer information and I want to add 3 addresses and 3 phone numbers at the same time for a customer. The above is quite straightforward to accomplish when there is only one set of data to deal

Optimizing DISTINCT searches

Several of my DISTINCT searches are frequently showing up in the slow query log. These queries use multiple table joins. Using EXPLAIN shows that the queries are using the appropriate keys, as far as I know. Are DISTINCT searches using multiple joins slow? TIA. Stephen P. Fracek, Jr. [EMAIL

FW: Optimizing DISTINCT searches

query log. Stephen P. Fracek, Jr. [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Optimizing DISTINCT searches

the sites.. I do have an index on the Site table, it is the Site_ID. The Project.Site_ID is also indexed. Stephen P. Fracek, Jr. [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can I select from remote tables in mysql 5.0.18-standard-log?

DuBois [EMAIL PROTECTED] wrote: At 14:38 -0700 4/27/06, P. Evans wrote: Hello Listers, Is it possible to run a query on one mysql server to another database on a different server ? eg creating an alias in database A on server A to table B on database B on server B ? Like a federated nickname

Can I select from remote tables in mysql 5.0.18-standard-log?

Hello Listers, Is it possible to run a query on one mysql server to another database on a different server ? eg creating an alias in database A on server A to table B on database B on server B ? Like a federated nickname on db2 udb or synonym on informix ? Thanks Pierre

RE: Expiration date on users utilizing freeradius and mysql

data? Thanks Dwane -Original Message- From: Atkins, Dwane P [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 29, 2006 10:59 AM To: mysql@lists.mysql.com Subject: Expiration date on users utilizing freeradius and mysql I am using freeradius with MySql and what I would like to do

Expiration date on users utilizing freeradius and mysql

I am using freeradius with MySql and what I would like to do is create in my radius table an user with attributes stating a start and stop date. I would like to be able to do a bulk entry (more than 1 at a time) or would love for this to be web based. Is this process out there? Thanks

/var/log/mysql.000001 Not Found?

, David P. Donahue [EMAIL PROTECTED] http://www.cyber0ne.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Freeradius and MySql

to databases mysql and database radius. However, when I try to log in to mysql using the command mysql -u radius -p radius, I get and error stating, Error 1045 (28000): Access Denied for user 'radius'@'localhost' (using:Password: YES). I am really frustrated since I have been working on this login

RE: Freeradius and MySql

To: Atkins, Dwane P Cc: mysql@lists.mysql.com Subject: Re: Freeradius and MySql Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 10:38:57 AM: Good morning. I am trying to install Free Radius with MySql, but I either have a login issue or a permissions issue. I have added Radius

RE: Freeradius and MySql

I did do a FLUSH PRIVILEGES and this still resulted in the same error. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 23, 2006 10:31 AM To: Atkins, Dwane P Cc: mysql@lists.mysql.com Subject: RE: Freeradius and MySql You could try

RE: Freeradius and MySql

I didn't encrypt and that was going to be my next questions. How do I do that? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 23, 2006 10:45 AM To: Atkins, Dwane P Cc: mysql@lists.mysql.com Subject: RE: Freeradius and MySql OK

RE: Freeradius and MySql

. Dwane From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 23, 2006 10:45 AM To: Atkins, Dwane P Cc: mysql@lists.mysql.com Subject: RE: Freeradius and MySql OK, make sure you are using the correct password, too. Did you remember to encrypt

FW: Any help with resetting the administrative password using 'my sqld_safe' w/ the --init-file option

-Original Message- From: Skarlatos, Matthew P. To: 'mysql@lists.mysql.com' Sent: 2/13/2006 8:37 AM Subject: Any help with resetting the administrative password using 'mysqld_safe' w/ the --init-file option Has anyone run into a problem with setting the root user password in mysql

Any help with resetting the administrative password using 'mysqld _safe' w/ the --init-file option

Has anyone run into a problem with setting the root user password in mysql using mysqld_safe with the '--init-file' option that contains the new password for startup? What I'm seeing after I issue the kill command for the 'host.pid' file and then restarting 'mysqld_safe --init-file', is a

Error inserting text containing a ? character

. Regards, David P. Donahue [EMAIL PROTECTED] http://www.cyber0ne.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Setting SQL_BIG_SELECTS

query? Basically, is there a way to set it globally on the MySQL server so it will apply to all sessions/connections? Regards, David P. Donahue [EMAIL PROTECTED] http://www.cyber0ne.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Setting SQL_BIG_SELECTS

: mySqlConnection = new MySqlConnection(stringDatabaseConnection); mySqlDataAdapter = new MySqlDataAdapter(stringSelect, mySqlConnection); dataSetSQL = new DataSet(); mySqlDataAdapter.Fill(dataSetSQL); return dataSetSQL; Regards, David P. Donahue [EMAIL PROTECTED] http://www.cyber0ne.com -- MySQL

mysqlimport debug options

Hello Listers, Can anyone explain what are valid values for the 'debug options' on a mysqlimport ? The manuals just say : --debug[=debug_options], -# [debug_options] Write a debugging log. The debug_options string often is 'd:t:o,file_name'. What is d: ? t: ? o (ok,thats

Re: 1266 creating innodb tables

Much thanks, that did the trick. Pierre Jasper Bryant-Greene [EMAIL PROTECTED] wrote: P. Evans wrote: skip-innodb is commented out,thats why its not in the options I sent previously. The logs are showing something peculiar - InnoDB: Error: log file ./ib_logfile0 is of different size 0

Re: 1266 creating innodb tables

What gives ? How can I get the logfiles in synch ? Pierre Jasper Bryant-Greene [EMAIL PROTECTED] wrote: P. Evans wrote: Shawn, as far as I can tell, no. Here's all my innodb options set in my.cnf : Well, it's easy to check: grep skip-innodb my.cnf Is there anything interesting

Re: 1266 creating innodb tables

| +-+--++ | Warning | 1266 | Using storage engine MyISAM for table 'petest' | +-+--++ 1 row in set (0.00 sec) Jasper Bryant-Greene [EMAIL PROTECTED] wrote: P. Evans wrote

Re: 1266 creating innodb tables

off support to that engine forcing it to elect a different method of storage. Shawn Green Database Administrator Unimin Corporation - Spruce Pine P. Evans [EMAIL PROTECTED] wrote on 11/10/2005 10:10:44 AM: Here's an example : mysql create table petest (col1 integer,col2 char(5)) engine

1266 creating innodb tables

Whenever I try to create a table using innodb, i get a 1266 warning that the table has been created with myisam instead. I receive the error both at the mysql command line and using the mysql query browser. I've also tried alterring the table to change the engine , which says it

InnoDB maintenance question?

I have an ibdata file that is growing and growing and growing Are there maintenance routines that I can run to keep this file in check? My database is performing close to half a million transactions a day and this file is now well over 75GB. Can I expect this file to continue to grow, until

MySQLHotCopy Error

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

Show table status

Hello, Does anyone know where (c-api functions perhaps) SHOW TABLE STATUS gets its info from? Specifically, the new columns added in 4.1.2 and 4.1.3, are they the result of underlying c-function changes, new functions, or something else. Thanks Michael -- MySQL General Mailing List For list

datetime/timestamps/4.1.12

Hello, I just upgraded to 4.1.12 from 4.0.22 and my timestamps changed formats to %Y-%m-%d %H:%i:%s So I added the following lime to my my.cnf file datetime_format=%Y%m%d%H%i%s Which is the format I prefer, I restart the server and my time stamps still appear as %Y-%m-%d %H:%i:%s The

RE: datetime/timestamps/4.1.12

and annoying. Any plans on rectifying this, or has anyone found a workaround, or are we left to go SIOH (hint OH stands for our hat) :-} Later... Michael -Original Message- From: DePhillips, Michael P Sent: Sun 7/17/2005 11:05 AM To: mysql@lists.mysql.com

radius account management using sql

Hello, We have radius server and using mysql. I would like to determine who are the users who have not login to our dialup server for over six months and then disable the account In the example below, I'm just using 10 days mysql SELECT distinct

dateTime vrs. Timestamp

Hello, Am I gaining anything by using a timestamp instead of using dateTime and calling now(), for example, increased performance, better indexing, etc. I guess another way to ask this is does the MySQL internals handle a timestamp more efficiently than a dateTime. Thanks Michael -- MySQL

Re: Foreign Key Error 1005:150

Michael, Thank you for your reply. Here is a bit more info. I changed the default table type to innodn in the my.ini file before creating the database, so all tables are innodb. I tried the create statements with and without explicit index clauses with all permutations - same result each

Foreign Key Error 1005:150

I am unable to define a foreign key with the following three tables. I am unable to find the error having searched the documentation and tried several variations. Note that I created the first two tables with and without the index clause in the table ddl with no difference in outcome. The

Re: mysqld no longer starts after update 4.0 - 4.1

Hello Gleb, Please read the notes about MySQL on Linux: http://dev.mysql.com/doc/mysql/en/Linux.html I don't find anything specific to my problem there, sorry! My Linux installation seems to be missing something that the bdb part of MySQL 4.1 needs and which was not needed by v4.0 and

Problems making a mysql.so file

Greetings all, I tried the PHP list with this one and can't seem to get an answer so I thought I'd try here. I upgraded from MySQL 3.23 to 4.0. I placed all the new mysql files in /usr/local/mysql/bin, /usr/local/mysql/include and /usr/local/mysql/lib. I compiled PHP5 and it is still using

RE: Removing Entries From a MySQL Table

Hello; DELETE FROM table_name WHERE 1 ; This command will remove all rows from the table. For more information, see: http://dev.mysql.com/doc/mysql/en/DELETE.html Make sure you have a backup if you think you may need the data in the future. -Tom -Original Message- From: Michael

RE: NULL problem

Try SELECT * FROM table ORDER BY col LIMIT 23 ; If the col type is numeric, trying to match the string NULL might be the problem. And, if it is numeric, the NULL values will be listed first in 'ORDER BY col'. This doesn't really solve the problem of not being able to select 'where col is

Upgrade from 3.23 to 4.0 - mysql.sock error

Greetings all, I recently upgraded from mysql 3.23 to 4.0 on a Fedora box. I moved the old installation to a directory called old_mysql in my home directory. I can start the new installation using mysqld_safe . Now, when I try to do something like: /new/install/mysqladmin -u root -p version

Re: Upgrade from 3.23 to 4.0 - mysql.sock error

Okay, so what I did to solve this was: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock That seems like a bit of a hack though. The my.cnf file has this line: socket=/var/lib/mysql/mysql.sock Anyone know why it's looking in /etc ? On Jul 14, 2004, at 4:53 PM, Jough P wrote: Greetings all, I

Access denied for user: 'root@localhost' (Using password: NO)

Hi - I am new to MySQL - I just recently re-installed MySQL by rpm and when ever I try to issue a command from the shell prompt, such as mysqladmin or mysqlshow, I would get the error of 'Access denied for user: '[EMAIL PROTECTED]' mailto:'[EMAIL PROTECTED]' (Using password: NO)'. Could

RE: Access denied for user: 'root@localhost' (Using password: NO)

shouldn't I be able to issue commands at the shell it goes and does it thing and give back output? or does this mean I have a passwd already set and it's secured? -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 8:57 AM To: Nguyen, Long P

bugzilla not working now after MySQL re-installed

. Is the database installed and up and running? Do you have the correct username and password selected in localconfig? AHA /pre p For help, please send mail to this site's webmaster, giving this error message and the time and date of the error. /p [Thu Jul 1 10:00:17 2004] checksetup.pl: Can't

RE: bugzilla not working now after MySQL re-installed

Message- From: Hassan Schroeder [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:38 AM To: Nguyen, Long P (Mission Systems); [EMAIL PROTECTED] Subject: Re: bugzilla not working now after MySQL re-installed Nguyen, Long P (Mission Systems) wrote: Your thoughts on this would

RE: bugzilla not working now after MySQL re-installed

I am able to log into mysql as this: [EMAIL PROTECTED] root]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 4.0.20-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql I

RE: bugzilla not working now after MySQL re-installed

yes.. below: [EMAIL PROTECTED] root]# mysql -u bugs -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 4.0.20-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql -Original Message

RE: bugzilla not working now after MySQL re-installed

I am able to logon with user 'bugs' and passwd 'marvin' as below: [EMAIL PROTECTED] root]# mysql -u bugs -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 4.0.20-standard Type 'help;' or '\h' for help. Type '\c' to clear

RE: bugzilla not working now after MySQL re-installed

is there? -Original Message- From: Hassan Schroeder [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 12:20 PM To: [EMAIL PROTECTED] Subject: Re: bugzilla not working now after MySQL re-installed Nguyen, Long P (Mission Systems) wrote: yes.. below: [EMAIL PROTECTED] root]# mysql -u

RE: bugzilla not working now after MySQL re-installed

distributions it can be found in /var/lib/mysql/mysql.sock. Yiannis. -Original Message- From: Nguyen, Long P (Mission Systems) [mailto:[EMAIL PROTECTED] Sent: 01 July 2004 17:07 To: Hassan Schroeder; [EMAIL PROTECTED] Subject: RE: bugzilla not working now after MySQL re-installed yes

Replication - Too many master threads -BUG?

Hi - perhaps this is a bug - but I figure I'd try here first in case I'm doing something wrong. Master is 4.0.20 - slave connect and replicate fine, HOWEVER, for each binlog dump a new thread gets created and the old one is NOT released. Within a couple of days my master sever is flooded and

Replication died

Hello - I just upgraded my master to 4.0.20 from 3.23.54 (ran the mysql_fix_privileges script) My slaves are all 4.0.[16,17,18] All seems well EXCEPT the Slave_IO_Running will NOT start. All my slave a stuck at the point prior to the upgrade. Error logs reveal nothing

RE: Replication died

Never mind...I've fixed it. Thanks Michael -Original Message- From: DePhillips, Michael P Sent: Wednesday, June 09, 2004 4:17 PM To: '[EMAIL PROTECTED]' Subject: Replication died Hello - I just upgraded my master to 4.0.20 from 3.23.54 (ran the mysql_fix_privileges script

Re: RE - Order By Problem

If surname is a field, then use it without the single quotes ('), otherwise it is treated as a literal string and 0 is the correct result: select locate(' ',surname,1) from advisers andy thomas wrote: Yes, this is the approach I was thinking of using but: select locate('

Re: Codes for U.S. Counties

David Blomstrom wrote: I just wondered if anyone on this list has worked with counties in databases and is aware of a pre-existing code system that's in fairly wide use. It would be nice to make a database that's compatible with other databases, if they share a common code for counties. I don't

INSERT table1 SET col1 = table2.col1

Why when there is a figurae, figurae2 table does the follow give an error? INSERT INTO figurae2 SET id = figurae.id; The error is: ERROR 1109 at line 35: Unknown table 'figurae' in field list Line 35 is the Insert line shown. There are no following lines in the file. I cut and pasted figurae from

Re: INSERT table1 SET col1 = table2.col1

Victoria Reznichenko wrote: P. Hill [EMAIL PROTECTED] wrote: Why when there is a figurae, figurae2 table does the follow give an error? INSERT INTO figurae2 SET id = figurae.id; The error is: ERROR 1109 at line 35: Unknown table 'figurae' in field list Look at INSERT .. SELECT statement

Re: INSERT table1 SET col1 = table2.col1

Garth Webb wrote: I'm not asking for an alternative way to do it; I'm asking what is wrong with what I did? It looks like you want to copy over several or all values from a second table. The INSERT .. SELECT syntax isn't an alternate way, its the only way. Okay, thanks for the clarification. I

Re: replication in 5.0.0-alpha

Hi, collegues On Sat, Apr 17, 2004 at 05:19:16PM +0300, Oleg P. Philon wrote: Have I use precompiled binaries from ftp.mysql.com? Ya, I have to Is there working setups with 5.0.0 and replication? Again yes, in mein setup at last Auf Wiederlesenophil aka - -- Oleg P

sql syntax error

I'm using amavisd-new -20030616p9, RH 3.0 ES and mysql 3.23.58-1 trying to do sql lookups for user prefs. I've done this before and have compared my sql statements and can't figure out the problem. When i start amavisd-new with the debug switch, here's what i get: # /usr/local/sbin/amavisd

replication in 5.0.0-alpha

? Auf Wiederlesenophil aka - -- Oleg P. Philon http://gomelug.agava.ru/articles Linux Lab, Gomel, Belarus mailto:ophil(at)gomelug.agava.ru http://anticommunist.narod.ru mailto:anticommunist(at)narod.ru -- MySQL General Mailing List For list archives: http

Re: User variables + SUM + GROUP BY = strange behavior

/doc/mysql/en/Variables.html A little ways down the page... The general rule is to never assign and use the same variable in the same statement. -- Tripp --- Vadim P. [EMAIL PROTECTED] wrote: Sorry, the message got garbled, here is a more digestible look: -Original Message- Hello all

User variables + SUM + GROUP BY = strange behavior

Hello all, Could anyone comment on User Variable behavior in the example below? Thanks, Vadim. = mysql SELECT - LEFT(CallTime,10) AS CallDate, - @a := SUM(Charge), - @b := SUM(Cost), -

User variables + SUM + GROUP BY = strange behavior

Sorry, the message got garbled, here is a more digestible look: -Original Message- Hello all, Could anyone comment on User Variable behavior in the example below? Thanks, Vadim. = mysql SELECT -

Re: Killing overactive mysql selects

Start another Mysql shell session; then do show processlist; identify the thread ID of the offending process, then do kill ID. Not sure how graceful this method is, though. I use it to kill overlooked hanging connections from time to time. Cheers, Vadim. Scott Haneda wrote: Every now and

Re: SELECT DISTINCT.. ORDER BY.. DESC - bug??

improves SELECT .. ORDER BY .. ASC, but slows down SELECT.. ORDER BY .. DESC at least by a factor of 10. If this is not a bug, what is it? Vadim P. wrote: Hi all, Sorry to be so persistent, but I am bringing this up again since noone from the MySQL development

SELECT DISTINCT.. ORDER BY.. DESC - bug??

Hi all, Sorry to be so persistent, but I am bringing this up again since noone from the MySQL development team commented on my previous post, and the issue seems very serious, to the point I may start looking to switching away from MySQL, so - please, please, shed some light on this issue!!!

  1   2   3   >