problems starting mysql - malloc?

Hi all, I've had a mysql db server running fine for a few months now, and all of a sudden, I'm having trouble with it. when starting the service, the error log contains the following 8<8<8<8<8< 021119 09:58:56 mysqld started /usr/sbin/mysqld: Can't read d

RE: one mysql-test issue

Does the directory /usr/local/mysql/var/run exist? If not, try creating it! Regards Matthew Smith -Original Message- From: Yu, Jerry [mailto:[EMAIL PROTECTED]] Sent: 19 November 2002 07:41 To: [EMAIL PROTECTED] Subject: one mysql-test issue > Hi,all > I built the mysql-4.0.3-beta sour

one mysql-test issue

> Hi,all > I built the mysql-4.0.3-beta source on redhat7.3 with gcc2.95.3 using only > one option: > --prefix=/usr/local/mysql. > It is built successfully and installed to /usr/local/mysql. But during > running the mysql-test, it always aborted and reported that > "/usr/local/mysql/mysql-test/var

How I Got PHP4.2.2, Apache 2.0, mySQL and RedHat 8.0 to work

Well, it seems there are some glitches with and snags and other fun stuff to deal with when doing a straight RedHat 8.0 install. It turns out you have to edit your /etc/php.ini and uncomment out the "extension=mysql.so" line for starters. It also helps to set "short_open_tag = On". Another fun thi

Re: cmd load is not allowed in ver3.23.53???

On Tue 2002-11-19 at 14:50:09 +1100, [EMAIL PROTECTED] wrote: > HI >Does any one encounter the same problem?? If load cmd in not working > in ver3.23.53, is there any alternative cmd for loading table??? See http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html Bye, Benjamin. -- [EMAIL

optimize table - how often ?

Howdy - I have heard that periodically optimizing tables can be helpful in the overall maintenance of the table space in the db. Is this correct and how often should it be done? Thanks Mark sql,query - Before posting, please

Re: feature suggestion - indexes with "where" clause or similar

In the last episode (Nov 19), Benjamin Pflugmann said: > On Mon 2002-11-18 at 19:01:57 -0500, [EMAIL PROTECTED] wrote: > [...] > > A BITMAP index will work efficiently in this case, no matter what > > the distribution of the keys is. The only requirement is that the > > column be low-cardinality.

How to turn on/off log_bin while mysql is running?

I'm setting up two servers as one master and one slave, and the slave will take over master's role when the original master fails. I'd like to turn off log_bin in slave and turn on it only when the slave becomes a master. Is it possible? query like "SET GLOBAL log_bin=ON" d

fulltext, trying to index 2 character words

I'm using mysql fulltext indexes and want them to see words of 2 or more characters, and no stopwords. I've edited the appropriate files (ftdefs.h, ft_static.c), then recompile, install, restart mysql, rebuild indexes, and there is no change. It still uses a minimum of 4 characters). I'm using

cmd load is not allowed in ver3.23.53???

HI Does any one encounter the same problem?? If load cmd in not working in ver3.23.53, is there any alternative cmd for loading table??? Thanks vinita # mysql> select version(); +---+ | version() | +---+ | 3.23.33 | +

Re: MySQL Left Join Query

Here's a mini-tutorial on left join that should solve your problem. First, let's make a smaller example. (It would have been helpful if you had done that and formatted your select so it could be read when you posted the question ;-) Here are 2 tables: select * from header;select * f

Re: MySQL, Perl 5.8 vs Perl 5.6

Were you able to install the module DBD::mysql with perl 5.8??? Have you used ppm? I was fighting a lot to install the DBD::mysql with perl 5.8 but it told me that a PPD file for this package could not be found. I found another module named DBD::mysqlPP for pure perl and it works in the same way.

InnoDB != FULLTEXT?

I'm interested in using InnoDB, but am loathe to give up FULLTEXT indexing. Anyone (Heikki?) know why this is so, and if it is likely to be changed in the future? -- SQL SQL SQL SQL SQL SQL SQL SQL : Jan Steinman -- nature Transography(TM): : Bytesmiths -- a

Re: feature suggestion - indexes with "where" clause or similar

Hi. On Mon 2002-11-18 at 19:01:57 -0500, [EMAIL PROTECTED] wrote: [...] > A BITMAP index will work efficiently in this case, no matter what the > distribution of the keys is. The only requirement is that the column be > low-cardinality. > > It basically works like this: > > true 01101 > f

RE: relay log keeps growing. ;(

I apologize to annonying the mailing list with repeated questions. :( I'd found the variable, max_binlog_size as Jeremy said, and all seem to go well. ;) Thanks. -- Chung Ha-nyung Sayclub NeoWiz > -Original Message- > From: Jeremy

Re: Creating foreign key

HI still not working :-( I didn't do the installation , Do we need to set any option specifically during the installation for foreign key to work?? mysql> CREATE TABLE unit ( -> unitCode CHAR(20) NOT NULL, -> unitName CHAR(50), -> unitYear CHAR(20) NOT NULL, -> PRIMARY KEY (unitCode

Re: feature suggestion - indexes with "where" clause or similar

On Mon, 2002-11-18 at 16:22, Michael T. Babcock wrote: > Neulinger, Nathan wrote: > > >It's actually relatively speedy WITH the bad index, but maintaining that > >index (given it's lopsided nature) is very expensive. > > > >Yes, the point is to ONLY index the row if it matches the restriction. >

Re: Newbie Replication Issues

At 15:45 -0500 11/18/02, Rick Root wrote: I have a few questions about Replication. I've already read the basic replication page here: http://www.mysql.com/doc/en/Replication_HOWTO.html I am running MySQL-MAX 3.23.53 for Linux on my master server, and the same version on Windows 2000 for the

Re: java.sql.SQLException: Communication link failure

Ravil A. Desai wrote: I check many places and tried various options, including autoConnect=true option to JDBC connect string, but I am still getting following exceptions. I am using DbVisualizer as a client on Windows 2000 and mysqld is running on my Redhat 8.0 Linux machine. I am using "com.m

Re: simple question

At 17:19 -0600 11/18/02, Carter, Scott wrote: I want to sort my results by a date that is contained in the database table the query is performed on. The ORDER BY clause does not seem to do the trick. How do you do this? Thanks - Scott Carter With ORDER BY. You'll have to provide more details

Re: [Feature or Bug] Data Types: DECIMAL and DOUBLE

Hello. On Mon 2002-11-18 at 15:35:40 -0800, [EMAIL PROTECTED] wrote: > Where can we find the info regardng on the DOUBLE precision > 15 or 16? I searched the doc. and unable to locate it. I don't know. If I had a manual reference handy, I would have included it. My answer was just common (compute

Re: current connections to server

On Mon, Nov 18, 2002 at 03:59:15PM -0600, Robert Citek wrote: > > Is there a way to get information about current connection to a MySQL > server? Specifically, I would like to know how many users are currently > connected, who they are, from where, what databases are being used, etc. > > I've br

java.sql.SQLException: Communication link failure

I check many places and tried various options, including autoConnect=true option to JDBC connect string, but I am still getting following exceptions. I am using DbVisualizer as a client on Windows 2000 and mysqld is running on my Redhat 8.0 Linux machine. I am using "com.mysql.jdbc.Driver" as my JD

Upgrading mysql with mysql binary vs. compiling

Is there any reason I should use my MySQL supplies binaries to upgrade my currently installed version? I compile the running version (3.23.49). Is there any difficulty in doing this? Any pitfalls to watch out for, or should I just continue to compile my own and upgrade via that path? - Greg --

simple question

I want to sort my results by a date that is contained in the database table the query is performed on. The ORDER BY clause does not seem to do the trick. How do you do this? Thanks - Scott Carter - Before posting, please che

Sorta OT: Perl/MySQL Mail List Module?

Greetings, This may be a bit OT, but does anyone know of a good perl/cgi module that works with DBI (MySQL) to write a mailing list? PLMK, Thanks, Will _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.ms

Re: Newbie Replication Issues

Yes, you can replicate from Linux to Win2K ... but both servers have to be properly configured. Did you edit my.cnf on your Linux machine so it knows it is the Master (Win2K would be the Slave)? - Original Message - From: "Rick Root" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monda

current connections to server

Is there a way to get information about current connection to a MySQL server? Specifically, I would like to know how many users are currently connected, who they are, from where, what databases are being used, etc. I've browsed and searched the mysql manual and found the SHOW STATUS command (htt

Mysql and use rmanagement

I have a 'simple' question regarding the mysql privileges. The database at home: version 4.04 beta max all of my tables are innodb tables. (except the mysql privileges table) As of version 4.02 of mysql the database supports the use of MAX_QUERIES_PER_HOUR, MAX_CONNECTIONS_PER_HOUR and MAX_UPDAT

Re: feature suggestion - indexes with "where" clause or similar

Neulinger, Nathan wrote: It's actually relatively speedy WITH the bad index, but maintaining that index (given it's lopsided nature) is very expensive. Yes, the point is to ONLY index the row if it matches the restriction. To clarify, if MySQL is indexing a binary value with lopsided distr

Re: feature suggestion - indexes with "where" clause or similar

On Tue, Nov 19, 2002 at 07:12:27AM +1100, Dean Harding wrote: > Actually, it's a slightly different problem - a very uneven distribution > of values on a column, not a small number of possible values like a > bitmap index is for. Exactly. > In my opinion, this is a pretty useless feature, I mean

Newbie Replication Issues

I have a few questions about Replication. I've already read the basic replication page here: http://www.mysql.com/doc/en/Replication_HOWTO.html I am running MySQL-MAX 3.23.53 for Linux on my master server, and the same version on Windows 2000 for the slave. #1 - Can I replicate from Linux to

Re: MySQL + PHP : "Commands out of sync; You can't run thiscommand now"

At 18:24 +0100 11/18/02, Antoine wrote: Hi, I'm having weird errors right now, running MySQL queries from PHP as an Apache module. Sometimes (in a seemingly random way) some queries fail and mysql_error() displays "Commands out of sync; You can't run this command now". I would say it seems to hap

Re: FLoat, double, decimal, bah, foo, bar

Benjamin Pflugmann wrote about SQL: First, please stop cross posting. Pick one list and stay with it. Only post on another list if you get no reply for some time. Aside from that, one can argue if that belongs to the win32 list, but what has this to do with java at all? Totally aside from the

RE: mysql return days in month?

Exactly... That's why Rogers solution is good (and future proof) and my solution is bad! I was illustrating that point by using 2004-02 in the example.. Andrew -Original Message- From: Pae Choi [mailto:[EMAIL PROTECTED]] Sent: 18 November 2002 22:56 To: Andrew Braithwaite; [EMAIL PRO

Re: [Feature or Bug] Data Types: DECIMAL and DOUBLE

Where can we find the info regardng on the DOUBLE precision 15 or 16? I searched the doc. and unable to locate it. JDBC mm.mysql-2.0.14-bin.jar + MySQL v3.23.52-MAX on WinNT. Regards, Pae > > CREATE TABLE account (id INTEGER, balance DECIMAL(20, 2), col_double > > DOUBLE(20,2)); > > > > And we

RE: Mysql & Encryption

You could do something like (I repeat something like, you may need to modify) http://tjw.org/chroot-login-HOWTO/ or you could put something like this in thier startup script (this will disconnect when they press a key) Maybe in .bash_profile in the users home directory echo press any key to clos

RE: feature suggestion - indexes with "where" clause or similar

The problem is - a whole table scan in this case is not faster. It's a LOT slower. Table only has about 180,000 rows right now, but it's going to get up to about half a million. It's actually relatively speedy WITH the bad index, but maintaining that index (given it's lopsided nature) is very exp

RE: feature suggestion - indexes with "where" clause or similar

Actually, it's a slightly different problem - a very uneven distribution of values on a column, not a small number of possible values like a bitmap index is for. In my opinion, this is a pretty useless feature, I mean the whole *point* of the optimizer is to see things like that and do a full tabl

Re: [Feature or Bug] Data Types: DECIMAL and DOUBLE

No execuse! My appologies for the cross posting. Your advice is well accepted. Also thank you for your explaination regarding on my inquiry as well. Regards, Pae - Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Pae Choi" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTE

Re: Please help with strange Win2K error

Dear Jocelyn, > > On Win2K with MySQL 4.0.4 I get this error with a MyISAM table: > > mysql> ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL > > PRIMARY KEY; > > ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to > > '.\trainee\#sql2-648-2.MYI' (Errcode: 13) > Perror 13 means :

MySQL connect failure

I will occasionally get the following message in some of my cronjobs: Mysql->connect(database=mb_pw;host=localhost) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) at /usr/home/members/filter/Filter.exe line 15 Can't connect to local MySQL server through socke

Re: mysql return days in month?

Not all Feb. has 28 days. It depends on whether it is a lunar year or not. So Some Feb. will have 28 days and some have 29 days. Pae - Original Message - From: "Andrew Braithwaite" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "'Roger Baklund'" <[EMAIL PROTECTED]> Sent: Monday, Novemb

syntax problem with replicate-rewrite-db

Hi All, Running mysql 3.23.52-max binary on a RedHat 7.2 based server. Replication is working fine, but I'm running into errors with the replicate-rewrite-db directive. Here's a snippet from my my.cnf file on the slave: master-port = 3306 replicate-rewrite-db=mysql->master_mysql When I

Foreign (Non-English) characters

I'm running MySQL 323 under Win 2000 SP2. I'm using Apache 2.0.43 and Cold Fusion MX. I have this Cold Fusion application that has worked well under MS-Access but when i ported it to MySQL the Swedish characters ÅÖÄ åöä in the Memo-fields just won't show! I'm getting '???' instead of a readable

Re: [Feature or Bug] Data Types: DECIMAL and DOUBLE

Hello. First, please stop cross posting. Pick one list and stay with it. Only post on another list if you get no reply for some time. Aside from that, one can argue if that belongs to the win32 list, but what has this to do with java at all? On Mon 2002-11-18 at 09:07:42 -0800, [EMAIL PROTECTED

Re: The licence of mysql

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 18 November 2002 16:46, Dyego Souza do Carmo wrote: > MySQL Classic (Commercial License) > Similar to MySQL Standard, but *without* InnoDB and only available as a > commercial licensed version. > > MySQL Pro (Commercial) > Similar to MySQL S

Re: Please help with strange Win2K error

Hi, Perror 13 means : perror 13 Error code 13: Permission denied So it seems you don't have the permission to create the temporary table is this directory. Regards, Jocelyn - Original Message - From: "Stefan Hinz" <[EMAIL PROTECTED]> To: "MySQL Main List" <[EMAIL PROTECTED]> Sent: M

RE: Mysql & Encryption

As far as I know you have to have a shell account to use ssh tunnels, am I right? If so this may be a concern for some. Mike -Original Message- From: Muir, Michael (OTS-EDH) [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 11:01 AM To: 'Andy Eastham'; Mysql@Lists. Mysql. Com S

Re: redhat8 mysql remote connections

In the last episode (Nov 18), Kevin Quinn said: > I sent a bug report earlier and have had some responses of others with > the same problems. > > is there *anyone* on this list that is running redhat8 (with the > mysql on the redhat install disks) and can query from remote > machines? > > when I

Re: redhat8 mysql remote connections

Kevin Quinn wrote: I sent a bug report earlier and have had some responses of others with the same problems. is there *anyone* on this list that is running redhat8 (with the mysql on the redhat install disks) and can query from remote machines? when I connect to port 3306 the process instantly

Re: feature suggestion - indexes with "where" clause or similar

On Mon, 2002-11-18 at 12:29, Jeremy Zawodny wrote: > > If I've got you right status can have values 0 or 1. In this case > > you can just use " SELECT ... WHERE status=1 .." (index wil be used) > > or "SELECT .. WHERE status=0 .." (index will not be used, because > > scan the whole table will be f

RE: Insert row in x for every row in y

On 18 Nov 2002, at 12:03, Adam Nelson wrote: > insert group_map (user_id,group_id) select user_id,"6" as any_label from > user There's no need for any_label in that query, since you're not using it for anything: INSERT group_map (user_id, group_id) SELECT user_id, 6 FROM user; -- Keit

Re: CPU Load extremely high with MySQL 4.0.4

> > With 3.23.53a everything works fine. > > MySQL 4.0.4 was compiled against a wrongly built glibc, which leads to the > above mentioned behaviour. Please download MySQL 4.0.5, which has just been > released and should fix this problem: :( Sadly, 4.0.5 does _not_ fix this issue. I just tried it

Re: mysql from redhat8 will only run one process and remoteconnections die.

I'm running 8.0 (which according to that link is unaffected) and I have the same problem (except I compiled from source). Any ideas? On Mon, 2002-11-18 at 12:16, Joseph Bueno wrote: > Try to upgrade glibc: > https://rhn.redhat.com/errata/RHSA-2002-197.html > > > > [EMAIL PROTECTED] wrote: >

Re: MySQL + PHP : "Commands out of sync; You can't run this command now"

Comment out the body of the _restore_connection_defaults in php_mysql.c file in PHP. Recompile, etc. Or don’t use persistent connections. Should be fixed in PHP 4.3.   See http://bugs.php.net/?id=19529 for more info. Sincerely, Steven Roussey http://Network54.com/   -

Re: MySQL + PHP : "Commands out of sync; You can't run this command now"

Hi, It's known bug of PHP, which has just been fixed in 4.3 CVS. Use mysql_connect instead of mysql_pconnect as a workaround of the problem. (or get the latest CVS version of php 4.3.0) For more infos : http://bugs.php.net/bug.php?id=19529 Regards, Jocelyn - Original Message - From:

Re: mysql from redhat8 will only run one process and remote connectionsdie.

after pawing through octobers messages on this mailing list I found out that I can put the requesting ip's in /etc/hosts and everything is ok. must be some bad mojo in glibc's resolver. (I would hope redhat would come out with erratta for redhat8) k Joseph Bueno wrote: Try to upgrade glibc:

Please help with strange Win2K error

Dear list, sorry for bothering you again, but no one has answered to my request for help so far, not even Jeremy Z. who *I know* can solve every and any problem remotely ;-) On Win2K with MySQL 4.0.4 I get this error with a MyISAM table: mysql> ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGN

MySQL/InnoDB-4.0.5 is released

Hi! InnoDB is a MySQL table type which supports transactions, row level locking, foreign keys, and a non-free hot backup tool. InnoDB is included in all downloads of MySQL-4.0. Of the commercially licensed versions, MySQL-Pro contains InnoDB. Release 4.0.5 contains a feature which application pro

RE: Mysql & Encryption

PuTTY is a nice freeware SSH client. http://www.chiark.greenend.org.uk/~sgtatham/putty/ -mike > -Original Message- > From: Andy Eastham [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 18, 2002 8:39 AM > To: Mysql@Lists. Mysql. Com > Subject: RE: Mysql & Encryption > > > Don

Re: Replication Errors

Jeremy Zawodny wrote: I hate to ask this, bug did you change anything? :-) In the data? Heck ya :-) ... the versions of the software? No -- although either of them has restarted / flushed logs from time to time as necessary (I don't have a log rotation program yet for the binary logs mind

redhat8 mysql remote connections

I sent a bug report earlier and have had some responses of others with the same problems. is there *anyone* on this list that is running redhat8 (with the mysql on the redhat install disks) and can query from remote machines? when I connect to port 3306 the process instantly dies... k -- Kevin

Re: Replication Errors

On Mon, Nov 18, 2002 at 11:47:48AM -0500, Michael T. Babcock wrote: > Any suggestions? This is a live DB ... > > 021118 10:43:47 InnoDB: Started > /usr/libexec/mysqld: ready for connections > 1254 021118 10:43:49 Slave: connected to master > '[EMAIL PROTECTED]:3303', replication started in lo

Re: Newbie: interfacing to MySQL?

not sure what you're after, but here's one: if you have windows boxes for frontends, take a look at http://corereader.com it's a free query tool that's designed to simplify the query operation for administrators and users. after you connect, it's entirely point and click. it'll query anyth

Re: MySQL + PHP : 'Commands out of sync; You can't run this command now'

Just replying to myself... After replacing mysql_pconnect() with mysql_connect(), the problems seems gone so far. So chances are it is a bug on the PHP side. Regards Antoine. > Hi, > > I'm having weird errors right now, running MySQL queries from PHP as an > Apache module. Sometimes (in a seem

Re: Has binlog format changed from 3.23.X to 4.0.4?

On Mon, Nov 18, 2002 at 05:41:51PM +0100, Stefan Bohm wrote: > > when upgrading the master in a master slave setup from 3.23.x to > 4.0.x or downgrading back to 3.23.x the binlog seems to be corrupt > for the slaves. I get error messages like "binlog truncated" or > 'unexpected success or fatal e

Re: Mysql & Encryption

Have you considered putting your databases on an encrypted filesystem ? You don't need to add anything to mysql and those filesystems already exist (although I have not yet used them). Regards, Joseph Bueno mos wrote: > At 08:15 AM 11/18/2002, you wrote: > > > * Alexandre Aguiar > > > On 14 Nov

Re: relay log keeps growing. ;(

On Fri, Nov 15, 2002 at 05:55:07PM +0900, Chung Ha-nyung wrote: > > Dear, > > I'm so sorry that nobody didn't answer for my question, which asked > about the condition relay log files are deleted in replication slave > server. Anyway. Although somebody said that the files will be > deleted aut

Re: relay log keeps growing. ;(

On Fri, Nov 15, 2002 at 05:55:07PM +0900, Chung Ha-nyung wrote: > > Dear, > > I'm so sorry that nobody didn't answer for my question, which asked > about the condition relay log files are deleted in replication slave > server. Anyway. Although somebody said that the files will be > deleted aut

Re: feature suggestion - indexes with "where" clause or similar

On Mon, Nov 18, 2002 at 05:38:00PM +0200, Egor Egorov wrote: > Neulinger, > Friday, November 15, 2002, 7:25:27 PM, you wrote: > > NN> Assume I have a mysql table (myisam most likely) with a few hundred > NN> thousand rows in it. One of the columns indicates success or failure. > NN> 99.9% of the r

MySQL + PHP : "Commands out of sync; You can't run this command now"

Hi, I'm having weird errors right now, running MySQL queries from PHP as an Apache module. Sometimes (in a seemingly random way) some queries fail and mysql_error() displays "Commands out of sync; You can't run this command now". I would say it seems to happen when different queries are launched

Re: Disappearing records?

Greg Macek wrote: That's the weird part of it. Last week in reviewing the system, making sure reports were working I can personally verify his stuff was in there (not even logged on as him). This week: nothing. Is there any record of 3.23.49 ever having random data loss issues? Related to somethi

WinMySQLadmin ?eating memory

I have just updated from MySQL 3.23.51 to 4.0.4 on my Win2000 Prof SP2 portable, and shortly afterwards noted some runaway problem was consuming memory. Left long enough, Windows eventually starts bleating about its amount of virtual memory; obviously things start to thrash, and apps gradually grin

Re: mysql from redhat8 will only run one process and remote connectionsdie.

Try to upgrade glibc: https://rhn.redhat.com/errata/RHSA-2002-197.html [EMAIL PROTECTED] wrote: > >Description: > > I just installed redhat8 this weekend and am using the rpm's provided > by them. when mysql runs it will only run a single process. and even > worse... when I try and connec

RE: Disappearing records?

Greg Macek said.. --- >>I have a problem that I could use some help with. We're running a mysql/php intranet site for time sheets (home grown solution). However from time to time a user will tell me hours from the previous week are just "gone". I go to look and s

Re: Disappearing records?

I'll look into the code on the PHP side (since I wrote that too). Maybe it is something I did. :) I may avoid repairing the tables for now, since the missing records have already been re-entered and I don't want to risk anything being duplicated at this point. Perhaps I'll drop all the indexes for

listing a count of unique ips by day

Hi! I've had a good look through the documentation and here is where I am: I'm logging users coming in to a web site, by ip address column called ip and by dateIn (a timestamp of 14 bytes). I'd like to list (one row per day) the COUNTs of unique (DISTINCT) ip addresses. I'd also like to have t

RE: MySQL Left Join Query

An update to my earlier post. I'm getting a bit closer but still not there. In the following query: select decheader.code, decheader.height, decheader.width, decplacement.position, decplacement.product from decheader left join decplacement on decheader.code = decplacement.code and (decheader.code

RE: Insert row in x for every row in y

You can use insert group_map (user_id,group_id) select user_id,"6" as any_label from user > -Original Message- > From: Zabel, Ian [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 18, 2002 11:35 AM > To: [EMAIL PROTECTED] > Subject: Insert row in x for every row in y > > > I've hav

Re: Disappearing records?

In the last episode (Nov 18), Greg Macek said: > That's the weird part of it. Last week in reviewing the system, > making sure reports were working I can personally verify his stuff > was in there (not even logged on as him). This week: nothing. Is > there any record of 3.23.49 ever having random d

is it a bad installation ?

Hi, I just install MySQL-3.23.53 on a redhat-7.2. I believe I did it quite correctly *after several attempts*. So I intended to benchmark my server. So in /usr/local/mysql/mysql-test, I run this: # ./mysql-test-run And then I got the mysqld is missing in /usr/local/mysql/bin... I read in th

Re: MySQL quits serving on Mac OS X Server 10.2

On Mon, Nov 18, 2002 at 09:54:21AM -0600, Dan Nelson wrote: > In the last episode (Nov 18), Lenz Grimmer said: > > You have experienced a bug that Mac OS X seems to have inherited from > > FreeBSD, which shows a similar behaviour. For a very detailed > > description, see this entry in Jeremy's blog

Replication Errors

Any suggestions? This is a live DB ... 021118 10:43:47 InnoDB: Started /usr/libexec/mysqld: ready for connections 1254 021118 10:43:49 Slave: connected to master '[EMAIL PROTECTED]:3303', replication started in log 'FIRST' at position 31804350 ' at line 1 ERR

Re: Mysql & Encryption

At 08:15 AM 11/18/2002, you wrote: * Alexandre Aguiar > On 14 Nov 2002 Fraser Stuart shaped the electrons to write something > about [Mysql & Encryption] > > > We are about to embark on a project that requires data encryption - > > mainly to stop sensitive information being viewed accidentally (ie

Re: Disappearing records?

That's the weird part of it. Last week in reviewing the system, making sure reports were working I can personally verify his stuff was in there (not even logged on as him). This week: nothing. Is there any record of 3.23.49 ever having random data loss issues? Related to something else on the syste

Has binlog format changed from 3.23.X to 4.0.4?

Hello list, when upgrading the master in a master slave setup from 3.23.x to 4.0.x or downgrading back to 3.23.x the binlog seems to be corrupt for the slaves. I get error messages like "binlog truncated" or 'unexpected success or fatal error' on query '' I always have to copy the whole DB to the

Rulebase for MySQL

Hi--- I'm working on a rulebase for MySQL (a final project for a DB graduate course) and was wondering whether anything similar has been attempted in the past. This would be a logical system in the flavor of POSTGRES. Thanks!--- Jinger Zhao (214) 450-6845 http://www.people.fas.harvar

RE: Mysql & Encryption

Don't forget that SSH (eg OpenSSH) can tunnel regular port connections too. This is dead easy to set up with a client such as "SecureCRT" from Van Dyke, but this is a paid product (although worth the money in my opinion - I own it). They also do "Entunnel" which is cheaper product which just doe

mysql from redhat8 will only run one process and remote connections die.

>Description: I just installed redhat8 this weekend and am using the rpm's provided by them. when mysql runs it will only run a single process. and even worse... when I try and connect to port 3306 (even via telnet) the process is immediately killed and safe_mysqld restarts it. it logs the f

Re: Disappearing records?

In the last episode (Nov 18), Greg Macek said: > Hello, > > I have a problem that I could use some help with. We're running a > mysql/php intranet site for time sheets (home grown solution). However > from time to time a user will tell me hours from the previous week are > just "gone". I go to loo

Insert row in x for every row in y

I've having trouble figuring out the SQL to do this. I have two tables, user, and group_map, and I want to insert a row into group_map for every row in user. user user_id group_map user_id group_id For each user_id: insert into group_map ( user_id, group_id )

Disappearing records?

Hello, I have a problem that I could use some help with. We're running a mysql/php intranet site for time sheets (home grown solution). However from time to time a user will tell me hours from the previous week are just "gone". I go to look and sure enough, no hours have been entered. I have not b

Re: MySQL quits serving on Mac OS X Server 10.2

In the last episode (Nov 18), Lenz Grimmer said: > You have experienced a bug that Mac OS X seems to have inherited from > FreeBSD, which shows a similar behaviour. For a very detailed > description, see this entry in Jeremy's blog > > http://jeremy.zawodny.com/blog/archives/000264.html#000264 >

RE: mysql return days in month?

Thanks for solving this all, I have do something ugly because I only have the -mm (3rd party DB) which ends up like this: Mysql> select dayofmonth((concat('2004-02','-01') + interval 1 month) - interval 1 day); Urrggg ;) Still, much more graceful (and more future proof) than what I just cam

The licence of mysql

MySQL Classic (Commercial License) Similar to MySQL Standard, but *without* InnoDB and only available as a commercial licensed version. MySQL Pro (Commercial) Similar to MySQL Standard (*including* InnoDB), but only available as a commercial licensed version. What is the diference in (Comm

re: feature suggestion - indexes with "where" clause or similar

Neulinger, Friday, November 15, 2002, 7:25:27 PM, you wrote: NN> Assume I have a mysql table (myisam most likely) with a few hundred NN> thousand rows in it. One of the columns indicates success or failure. NN> 99.9% of the rows will have "0" in that column. But a small number will NN> have 1. I n

re: another field type bigger then varchar

Ivan, Monday, November 18, 2002, 7:02:33 AM, you wrote: IP> i want to change my field type from varchar(255) into varchar2(1024) --- (as IP> i use in oracle) IP> can i use this in mysql? anyway i don't wanna use tinyblob/mediumblob... Use TEXT column type: http://www.mysql.com/doc/en/Column_t

Re: mysql return days in month?

* Andrew Braithwaite > Can anyone help? I want to know if there is an easy way to return the > number of days in a month from mysql. > > Ideally there would be a function that did the following... > > mysql> SELECT DAYSINMONTH('2002-10'); > +---+ > | DAYINMONTH('2002-10') |

Re: MySql JDBC

What version of MySQL JDBC are you using? Scott Pippin [EMAIL PROTECTED] >>> "jsplist" <[EMAIL PROTECTED]> 11/16/02 12:13PM >>> Hello ! , Im running Tomcat on a Windows machine and Ive got my CLASSPATH pointing to c:\tomcat\lib\mysql.jar . Then in my webapps folder I have a web application cl

  1   2   >