innodb_lock_wait_timeout and replication

failed? If it is in the binlog it will be replicated to a slave and on the slave it will succeed (maybe). Does this mean that a Lock wait timeout exceeded potentially drive the slave out of sync? -- Kind Regards, Markus Falb signature.asc Description: OpenPGP digital signature

Re: innodb_lock_wait_timeout

On 11.10.2012 14:43, Johan De Meersman wrote: > > - Original Message - >> From: "Markus Falb" >> >> But why is retrying better than raising the value? >> >> So what is better, adjusting the timeout or retrying application side >> an

innodb_lock_wait_timeout

timeouts are normal on busy servers and it is necessary for applications to be aware that they may happen and handle them by retrying. snap... But why is retrying better than raising the value? So what is better, adjusting the timeout or retrying application side and why? -- Kind Regards, Markus

Re: Transplanting table structure changes

Hi Jerry, there's a (commercial) product called SQLyog, with an excellent schema synchronization tool (at least in the enterprise version) which procudes ready-made "alter table" scripts. Probably other db tools have this functionality too ... HTH, regards, Markus - O

Re: confirm unsubscribe to mysql@lists.mysql.com

by uid 48); 25 Jul 2008 19:19:52 - > Date: 25 Jul 2008 19:19:52 - > Message-ID: <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Unsubscribe request > From: <[EMAIL PROTECTED]> > > This message was generated because of a request from 84.56.89

Re: confirm unsubscribe to mysql@lists.mysql.com

by uid 48); 25 Jul 2008 19:19:55 - > Date: 25 Jul 2008 19:19:55 - > Message-ID: <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Unsubscribe request > From: <[EMAIL PROTECTED]> > > This message was generated because of a request from 84.56.89

Authors wanted for German Linux Magazin

w. Please let me know, I'd be very happy if you could contribute... (Don't worry about language!) -- Best Regards - Mit freundlichen Gruessen Markus Feilner - Feilner IT Linux & GIS Linux Solutions, Training, Seminare und Workshops - auch I

Re: Spontaneous corrupted tables on MyISAM with 5.0.x release

the product operates solely on NFS, they're no real physical drives involved ... thanks, - Markus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Spontaneous corrupted tables on MyISAM with 5.0.x release

ely at fault. If it had that problems I just couldn't believe this was in a stable product. I'm really curious to just to fix the problems but also find out what the cause really is. I would be glad for any help on this matter and I'm happy to provide any information y

Re: Performance problem with ~0.5 GB tabel

GB ram. I'm not sure about it's CPU performance, but the information I've is that when connections start hanging and the effect basically multiplies, the CPU load goes aup. Does this sound like a possible bottleneck? thanks, - - Markus Markus Fischer wrote: > Hi, > > I&

Performance problem with ~0.5 GB tabel

y is to get the top-most posters in the selected forums. The MySQL documentation [2] says that under certain cases it should be possible to create appropriate keys so that even an ORDER BY can take advantage of, but I was unable to come up with such an. Is there a recommendation how to go

Problems with migration from 4.0.24 to 5.0.32 with unique varchar

into the MySQL5 database I get a duplicate key error; I tried the collcations utf8_bin and latin1_bin already (started out with latin1_german1 and latin1_german2). How can I solve this? thanks, - - Markus -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with

Re: Logging from mysql only from certain applications

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Markus Fischer wrote: > Before I re-invent the wheel I'ld like to know if there are tools/helper > like this available ... ? Being impatient and in need of this I've written my own version. Maybe it is valuable to others. http://mar

Logging from mysql only from certain applications

ta without a tool. Before I re-invent the wheel I'ld like to know if there are tools/helper like this available ... ? thanks, - - Markus -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFD6Py1nS0RcInK

Re: does DISTINCT kill ORDER BY?

Just for the archives: looks like I bumped into bug #21456: http://bugs.mysql.com/bug.php?id=21456 This bug has been fixed in 4.1.22 and 5.0.25, so I'll just have to upgrade. Thanks anyway Markus Markus Hoenicka <[EMAIL PROTECTED]> was heard to say: > Chris <[EMAIL PROTECT

Re: does DISTINCT kill ORDER BY?

modified clause further restricts the results selected by refdb_id with the same effect regarding the sorting. BTW the above results were obtained with mysql.exe Ver 14.7 Distrib 4.1.10, for Win95/Win98 (i32) so the problem is neither specific to the FreeBSD port nor to a particular 4.1.x versio

does DISTINCT kill ORDER BY?

dex to sort the result, DISTINCT queries won't be sorted at all. These results were obtained with: mysql Ver 14.7 Distrib 4.1.21, for portbld-freebsd6.1 (i386) using 5.0 FreeBSD yeti.mininet 6.1-RELEASE FreeBSD 6.1-RELEASE #1: Mon Aug 28 22:24:48 CEST 2006 [EMAIL PROTECTED]:/usr/src/s

innodb-safe-binlog

but how can I use safe binlogs with new mysql's and without changing my SQL-Code? thanks in advance Markus Wenke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Matching of german umlauts with LIKE

y gotcha is that the user may enter any special regexp characters also, so I had to make a list of them and escape them prior to modifying the string. thanks, - - Markus sheeri kritzer wrote: > MySQL doesn't have anything like that. You can use the wildcard > characters instead

Matching of german umlauts with LIKE

ld be "ueberseemoebel" and when the term "überseemö" is entered it's also normalized to "ueberseemoe" and the LIKE statement will still match. Basically this is some kind of primitive stemming like lucene does it. Is there maybe some built-in support from M

Re: Index and multiple fields

select * from ... where id3 = .. and id4 = .. I would create two indexes, one for id1/id2 and the other for id3/id4 , right? again, thanks - - Markus Косов Евгений wrote: > Hi, Mark! > > Of course, it depends on queries you are running. > > I beleive you can find all anwers he

Index and multiple fields

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, is there, performance wise, any difference whether I create one index for multiple fields or each field with its own index? I'm running 4.0.16. thx, - - Markus -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2.1 (MingW32) Comment: Using

mysqld in an eternal loop

Hi listers 1. environment [EMAIL PROTECTED] ~> uname -a Linux myhost.mydom.tld 2.6.12-1.1390_FC4_cubbi4_swsusp2 #1 Sat Jul 9 12:34:47 CEST 2005 i686 i686 i386 GNU/Linux [EMAIL PROTECTED] ~> 2. mysql [EMAIL PROTECTED] ~> rpm -qa |grep -i mysql MySQL-server-4.1.14-0 MySQL-shared-4.1.14-0 MySQL-

MySQL Binlog/Replication and SET @variables

la, @blub); Same should happen when the binlog is replayed while restoring a backup. I'm using mysql release 4.0.24. regards, Markus -- Siemens AG ITO A&S 4 Internetteam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

instable behaviour of mysql

Hi mysql-listers mysql> select version(); ++ | version() | ++ | 4.1.7-standard-log | ++ 1 row in set (0.10 sec) mysql> [EMAIL PROTECTED]:~> uname -a Linux rosetta 2.6.4-54.5-default #1 Fri May 7 21:43:10 UTC 2004 i686 i686 i386 G

Re: Problem with date field

> What's going on here? God knows ! Maybe providing some information (OS, version, host app(if any), code example, db description, etc.) would permit some humble humans to take a guess ... - Original Message - From: "Steve Grosz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, N

Re: Unable top drop table, error 1051

Egor Egorov wrote: Bug filled: http://bugs.mysql.com/bug.php?id=5784 Thank you! Nice, thanks to you too ;-) regards, - Markus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unable top drop table, error 1051

aint, but then the error message is missldeading. So basically I would need to disable the foreign_key_checks every time I drop a table which has constraints? I see the bigger picture now I guess, just didn't while trying to achive this with phpmyadmin. thanks, - Markus -- MySQL Gene

Re: Unable top drop table, error 1051

les is important, because if tries to create contraints to table which do not exist (yet) because they a further down in the dump file. Manually reordering doesn't seem very sexy to me. I read the mysqldump manpage but it doesn't tell me an option how to have mysqldump respect the

Unable top drop table, error 1051

able is to completely drop the database and recreate. thanks for any hints - Markus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

select data in one order, print in another order

Hi list environment: host:/ # uname -a Linux host 2.4.19-4GB #1 Fri Sep 13 13:14:56 UTC 2002 i686 unknown host:/ # host:/ # /usr/local/mysql/bin/mysqld -v /usr/local/mysql/bin/mysqld Ver 4.0.12-max for pc-linux on i686 host:/ # an php application of ours prepares customer data on the screen in a

Re: How to show comments/annotations in MySQL client output

Michael, which version are you using ? I didn't find SYSTEM in the manual ... Thanks, Markus - Original Message - From: "Michael Stassen" <[EMAIL PROTECTED]> To: "Richard Mixon (qwest)" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday

Re: select and where clause - help

Hi, > | BT-1034.02 > mysql> SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.2'; I think you have a type .. instead of SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.2' try SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.02' HTH, Mar

Re: JOIN or UNION or both?

p It worked for me (MySQL 4.0.x) HTH, Markus - Original Message - From: "Matthias Kritz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 24, 2004 7:33 PM Subject: RE: JOIN or UNION or both? > Shawn, > > Thank you for your reply.

UPDATE...WHERE ... IN (SELECT...)

Hi all, Can someone tell me what is wrong with this statement? UPDATE nummer SET gold = '1' WHERE anr IN (SELECT no FROM gull); I use MySQL 3.23.49. Thanks Markus Källander

Dual-installation: MySQl 3 + 4 ?

Hello! Is there a possibility to install MySQL 3.X and MySQL 4.X parellel on one FreeBSD-Machine? I would like to work with the new version, but a lot of utilities published as free php-software don't run with MySQL withoutn massive changings. With best regards Mark Schanovsky -- MySQL General

error at server startup

Hi! After some tries i finally managed to compile mysql 4.0.17 with ssl-support (openssl 0.9.7c, compiled with minGW 3.1.0.1) under windows2000. SHOW VARIABLES LIKE 'have_openssl' returns YES. when starting the server the following happens: $>mysqld.exe --port=3306 --ssl-ca=cacert.pem --ssl-cert=

AW: Error: 127

Hello Terence, Terence wrote: > Just do a check and repair: (or just repair to fix it) > > CHECK TABLE your_table > REPAIR TABLE your_table I´ve got the same error like Jacob, but this error appears over and over at my database files. Do you know WHY this error occurs ? Markus

non-ASCII characters in LIKE and regexp comparisons?

Hi mysql-list, 1. my installation: [EMAIL PROTECTED]:~> uname -a Linux rosetta 2.4.19-4GB #1 Fri Sep 13 13:14:56 UTC 2002 i686 unknown [EMAIL PROTECTED]:~> mysql> show global variables like "version"; +---++ | Variable_name | Value | +---+--

Re: Performance problems using 1GB Linux server and trying to avoid swapping

On Thu, Dec 18, 2003 at 10:37:46AM -0600, Dan Nelson wrote : > In the last episode (Dec 18), Markus Fischer said: > > On Tue, Dec 16, 2003 at 10:38:14AM -0600, Dan Nelson wrote : > > > Raising sort_buffer_size and join_buffer_size may also help if your > > > qu

Re: Performance problems using 1GB Linux server and trying to avoid swapping

On Tue, Dec 16, 2003 at 10:38:14AM -0600, Dan Nelson wrote : > In the last episode (Dec 16), Markus Fischer said: > > I'm investigating a performance problem with mysql server set up. The > > server is running linux with 1GB ram. I'ld like to tune the > > config

Re: Performance problems using 1GB Linux server and trying to avoid swapping

e the only ones related to memory. Can you advise me where to look at exactly? - Markus Ps: I'm using version 4.0.14 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Performance problems using 1GB Linux server and trying to avoid swapping

y, are the other ways to better tune the server for the 1GB ram? What performance analyses tool are recommended for use with MySQL? thanks for any advice, - Markus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

synchronizing over eth1

s from the lake contance markus -- --- Suchtreffer AG Bleicherstrasse 20 D-78467 Konstanz Germany fon: +49-(0)7531-89207-17 fax: +49-(0)7531-89207-13 e-mail: [EMAIL PROTECTED] internet: http://www.such

Re: PHP or Perl?

Ruby Application Archive. just my experiences. check out http://www.ruby-lang.org http://www.rubycentral.com http://www.python.org Markus On Sat, 2003-08-16 at 07:17, Mark Healey wrote: > As part of my own learning mysql project I'm planning to build > databases for all m

Re: MySQL 4.0.14 & mysql_create_db()... II

so if you do not have to use C maybe you should consider Ruby. there is also Ruby/DBI ruby-dbi.sf.net Markus -- - Miguel Cardenas <[EMAIL PROTECTED]> schrieb: > Hello again... > > I opened mysql.h and found this... > > --- > #ifdef USE_O

pre-compiled libmysqlclient.a for MinGW?

for mysql-3.23.43. However, the site doesn't seem to exist anymore. Does anyone have the port and could pass it over to me? Or does someone know if the site still exists, and where it has moved? I'll appreciate any help, Markus -- MySQL General Mailing List For list archives: ht

Build problem in mysql++-1.7.9

namespace isn't defined, neither in a `using namespace' phrase, nor like `std::out_of_range'. Is there a way to fix this error except for changing it in the source code? Thanks, Markus - Before posting, please

Changing the library path in libsqlplus.la

way to tell the binary at installation where to look for the libmysqlclient? Or do I have to put a link resp. change the path in libsqlplus.la by hand? Thanks, Markus - Before posting, please check: http://www.mysql.com

A table allways crashes

work. We still haven't tested. >Submitter-Id: >Originator:Markus Hager >Organization: BLUeBULL Capital Markets Consulting GmbH >MySQL support: [none ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: my

Re: Starting mysqld within SuSE 8.0

> However make sure to keep the same directory tree as SuSE. Thanks, that's good to know when I'm going to upgrade from the SuSE CD version of MySQL to a more recent version. Best, Markus - Before posting, ple

Re: Starting mysqld within SuSE 8.0

kers, at > which runlevels mysql should start. That did it. :-) Thank you very much! Greetings from Rheinland-Pfalz/Germany Markus -- Markus Gerwinski, IT-Berater An der Brunnenstube 15/3, 55120 Mainz Tel.: 06131-945852, mobil: 0177-3552099

Starting mysqld within SuSE 8.0

Hello, can someone tell me how to start mysqld at boot on a SuSE 8.0 system? Starting it manually with safe_mysqld runs fine. But I didn't find a way in YaST to start the daemon on boot, and manually adding it to the /etc/init.d/boot.d/ lead me into a crash. Thanks in advance, M

Re: Red Hat 8.0 compile problems with 4.0.10

hello afaik: turn off the optimizing options before compiling/making. ... or get a completely new glibc family and compile each and everything pertinent. ... or use rh 7.3 kr mr >>> Mark Matthews <[EMAIL PROTECTED]> 02/16/03 14:43 PM >>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark T.

Re: error 2013 on rh8.0

Heinz great hint - poor success actually installed is 2.2.93 if i force it in maybe mysql functions - other thing will fail in bulk. kr mr >>> Stefan Hinz <[EMAIL PROTECTED]> 02/12/03 15:41 PM >>> Markus, If you're lucky, you might be able to use this RPM: ftp

error 2013 on rh8.0

this is probably an issue already solved or at least treated on this list - so please forgive. nevertheless I encountered the error 2013 when i tried to connect from another machine to the machine holding the mysqlserver running with the standard mysql package resp. the updated mysql package

RE: How to speed things up in MySQL ?

27;ve seen that on a Windows SAP DB server once, and it turned out to be a DNS issue. Once fixed, everything ran perfectly well. Markus -Original Message- From: Thomas Kvamme [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 25, 2003 6:27 PM To: Bhavin Vyas; [EMAIL PROTECTED] Subject:

Re: Perl DBI secret command?

hi pls look into "man DBI" and find there this command. kr mr >>> Jeff Snoxell <[EMAIL PROTECTED]> 01/18/03 10:45 AM >>> Hi, just stumbled across the following piece of code: my $rowcount = $sth->rows(); And I checked it out compared to a count of the fetched rows from an SQL QUERY. AND It

MySQL v4.0.8 bug report

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] >Description: >

Re: insecure chrooting from mysqld

Hey, > Fixed, thanks. Good to know. Anyways I'll check it out in the next release! > I always wondered why people spend so much time discussing a bug and > developing various howto and workarounds, instead of submitting a > bugreport and having the bug fixed in one hour. :)) I submitted the bug

insecure chrooting from mysqld

Hey, The chroot command line option of mysqld is insecure. Databases which are located for instance not in the chroot path can be accessed! More information can be found at http://www.linuxquestions.org/questions/showthread.php?s=&threadid=34314 http://www.linuxquestions.org/questions/showthrea

Re: mysql memory leak on SUN Solaris 5.7 when importing dump files

riority_paging works and how it could help me. I'll have a closer look to that within the next days. Thx a lot for your hints, seems this really is not a mysql issue. regards, Markus On Don, 21 Nov 2002, Lars Heidieker wrote: [...] > so you can see that a lot of the memory is used

Re: mysql memory leak on SUN Solaris 5.7 when importing dump files

Lars, the amount used increases until all free memory is used plus a fair amount of swap. On a machine with 2GB memory this can well grow up to 1GB. Any chance to get the current size of the malloc pool to check if this causes the effect? thx so far, Markus On Don, 21 Nov 2002, Lars

mysql memory leak on SUN Solaris 5.7 when importing dump files

and see memory eaten up. >Fix: unknown >Submitter-Id: >Originator:Markus Warg >Organization: no organization >MySQL support: none >Synopsis: memory leak >Severity: non-critical >Priority: low >Category: mysql >Class: sw-

Why does altering the order alter my result?

a big influence on the result? And how can I get the desired order and still get the desired result for each row? Can anyone shine a light on this issue please? -- Best Regards, Markus Hanauska - Before posting, pl

mysql++ optimize 4 gcc3.2

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi .. I have a question about mysql++. give it a version of mysql++ that is optimize for the gcc 3.2 Version or have someone a tip to compile that with the gcc 3.2 ?? Thanks a lot - -- Markus Schnelle - Email: [EMAIL

RE: Goodday

Yeah, you missed this: http://home.rica.net/alphae/419coal/ It's a really old, particulary disgusting and quite successful scam. Markus -Original Message- From: Andrew Pickett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 10:03 AM To: [EMAIL PROTECTED] Cc: [

granting grant option creates a (new) user ?!

MySQL : it seems that a user who has grant privilege can grant access to a(his) database to :another user although this other user doen't exist - in this case the other user is :newly created! can cause a mess in your usertable when you have a site with some :databases to administer ---

Re: Threads or Prozesses on Linux, and how to control them?

. > From: "Joseph Bueno" <[EMAIL PROTECTED]> > To: "Markus Fischer" <[EMAIL PROTECTED]> > mysqld uses threads (you already found the right documentation). > > > How long is the life-time of a connection if there's no > > request

Threads or Prozesses on Linux, and how to control them?

How long is the life-time of a connection if there's no request comming anymore? The mysqld is acesssed with PHP and I'm using normal mysql_connect() so connections aren't persisten so they should go after some tim

mysqladmin segfaults on Solaris 8

int. Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library +358-6-325 3589 / +358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://li

Re: GRANTs and %

64: You have an error in your SQL syntax near ''clients'@'%' > IDENTIFIED > BY '123'' at line 1 GRANT ALL PRIVILEGES ON newstesting.* TO 'clients'@'%' IDENTIFIED BY '123'; You're missing the 'TO'. Cheers, Ma

Re: InnoDB foreign key constraints

On Monday 10 Jun 2002 11:44 am, Markus Lervik wrote: > mysql> show create table ip_name_tbl\G > *** 1. row *** >Table: ip_name_tbl > Create Table: CREATE TABLE `ip_name_tbl` ( [snip] > `name_id` int(11) NOT NULL

Re: InnoDB foreign key constraints

', PRIMARY KEY (`name_id`), KEY `id` (`id`) ) TYPE=InnoDB and, again: mysql> ALTER TABLE ip_name_tbl -> ADD CONSTRAINT FOREIGN KEY (name_id) -> REFERENCES conn (name_id) -> ON DELETE CASCA

InnoDB foreign key constraints

ced key are listed as the first columns" seems to have something to do with my problem, I just find the above a bit... well... cryptic. If anyone could lend me a hand, I'd be more than happy. Thank's in advance! Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City L

Re: mysql not supporting php.

and add --with-mysql to the configure script. > Also, does anyone know the command to list all the db's? thanks. SHOW DATABASES; Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library, Finland [EMAIL PROTECTE

Re: INSERT IF NOT EXISTS?

nd "Administration", "administration" isn't already in the table. Rob's idea is of course a solution, but that sort of brings me back to my original question : "is there a -SIMPLE- way"? ; ) INSERT IGNORE wouldn't, if I understood the manual correctly,

INSERT IF NOT EXISTS?

(filter fodder: sql, query) Hello group! Quick question: Is there a simple way to do something like INSERT IF NOT EXISTS, other than first doing a SELECT and checking if it returns any rows? If not, that would be pretty high up on my whish-list : ) Cheers, Markus -- Markus Lervik Linux

mysqladmin hanging on Solaris 8/Intel

cefully with minimum danger of losing data? Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library +358-6-325 3589 / +358-40-832 6709 - Before posting, please check: http://www.mysq

AW: newbie problem

Hi there's a 'data' directory in your mysql directory. This one contains one subdirectory for each of your databases. Just copy the one you need to your cd and place it in the data directory on the othe computer. markus > -Ursprüngliche Nachricht- > Von: Lali

SELECT/JOIN problems

g I can think about, but nada. I'd assume that if it's at all possible it'd be some join-trickery, but I just can't figure it out. (yes, I know it'd be easier db-wise to have a 'paid ENUM("y","n")' -field, but this is just a curiosity. I wa

AW: AW: MySQL on OS X

last question about MySQL on OS X Markus -Ursprungliche Nachricht- Von: Erik Price [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 25. April 2002 17:33 An: Markus Ungersboeck Cc: [EMAIL PROTECTED] Betreff: Re: AW: MySQL on OS X Greetings from Massachusetts (USA), On Thursday, Apr

AW: MySQL on OS X

7;m a complete newbe concerning the commandline installation of software I've tried it first with the binary without success. Maybe I should reinstall the Developer Tools. Erik - what version of SQL (and installation method) have yo

MySQL on OS X

can I get this library for my system? Tx Markus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EM

Selecting entries in table A that are NOT in table B.

table paid? The members-table: mysql> SELECT * FROM members; +---+--+---+--+ | id| membernr | firstname | lastname | +---+--+---+--+ | 1 |1 | markus| lervik | | 2 |2 | markuas | asdff| | 3 |

A bit OT: ColdFusion can't connect to MySQL via ODBC (newbie)

on when using a -tag. Any help is greatly appreciated. Cheers, Markus, tearing big lumps of hair out. -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 --

Re: mysqld cannot find host.frm even though it is in data/mysql

kept coming up with error 020303 5:20:41 > /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm > ' (errno: 13). Did you read the README file? [mle@hal9000 rip]$ perror 13 Error code 13: Permission denied chown -R mysql.mysql mysql/ ought to sort it out.

Re: mysql error

[mle@hal9000 data]$ perror 111 Error code 111: Connection refused That would indicate that you haven't got a mysql-server running. If it is running, check that /tmp/ actually is where the socket-file is, and check your my.cnf-file in case the [mysqld] section contains skip-networking. If i

myisampack, CHECK TABLE & REPAIR TABLE

erver version in use is: 3.23.47-log on Linux thanks, Markus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: for You

See? If you'd have that, you wouldn't even get this mail.) c) Unsubscribe from the list if it bothers you that much. We've (unfortunately) seen at least one individual unsubscribing, not too long ago, because of the spam. Cheers, Markus -- Markus Lervik Linux-administrato

Re: MySQL server not listening on port?

On Tuesday 22 January 2002 14:32, Markus Lervik wrote: > Hi! > > For some strange reason MySQL doesn't listen for incoming > connections on port 3306. I have four servers, two of which are > 4.0.1 and two are 3.23.47. I can connect between three of them freely, > b

MySQL server not listening on port?

*) mysql from a mirror. The configurationfiles are just about identical on the two machines. Ideas? Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -

Access denied for user varlehti

annoying little problem? And what's even more important, how come the privileges just disappeared? No one has got access to the database but me, and no one has got access to my computer, either. Ideas, anyone? Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City

Re: Porting from MS SQL to MySQL

rid of our only Windows 2000 server : ) As I stated before, in our request for offers on the database (whatever the correct term might be), we specifically said that we wanted MySQL or PostgreSQL, which makes even more stupid to offer us MS SQL, because they (ought to) know that we won'

Re: Porting from MS SQL to MySQL

(food for ill-working-anti-spam-filters : database,sql,query,table) Just wanted to thank everyone who got involved in this (at times rather heated) discussion. You've given me quite a few pointers to think about and stuff to concider and take up with our project manager. Cheers mates! M

Re: Porting from MS SQL to MySQL

can't be true, because other companies had the same amount (or less) work hours for making it directly MySQL. Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709

Re: Porting from MS SQL to MySQL

On Friday 18 January 2002 15:58, you wrote: > On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote: > > We've requested a database from different companies, and > > specifically said we wanted MySQL or PostgreSQL because of the open > > source angle and we

Porting from MS SQL to MySQL

ted 18 000 euro. Now, what I want to know is, how easy is it to port a (fairly complicated) database from MS SQL to MySQL? It can't be work worth 18 000 euro, now can it? Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PR

Fwd: Re: compiling and/or running 64-bit MySQL on Solaris 8/sparc?

Forgot to CC to the list. Here it goes, in case anyone else has these problems: -- Forwarded Message -- Subject: Re: compiling and/or running 64-bit MySQL on Solaris 8/sparc? Date: Fri, 18 Jan 2002 15:06:57 +0200 From: Markus Lervik <[EMAIL PROTECTED]> To: Hatton

Re: C# and MySQL without ODBC

On Mon, Jan 14, 2002 at 03:03:11PM +0200, Sinisa Milivojevic wrote : > Markus Fischer writes: > > Does someone know if there's a native C# implementation > > available OR a wrapper around libmysqlclient for C#? > > As far as I know, no not yet. Ok, thx.

  1   2   >