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" 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’ method works while the mysql.serv

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 t

Re: a curse on OS sierra and MySQL?

2016-12-02 Thread Martin Mueller
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://urldefense.proofpoint.com/

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 progresse

Re: MySQL Platform Migration

2016-09-11 Thread Martin Mueller
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" wrote: >Because they want to be belittled by european jackasses online. > >On Sep 10, 2016, at 11:5

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

2016-07-04 Thread Martin Mueller
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
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" wrote: 2016/07/02 18:49 ... Martin Mueller: > It’s clear from Section 6.6 of the Reference manual that I need to make

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" wrote: On 4/20/2016 2:04 PM, Mart

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 file

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 order

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 Mu

moving inno tables

2015-08-20 Thread Martin Mueller
s that all of the INNO tables 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 Northwester

pid-file quite

2015-07-31 Thread Martin Mueller
t OS X is a very popular operating system 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, "sh

Re: password problem

2015-07-31 Thread Martin Mueller
e, and it would 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" wrote: > > >Am 31.07.2015 um 15:40 schrieb shawn l.green: &

Re: password problem

2015-07-31 Thread Martin Mueller
directory 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 mailto:martinmuel...@northwestern.edu>> wrote: I have installed mysql 5.1.73 o

Re: password problem

2015-07-31 Thread Martin Mueller
I needed to another machine. I'm 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/

password problem

2015-07-30 Thread Martin Mueller
27;ve 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
the time. I'll be monitoring this thread with interest :-) > > >- Original Message - >> From: "Johan De Meersman" >> To: "Pothanaboyina Trimurthy" >> Cc: "Martin Mueller" , "MySql" >> >> Sent: Monday, 4 May, 201

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 mailto:skd.trimur...@gmail.com>> Date: Friday, May 1, 2015 at 12:15 AM To: Martin Mueller mailto:martinmuel...@northwestern.ed

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 wa

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/

RE: How to retrieve next record?

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

update and control flow

2014-12-09 Thread Martin Mueller
COMMENT = 'a' elseif WORD like 'b%' SET 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" wrote: >Not a uni

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 know

table comments

2014-09-07 Thread Martin Mueller
te 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-07 Thread Martin Gainty
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

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 functi

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)" > >> > >> Database Workbench

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: mysql@lists.m

RE: Proxy / connected failover question

2014-07-09 Thread Martin Gainty
> >> > >> Thank you for any and all suggestions and information, > >> Johan > >> > >> What's tiny and yellow and very, very dangerous? > >> A canary with the root password. > > > > Best regards, > > > > Walter Heck > > CEO / Founder OlinData <http://olindata.com/?src=wh_gapp> - Open Source > > Training & Consulting > > MG>BR, MG>Martin

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

RE: mysqlcheck downtime > 30 minutes for Java web application

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

Long integer constant problem in views

2013-04-30 Thread Martin Koch
s WHERE id = X'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 http://books.g

RE: call up the sales

2012-12-16 Thread Martin Gainty
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 Weiterl

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 f

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: How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;

2012-09-23 Thread Martin Gainty
Possibly run your constructed query thru a regex expression e.g. String mydata = "SELECT * from table WHERE a Date: Sun, 23 Sep 2012 18:38:58 -0400 > Subject: Re: How to block SELECT * FROM table; but not SELECT * FROMT table > WHERE...; > From: fuller.art...@gmail.com > To: pownall...@gmail.com

RE: Machine Learning

2012-08-24 Thread Martin Gainty
s..get 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 discl

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 Vertraulichkeitanmerkun

RE: Machine Learning

2012-08-23 Thread Martin Gainty
t a quick 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...@

RE: help with correlated subquery

2012-08-22 Thread Martin Gainty
T JOIN or RIGHT JOIN 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 intelli

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-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...@j3

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

RE: Machine Learning

2012-08-20 Thread Martin Gainty
ical conception 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

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: trouble with perl

2012-08-08 Thread Martin Gainty
ve 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

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: 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: 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 confi

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

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.

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/Ve

RE: Percona: Contact Details - a word on poaching

2012-04-03 Thread Martin Gainty
t you 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, Mar

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 s

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 an

problem with installing MySQL 5.5 on OS Lion

2011-11-12 Thread Martin Mueller
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 o

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
e_name FOO 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 +02

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: 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: Input needed...

2011-05-06 Thread Martin Gainty
e enabled in my.cnf? MG>http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_file_per_table > danke, Martin

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: Запрос

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
tf16 or any character-set which supports DBCS then i *could* implement CJK languages in the DB how 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 dest

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

RE: from excel to the mySQL

2010-08-03 Thread Martin Gainty
haidarpesebe 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 Kopie 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: 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

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 | 2 | 2006-09-05 | | 3 | 3 | 2006-09-06 | +++-+ 2 rows in set (0.00 sec) hth Martin Gainty __

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. MG>then the master will have to teach the slave MG>is the master the entrenched bureacucrat or is that the slave? > > Regards, > > Jerry Schwartz > Global Information Incorporated > 195 Farmington

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: Security issues

2010-05-24 Thread Martin Gainty
tervals RSA implements 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 ___

RE: Master - master replication

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

RE: Master - master replication

2010-05-24 Thread Martin Gainty
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. Sollten Sie nicht der

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 _

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
ented Disk 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:

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: 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

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é

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

DATE_FORMAT parameter question

2010-04-09 Thread Martin Gainty
++ | 11-Oct-09 | +----+ 1 row in set (0.00 sec) any ideas on what I am doing wrong with format string to produce desired DD-MON-YY format? Many Thanks, Martin Gainty __

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é

RE: missing ttydefaults.h

2009-11-04 Thread Martin Gainty
no i havent ..any clues as to location of kernel headers? (apologies for the newbie question) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der

  1   2   3   4   5   6   7   8   9   >