Re: a curse on OS sierra and MySQL?

2016-12-03 Thread Martin Mueller
/mysql/support-files/mysql.server start starts it On 12/3/16, 4:40 PM, "Peter Brawley" <peter.braw...@earthlink.net> wrote: On 12/3/2016 13:58, Martin Mueller wrote: > I was able to install a version of MySQL 5.6 on OS Sierra. It appears that the “launchdaemon’

rescue Inno tables from an abandoned data directory?

2016-12-03 Thread Martin Mueller
I abandoned a MySQL 5.22 database that quite suddenly andthat I wasn’t able to start up again. The data directory consists of a mix of ISAM and Inno tables. I was able to copy the ISAM tables into a new 5.6 version, and they work. I understand that INNO tables are different because different

Re: a curse on OS sierra and MySQL?

2016-12-02 Thread Martin Mueller
nk.net> wrote: On 12/2/2016 16:59, Martin Mueller wrote: > I have been trying repeatedly and in vain to install the community edition of MySQL 5.7.16 on an iMac running OS sierra. I religiously followed the instructions for uninstalling previous versions found at https://urldefens

a curse on OS sierra and MySQL?

2016-12-02 Thread Martin Mueller
I have been trying repeatedly and in vain to install the community edition of MySQL 5.7.16 on an iMac running OS sierra. I religiously followed the instructions for uninstalling previous versions found at http://community.jaspersoft.com/wiki/uninstall-mysql-mac-os-x, and installation

Re: MySQL Platform Migration

2016-09-11 Thread Martin Mueller
. And biting your tongue might be a good thing for others MM Martin Mueller Professor emeritus of English and Classics Northwestern University On 9/11/16 12:27 PM, "Ryan Coleman" <ryan.cole...@cwis.biz> wrote: >Because they want to be belittled by european jackasses online. > >

... ERROR! The server quit without updating PID file

2016-07-04 Thread Martin Mueller
and unknown dependencies in that approach? Martin Mueller Professor emeritus of English and Classics Northwestern University

Re: parallel installations of mysql

2016-07-02 Thread Martin Mueller
on writing called the “curse of ignorance,” the fact that one neither knows nor cares about what the other person doesn’t know. On 7/2/16, 9:11 PM, "Hal.sz S.ndor" <h...@tbbs.net> wrote: 2016/07/02 18:49 ... Martin Mueller: > It’s clear from Section 6.6 of the Reference

Re: parallel installations of mysql

2016-07-02 Thread Martin Mueller
organized functions, and it’s a joy to work with once you have it actually installed an running. I’ll be grateful for any help. Martin Mueller Professor emeritus of English and Classics Northwestern University On 4/21/16, 5:42 PM, "shawn l.green" <shawn.l.gr...@oracle.com> w

corrupt INNO table

2016-07-02 Thread Martin Mueller
I run MySQL 5.6 on OS 10.11. There is a table that appears to be corrupt: it does not respond to queries, and the command to drop it does not execute. The database seems to be OK in other respects. What can I do to get rid of the table? Would it be safe just to remove the two .frm and .ibd

utf8 options under Mysql

2016-04-21 Thread Martin Mueller
MySQL has a bewildering variety of unicode collation choices. Most of them are language specific, but what is the difference between "utf8-general-ci", "utf8-unicode-ci", and "utf8-unicode-520-ci." Do they differ in the range of characters they can handle or is it just a matter of the cort

parallel installations of mysql

2016-04-20 Thread Martin Mueller
keep the old along the new, just in case something goes wrong/ My friends tell me to use sqlite, and they are probably right since file management is so much simpler. But I find the many builtin functions of MySQL very helpful and don't particularly want to learn a new set. Martin Mueller

moving inno tables

2015-08-20 Thread Martin Mueller
are identified as not existing, although it is there on the hard drive with substantial byte counts. Is there something I can do about this or is it an intrinsic problem to moving INNO tables? Martin Mueller Professor emeritus of English and Classics Northwestern University -- MySQL General

Re: password problem

2015-07-31 Thread Martin Mueller
path mention, but neither does the my.cnf file on a laptop, which works. So there seems to be nothing wrong with the location or content of the my.cnf file. On Fri, Jul 31, 2015 at 5:11 AM, Martin Mueller martinmuel...@northwestern.edumailto:martinmuel...@northwestern.edu wrote: I have installed

Re: password problem

2015-07-31 Thread Martin Mueller
not a very experienced programmer and have trouble wrestling with the command line. But I think I did my due diligence and didn't find any open doors. Martin Mueller Professor emeritus of English and Classics Northwestern University On 7/31/15 3:36 AM, Reindl Harald h.rei...@thelounge.net wrote

Re: password problem

2015-07-31 Thread Martin Mueller
help you a lot to practice a little courtesy and refrain from vulgar language. Martin Mueller Professor emeritus of English and Classics Northwestern University On 7/31/15 9:12 AM, Reindl Harald h.rei...@thelounge.net wrote: Am 31.07.2015 um 15:40 schrieb shawn l.green: 1. Log on to your

pid-file quite

2015-07-31 Thread Martin Mueller
and MySQL is a very popular database. So I don't quite understand why very basic installation and operating procedures are so complicated. Martin Mueller Professor emeritus of English and Classics Northwestern University On 7/31/15 8:40 AM, shawn l.green shawn.l.gr...@oracle.com wrote: On 7/31

password problem

2015-07-30 Thread Martin Mueller
uninstalled and re-installed the program, but the results are always the same. Martin Mueller Professor emeritus of English and Classics Northwestern University -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

installation problem of MySQL on OS Lion

2015-07-29 Thread Martin Mueller
I installed MySQL on a Mac Pro running OS Lion. The installation was successful, but starting the mysql server generated the following error message: Martin-Muellers-Mac-Pro:~ martin$ sudo /usr/local/mysql/support-files/mysql.server start Starting MySQL ... ERROR! Manager of pid-file quit

Re: create_time

2015-05-04 Thread Martin Mueller
:-) - Original Message - From: Johan De Meersman vegiv...@tuxera.be To: Pothanaboyina Trimurthy skd.trimur...@gmail.com Cc: Martin Mueller martinmuel...@northwestern.edu, MySql mysql@lists.mysql.com Sent: Monday, 4 May, 2015 16:11:24 Subject: Re: create_time That sounds logical. I have

Re: create_time

2015-05-01 Thread Martin Mueller
months all of a sudden showed a create_time that was more or less identical with the last update of the table. Which surprised me. From: Pothanaboyina Trimurthy skd.trimur...@gmail.commailto:skd.trimur...@gmail.com Date: Friday, May 1, 2015 at 12:15 AM To: Martin Mueller martinmuel

create_time

2015-04-30 Thread Martin Mueller
I had thought that MySQL remembers the date when a table is first created and stores it in the create_time column of Information Schema. But this doesn¹t seem to be the case.On my machine it seems to record the date of most recent access. Which seems odd. Am I doing something wrong? Is there a

time stamp specific to columns

2015-04-08 Thread Martin Mueller
I understand how a timestamp column automatically changes when there is a change in a data row. Is it possible to limit the update to changes in particular columns? I have a table where I care about changes in any of four different columns, but I don¹t care about changes in other columns or added

RE: Users and Groups

2015-03-04 Thread Martin Gainty
Date: Wed, 4 Mar 2015 14:04:55 +0100 From: vegiv...@tuxera.be To: lu...@lambrate.inaf.it CC: mysql@lists.mysql.com Subject: Re: Users and Groups That reminds me, this may be of interest: http://www.percona.com/blog/2015/03/02/emulating-roles-percona-pam-plugin-proxy-users/ MGtrès

RE: How to retrieve next record?

2014-12-11 Thread Martin Gainty
) { // start while $row = mysqli_fetch_array($res); //get the NEXT record from the resultset $res $rowcount = $rowcount + 1; } } //end res!=null } //end $con!=null Martin Gainty

update and control flow

2014-12-09 Thread Martin Mueller
COMMENT = 'b' END IF But this gives me an error message. What am I doing wrong? MM Martin Mueller Professor emeritus of English and Classics Northwestern University -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: unicode case insensitive but diacritics sensitive

2014-11-25 Thread Martin Mueller
Thanks for that answer. It squares with my solution: have an additional column that has the lower case values of the case sensitive unicode setting. Martin Mueller Professor emeritus of English and Classics Northwestern University On 11/25/14 6:48 AM, Rik r...@grib.nl wrote: Not a unicode

unicode case insensitive but diacritics sensitive

2014-11-24 Thread Martin Mueller
Is there a unicode setting on mysql that is case insensitive but diacritics sensitive? Given 'Ete', 'été', 'ete' a group by routine for such a setting would return two values: 'été', 'ete'. I couldn't find it, but I may not have known where to look. Martin Mueller Professor emeritus

RE: Query on some MySQL-internals

2014-09-07 Thread Martin Gainty
to determine if there is an intervening router that is slowing down the second instance? Does anyone have advice to get Ajay to track down why his second instance is non-preformant ? Martin

table comments

2014-09-07 Thread Martin Mueller
or some notebook where you never find it again? Martin Mueller Professor emeritus of English and Classics Northwestern University

RE: Query on some MySQL-internals

2014-09-06 Thread Martin Gainty
Date: Sat, 6 Sep 2014 14:26:22 +0530 Subject: Query on some MySQL-internals From: ajaygargn...@gmail.com To: mysql@lists.mysql.com Hi all. We are facing a very strange scenario. We have two mysql-instances running on the same machine, and they had been running functionally fine

RE: database developer tool Database Workbench 5 now available

2014-09-05 Thread Martin Gainty
From: m.ton...@upscene.com To: j...@ecoreality.org; mysql@lists.mysql.com Subject: Re: database developer tool Database Workbench 5 now available Date: Fri, 5 Sep 2014 07:57:37 +0200 Hello Jan, list, From: Martijn Tonies (Upscene Productions) m.ton...@upscene.com Database

RE: inconsistent optimization

2014-08-20 Thread Martin Gainty
Jim/Jaime What engine are you implementing?/ Qual mecanismo de MySQL que você está implementando? Saludos desde Sud America Martín Date: Wed, 20 Aug 2014 13:54:46 -0300 Subject: Re: inconsistent optimization From: edua...@gerencianet.com.br To: j...@lowcarbfriends.com CC:

RE: Proxy / connected failover question

2014-07-09 Thread Martin Gainty
CC: vegiv...@tuxera.be; mysql@lists.mysql.com From: wagnerbianch...@gmail.com Subject: Re: Proxy / connected failover question Date: Wed, 9 Jul 2014 08:31:05 -0300 To: walterh...@olindata.com I like HAProxy as well as it simplifies many of the things you seem to be looking for. --

RE: mysqlcheck downtime 30 minutes for Java web application

2014-06-12 Thread Martin Gainty
Start Here to analyze your tables Martin Gainty

RE: mysqlcheck downtime 30 minutes for Java web application

2014-06-12 Thread Martin Gainty
I would recommend start Here to analyze your tables: http://dev.mysql.com/doc/refman/5.1/en/analyze-table.html Once you have evidence of FTS or unbalanced index entries then optimise http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html Martin Gainty

Long integer constant problem in views

2013-04-30 Thread Martin Koch
'36a461c81cab4016' 16 | X'9791f49ad65a3728'; Unfortunately, this makes the query much slower. I have now worked around this in another way, but I'd like to know if there is a way of doing this? Thanks, /Martin Koch

RE: Animation studio asset management

2012-12-24 Thread Martin Gainty
To add to Admiral Nelsons observations As your database grows your options are to either scale up (boost Memory and Disks) or scale out (add more MySQL nodes) If you want to add MySQL additional nodes (without incurring resultant) downtime you may wish to consider MySQL Clustering

RE: call up the sales

2012-12-16 Thread Martin Gainty
is missing on all your tables Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer

RE: [Info] Business db

2012-10-05 Thread Martin Gainty
indian spammer please take me off your list *Warm Regards* __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte

RE: (real) silly question about variables...

2012-10-04 Thread Martin Gainty
in a mySQL statement the values are displayed BEFORE assignments are made Ciao, No MAS __ Per

RE: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;

2012-09-23 Thread Martin Gainty
clause not found); Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte

RE: Mysql cluster installation error

2012-09-23 Thread Martin Gainty
CONTACT the server admin and request access to the MySQL Instance located there Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine

RE: Machine Learning

2012-08-24 Thread Martin Gainty
the relationships defined and written down then create the database ..once the DB is up and running in an accesible location with sftp or scp running so we can import.. publish the JDBC connection string Martin __ ..place long winded disclaimer here

RE: Machine Learning

2012-08-23 Thread Martin Gainty
prototype.. Let me know how i can help out, Martin Gainty __ ..place long-winded disclaimer here.. From: ag4ve...@gmail.com Date: Thu, 23 Aug 2012 10:42:55 -0400 Subject: Re: Machine Learning To: garotconk...@yahoo.com CC: webmas...@lisol.co.uk

RE: view query is slow

2012-08-23 Thread Martin Gainty
If memory serves predicates convert strings to column-data-type (in your case DATE) this *should* help WHERE dateexam = STR_TO_DATE('2012-08-13','%Y-%m-%d') does this help? Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de

RE: help with correlated subquery

2012-08-22 Thread Martin Gainty
operations will produce If the executed JOIN Statement does not produce expected results STOP and correct the JOIN clause BEFORE incorporating more functionality Obfuscation and confusion can hopelessly sidetrack any intelligent analysis Martin

RE: Machine Learning

2012-08-21 Thread Martin Gainty
Forgive my flawed human intervention into the flawlessly scheduled and impeccably managed operational tasks performed by the 'perfect machine' I guess its time for another 'stress pill' Martin Date: Tue, 21 Aug 2012 04:40:49 -0500 From: mich...@j3ksolutions.com To: mysql@lists.mysql.com

RE: Machine Learning

2012-08-21 Thread Martin Gainty
/articles/DesignPatternObserver/article.html As far as HW Requirements..the only requirement I see is for a MultiProcessor with some *kind of* LoadBalancer to arbitrate Load between the 1..n Nodes WDYT? Martin __ Verzicht und Vertraulichkeitanmerkung

RE: Machine Learning

2012-08-21 Thread Martin Gainty
://www.vogella.com/articles/DesignPatternObserver/article.html As far as HW Requirements..the only requirement I see is for a MultiProcessor with some *kind of* LoadBalancer to arbitrate Load between the 1..n Nodes WDYT? Martin __ Verzicht und Vertraulichkeitanmerkung

RE: Machine Learning

2012-08-21 Thread Martin Gainty
/articles/DesignPatternObserver/article.html As far as HW Requirements..the only requirement I see is for a MultiProcessor with some *kind of* LoadBalancer to arbitrate Load between the 1..n Nodes WDYT? Martin __ Verzicht und Vertraulichkeitanmerkung

RE: Machine Learning

2012-08-20 Thread Martin Gainty
in the multipathing within our own brains however until I have something up and running under some substantial load however I may not get a complete picture. Thanks, Garot Interesting Martin

RE: Machine Learning

2012-08-20 Thread Martin Gainty
When I hear 'AI' I always imagine theres a HAL 9001 behind the scenes that is running the show constantly admonishing its creator to take another stress pill Sounds like a fun project Keep us apprised, Martin Gainty __ Verzicht und

RE: Machine Learning

2012-08-19 Thread Martin Gainty
Garot Can ypou provide any specific goal(s) on what you would like to achieve? Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein

RE: UDF writing to unix socket - segfaults?

2012-08-08 Thread Martin Gainty
. Mit Fruendlichen Grüßen Martin (12.2°C) __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede

RE: UDF writing to unix socket - segfaults?

2012-08-08 Thread Martin Gainty
send and receive entities IPv4 or both entities are IPv6 if thats the case.. can you send 0 Bytes 2 bytes 4 bytes 8 bytes at what maximum length of buffer does the segfault occur ? Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de

RE: trouble with perl

2012-08-08 Thread Martin Gainty
no way to fix it except 1)grab the source 2)build it ..usually thru .\configure then .\make install 3)make sure the new binary gets installed to the first directory on your PATH Viel Gluck, Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de

RE: About character_set_*

2012-08-07 Thread Martin Gainty
Unless your effort is to convert all text strings to Mainland Chinese only ...Dont forget 'Locale' http://dev.mysql.com/doc/refman/5.5/en/locale-support.html Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

RE: New guy

2012-06-23 Thread Martin Gainty
Bonjour Raymond Nous espérons que cela vaut votre temps Bon chance! Martin __ Note de déni et de confidentialitéCe message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour

RE: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express

2012-06-19 Thread Martin Gainty
*.dll Saludos Cordiales (desde EEUU) Martin __ Porfavor no altere esta communicacion..Gracias Date: Tue, 19 Jun 2012 10:24:48 -0400 Subject: Re: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express From: chamael...@gmail.com

RE: Simple Email System (SES) Provider

2012-06-01 Thread Martin Gainty
Hi Don Your best solution is to setup your own Mail server (Preferably on SSL) http://en.wikipedia.org/wiki/Comparison_of_mail_servers Configure Open Relay to 'Off' Martin __ Jogi és Bizalmassági kinyilatkoztatás/Verzicht und

RE: Percona: Contact Details - a word on poaching

2012-04-03 Thread Martin Gainty
in the door On the other hand if you've been a full blown nazi with illegal wiretaps, strip searches and harassment you might wind up in the Hague for different circumstances. I am reminded of the platitude: United we stand..Divided we fall Bedankt, Martin Gainty

Re: Uninstall MySql Service

2011-11-19 Thread Martin Mueller
There is good advice by Rob Allen at http://akrabat.com/computing/uninstalling-mysql-on-mac-os-x-leopard/ for the Mac To uninstall MySQL and completely remove it (including all databases) from your Mac do the following: * Use mysqldump to backup your databases to text files! * Stop the database

how do I make utf8 the default encoding for my MySQL installation

2011-11-17 Thread Martin Mueller
Is it possible to make utf8 the default for all databases and transactions in a MySQL installation? The current default is Latin1. There is a suggestion on the Web to edit the my.cnf file as follows [mysqld] init_connect=’SET collation_connection = utf8_general_ci’ init_connect=’SET NAMES utf8′

MySQL install on OS X Lion does not create root account

2011-11-15 Thread Martin Mueller
I have been struggling with installing MySQL 5.5.17 on a Mac running OS 10.7. My machine had 5.5.15 on it. I keep getting user denied access messages (Error 1045). I thought at first it was a matter of a password not being flushed from a previous installation and went through repeated install

problem with installing MySQL 5.5 on OS Lion

2011-11-12 Thread Martin Mueller
for user 'martin'@'localhost' (using password: NO) ditto for commands like mysql ­p ­u root mysql ­u root and the like. I should add that I followed Rob Allen's instructions for completely uninstalling previous versions, and theoretically speaking there should be no traces of earlier passwords on my

RE: Hungarian Notation [Was Re: Too many aliases]

2011-08-06 Thread Martin Gainty
Jan- the upside is you dont have to look up a variable to know what type it is: zVariable is Null termed string bVariable is boolean nVariable is an Integer fVariable is a float dVariable is a double.. cVariable is a char Martin __ easy peasy

RE: Free Navicat

2011-07-26 Thread Martin Gainty
you will need the x86-64bit distro which contains the x86-64 bit distribution of libatkmm-1.6.so.1RPMs are error prone because they are version unaware..navicat should refactor their install to a version aware utility such as maven IMHO Martin

RE: dumb question?

2011-07-06 Thread Martin Gainty
VALUES('VALUES ARE ALWAYS SURROUNDED BY TICK MARKS UNLESS ANSI_QUOTES ARE ENABLED'); Bedankt, Martin Subject: Re: dumb question? From: rik.was...@grib.nl To: mysql@lists.mysql.com Date: Wed, 6 Jul 2011 16:39:16 +0200 On Wed, 2011-07-06 at 16:27 +0200, Rik Wasmus wrote: On Wed, 2011-07

RE: Query on wait_timeout

2011-06-16 Thread Martin Gainty
there is a deadlock a the first TRAN has an update lock on that same table...the second statement will not execute UNTIL the first statement TRAN is either commit or rollback releasing the initial lock on that table Viel Gluck, Martin __ Jogi és

RE: Input needed...

2011-05-06 Thread Martin Gainty
Harald- could you re-iterate the details of the malady or error you are experiencing? danke, Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir

RE: Input needed...

2011-05-06 Thread Martin Gainty
, Martin

RE: DBCP error

2011-05-06 Thread Martin Gainty
connection leaks will occur because of code maladies did you check your code to ensure: you are closing Statement Handles when you have finished executing the statement? you are closing Connection Handles when you have finished DML and DDL operations with the Database? ? Martin

RE: Запрос

2011-04-28 Thread Martin Gainty
(ich spreche nicht Russen) Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung

RE: mysql deal with specail character problem

2011-04-21 Thread Martin Gainty
goes the recovery ? Martin __ Note de déni et de confidentialité Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle

RE: Practical connection limits MySQL 5.1/5.5

2011-04-13 Thread Martin Gainty
i agree with harald if you're using Java you should consider pooling your database connections with DBCP http://commons.apache.org/dbcp/ feel free to ping me for implementation details takk, Martin __ Note de déni et de confidentialité Ce

RE: from excel to the mySQL

2010-08-03 Thread Martin Gainty
instead of haidarpesebe lecture concluded Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung

RE: query results group/summed by interval

2010-07-31 Thread Martin Gainty
if your interval is 5 change: sum(calls) from calls group by 5 * floor(seconds/5) to sum(calls) from calls group by floor(seconds/5) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist

RE: query results group/summed by interval

2010-07-31 Thread Martin Gainty
if your interval is 5 change: sum(calls) from calls group by 5 * floor(seconds/5) to sum(calls) from calls group by floor(seconds/5) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist

RE: Why is MySQL always linked to PHP?

2010-07-26 Thread Martin Gainty
MySQL is written in C if your requirement is to write extension packages for MySQL then use the OS specific C compiler to write the functions deferring to MySQL staff to handle your other questions Martin Gainty __ Verzicht und

RE: How to become a DBA on MySQL

2010-07-18 Thread Martin Gainty
ask program coordinator gary his address is sav...@champlain.edu My understanding is that oracle may offer some DBA courses in the future Keep us apprised Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

RE: Select w/ group by question

2010-07-14 Thread Martin Gainty
Date: Wed, 14 Jul 2010 10:25:22 -0400 Subject: Select w/ group by question From: smulle...@gmail.com To: mysql@lists.mysql.com I'm having trouble formulating a query to gather the following data. I can do this via a script, but now it is more or less just bothering me if there is

RE: query help

2010-06-16 Thread Martin Gainty
a test script which will create and populate the temp table thru cron http://www.databasejournal.com/features/mysql/article.php/3833146/Running-MySQL-in-Batch-Mode.htm would be interested to know which solution works best Vielen Danke, Martin

RE: Best way to purge old records from a huge table?

2010-06-04 Thread Martin Gainty
| +++-+ 2 rows in set (0.00 sec) hth Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine

RE: Strange errors / messages on slave server

2010-06-02 Thread Martin Gainty
In less technical terms, if the master goes faster than the slave, the slave will puke. MGthen the master will have to teach the slave MGis the master the entrenched bureacucrat or is that the slave? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave.

RE: Security issues

2010-05-25 Thread Martin Gainty
Good Morning Rob- I agree with you that security is a very serious topic and should be addressed as such Please read security alert page listed at tech-resources http://dev.mysql.com/tech-resources/articles/security_alert.html I hope this addresses your question, Martin Gainty

RE: Master - master replication

2010-05-24 Thread Martin Gainty
Hello Carl MySQL advertises an encryption package using the ENCRYPT('hello') but to date i have'nt find any information on where to download and configure the encrpytion package did you look at http://www.critotech.com ? Martin Gainty __ Verzicht

RE: Master - master replication

2010-05-24 Thread Martin Gainty
handshakes) the PGP decrypter at the other end will decrypt the received rows and construct import/update statements to MYSQL ? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich

RE: Master - master replication

2010-05-24 Thread Martin Gainty
mgzoom down to walters question(s) Hi Carl, On Mon, May 24, 2010 at 13:42, Carl c...@etrak-plus.com wrote: 1. Is the data visible during transmission? Not sure what you mean there? mghe means if someone was sharking the line would they be able to see Financial Information /

RE: Security issues

2010-05-24 Thread Martin Gainty
an alternate encryption algorithm with an alternate keysize RSA issues smart cards which contain sufficient biometric information to authenticate you (and pass the authentication token to the OS) does this help? Martin Gainty __ Verzicht und

RE: Security issues

2010-05-22 Thread Martin Gainty
-schedule-for-glassfish-556/ Does this help? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um

RE: Database Quotas

2010-05-21 Thread Martin Gainty
Tim- if MYSQL attempts to insert more bytes than what is available on disk you will get 28 ENOSPC No space left on device http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html does this help? Martin Gainty __ Verzicht und

RE: Database Quotas

2010-05-21 Thread Martin Gainty
Architectures does this conform to your understanding? Martin Gainty __ Please do not alter/modify or disrupt this transmission. Thank You Date: Fri, 21 May 2010 07:21:22 -0700 From: t...@soe.ucsc.edu To: mgai...@hotmail.com CC: mysql@lists.mysql.com

RE: Getting Array to display on SELECT

2010-04-20 Thread Martin Gainty
RGB encoding? sorry..thats for graphic designers Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich

DATE_FORMAT parameter question

2010-04-09 Thread Martin Gainty
I am doing wrong with format string to produce desired DD-MON-YY format? Many Thanks, Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene

RE: DATE_FORMAT parameter question

2010-04-09 Thread Martin Gainty
(Agradecimentos para o conselho) Eu espero que o homem responsável parará a chuva e permitirá a todos nós a oportunidade de dessecar e apreciar a luz do sol Obrigado! Martin Gainty __ Por favor não altere/interrompa ou altere esta transmissão

RE: DATE_FORMAT parameter question

2010-04-09 Thread Martin Gainty
Hi Carsten thanks for providing mysql support at 846pm kobenhavn time (on a fridag no less) I will DEFINITELY check this out Takk! Martin Gainty __ Note de déni et de confidentialité Ce message est confidentiel et peut être privilégié. Si

RE: Tokutek Acquires Oracle

2010-04-01 Thread Martin Gainty
short of exxon there is no other entity that comes close to acquiring Oracle Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger

RE: how things get messed up

2010-02-16 Thread Martin Gainty
i agree with jerry put date/timestamps on each record..(that way you know when the record was created/modified) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten

RE: Happy Christmas

2009-12-25 Thread Martin Gainty
Guten Tag/Bonjour/Hello Pete Haben Sie ein gutes Weihnachten/Ayez bon Noël/Have a good Christmas Staaten von Amerika/Etats Unis/United States of America Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

missing ttydefaults.h

2009-11-04 Thread Martin Gainty
In file included from readline.c:54: readline/readline.h:70:29: sys/ttydefaults.h: No such file or directory any clue where i can locate? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist

  1   2   3   4   5   6   7   8   >