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

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

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

t does, remove it (naturally). 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 - Before posting, please check:

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

t take them in that case. 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 - Before posting, please check: http://www.my

Re: Porting from MS SQL to MySQL

arkus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the 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

SELECT ... INTO

change all the records by hand. I have gotten the names of the magazines into a table with an auto_incremented primary id field, but how could I get all the same names away from both tables and only leave unique names? -- Markus Lervik Linux administrator with a kungfoo grip Vasa City Library - R

Re: quote marks

quote the backslash too. I had the same problem with the CONCAT_WS function, and it turned out to be an escaping inferno. Store the 15" screen using '15\\\" screen' in PHP, and it should work. Cheers, Markus -- Mark

Re: [PHP] Performance

.cnf file - ) > > Jocelyn I'll have to check the timeout parameter. Thanks a million to everyone who replied, but me thinks it's time for me to move this discussion to the php-db mailing list, as it is becoming grossly off-topic. -Markus -- Markus Lervik Linux administrator with a kungf

Re: [PHP] Performance

omorrow at work. It just might be (came to think of it now), that php closes the connection every time I use a submit-button and it reloads the page. Technically speaking, that would be "ending a script", right? -Markus -- Markus Lervik Linux adm

Duplicate messages and quoting

e to 50 lines extra text. -Markus -- Markus Lervik Linux administrator with a kungfoo grip Vasa City Library - Regional Library - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mys

RE: [PHP] Performance

t every time I have to do a database query, I have to use mysql_connect again, because as Prottoss pointed out, PHP drops the connection every time a PHP-block ends. Not that it is that a big issue for my particular application, but knowing a workaround to this problem would be quite useful i

Re: [PHP] Performance

ag. I really wouldn't want to use , as I have this tag in a nifty function that is called from a bunch of scripts. Cheers, Markus -- Markus Lervik Linux administrator with a kungfoo grip Vasa Cit