Re: [NEWS]

2010-12-20 Thread Benedikt
SPAM .. Am 20.12.2010 um 17:58 schrieb "Sergey Lazurenko" : > Hello! Our team created new comprehensive solution for data analysts. Could > you place basic information about this product on your page. > > Best Regards, > Sergey Lazurenko > > > -- > MySQL General Mailing List > For list

Re: Mysql error causing database to not accept threads

2010-06-29 Thread Benedikt Schackenberg
Note that some of the memory settings are per connection, if you have 63 connections, you may have up to 63 copies of the buffers, and you have pretty huge buffers even with 30GB of memory. Join buffers close to 1 G, tmp_table_size of 2 G, 63 connections could mean upto 63 copies of these, and

Re: 2 servers 1 common data base

2010-06-09 Thread Benedikt Schackenberg
ns einen anderen Kommunikationsweg zu benennen. Für viele der Dateien, die Sie von uns erhalten, benötigen Sie zum Betrachten den Acrobat Reader, den Sie hier erhalten können. http://www.adobe.de/products/acrobat/readstep2.html GF: Benedikt Schackenberg und Christian Peiter AG & Sitz: Ma

Re: Render row without duplicates

2010-01-02 Thread Benedikt Schackenberg
Am 02.01.2010 13:43, schrieb bharani kumar: No Duplicate records, select hospital1code from *yourtable* grop by hospital1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysql server is not starting

2009-11-11 Thread Benedikt Schackenberg
amssys 512 Nov 11 12:28 tools > > > Best Regards > Faizal S > GSM : 9840118673 > Blog: http://oradbapro.blogspot.com > > > 2009/11/11 Benedikt Schackenberg > >> hi, >> exists this folder on your System? >> >> >> /var/LRM-I

Re: mysql server is not starting

2009-11-11 Thread Benedikt Schackenberg
s is not in /usr/local/mysql.. > > if u see my error log. it ask me to run mysql_upgrade. why it is asking > .. any idea > > > > > Best Regards > Faizal S > GSM : 9840118673 > Blog: http://oradbapro.blogspot.com > > > 2009/11/11 Benedikt Schackenberg

Re: mysql server is not starting

2009-11-11 Thread Benedikt Schackenberg
> GSM : 9840118673 > Blog: http://oradbapro.blogspot.com > > > 2009/11/11 Benedikt Schackenberg <mailto:schackenb...@termindoc.de>> > > Check that your my.ini or my.cnf has the correct entry for the Basedir > option. > > > F.A.I.Z.A.L

Re: mysql server is not starting

2009-11-11 Thread Benedikt Schackenberg
le der Dateien, die Sie von uns erhalten, benötigen Sie zum Betrachten den Acrobat Reader, den Sie hier erhalten können. http://www.adobe.de/products/acrobat/readstep2.html GF: Benedikt Schackenberg und Christian Peiter AG & Sitz: Mainz am RheinHandelsregister: HR-B 8608

AW: why different users get different count(*) from same table?

2009-07-01 Thread Benedikt Schackenberg
Check your rights ;) -Ursprüngliche Nachricht- Von: jinava [mailto:jin...@gmail.com] Gesendet: Mittwoch, 1. Juli 2009 14:52 An: mysql@lists.mysql.com Betreff: Re: why different users get different count(*) from same table? Hi experts, Something strange here, use root and mysql (root and

AW: AW: creating databases in different folders

2009-06-02 Thread Benedikt Schackenberg
Thx john !! i can use this :) -Ursprüngliche Nachricht- Von: John Daisley [mailto:john.dais...@mypostoffice.co.uk] Gesendet: Dienstag, 2. Juni 2009 17:10 An: Jerry Schwartz Cc: john.dais...@butterflysystems.co.uk; 'Foo JH'; schackenb...@termindoc.de; mysql@lists.mysql.com Betreff: RE: AW

AW: AW: creating databases in different folders

2009-06-02 Thread Benedikt Schackenberg
: Re: AW: creating databases in different folders Benedikt Schackenberg wrote: > You can configure it in the my.cnf file: there you can set the data > directory. Thanks for the quick reply. My concern is that setting the data directory puts ALL databases in that folder. What I plan to do is

AW: creating databases in different folders

2009-06-02 Thread Benedikt Schackenberg
You can configure it in the my.cnf file: there you can set the data directory. -Ursprüngliche Nachricht- Von: Foo JH [mailto:jhfoo...@extracktor.com] Gesendet: Dienstag, 2. Juni 2009 05:00 An: mysql@lists.mysql.com Betreff: creating databases in different folders Hi all, I'm using My

AW: Recover data without logs

2009-05-31 Thread Benedikt Schackenberg
O think not, did you make dumps of your database? If not you have to use bin-log -Ursprüngliche Nachricht- Von: Weitao Liu [mailto:liuwt...@gmail.com] Gesendet: Sonntag, 31. Mai 2009 10:13 An: mysql@lists.mysql.com Betreff: Recover data without logs I had deleted some important data from

FROMAT function - German Notation

2005-09-28 Thread Benedikt Hartmann
How can I display the result of the FROMAT function in german notation like '#.###,##'? I found no better way then this: REPLACE(REPLACE(REPLACE( FORMAT(money,2),'.','x'),',','.'),'x',',') as ge_money does anybody know a sol