unable to run the mysql server on Start up on Solaris?

Hello Gurus, I have installed the mysql-3.22 on Solaris(Intel) and when I execute the bin/safe_mysqld --user=mysql and support-files/mysql.server start successfully, runing the server and able to enter in mysql client. So, hold on startup as per support-files/mysql.server script document

Re: Time Weirdness

Depends on the column type -- what column type do you use for storing the time values? Bogdan Alex Kirk wrote: Is this a bug in MySQL 3.23.37? Could it have something to do with my OS (OpenBSD 2.9)? Or am I doing something wrong with the statement update time_worked set total = start -

Amazing, zero length files in mysql install kit !!

Hello mysql team, I have downloaded the following mysql kit to install on Solaris (intel) and gtar-i386.gz http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.39-pc-solaris2.8-i386.t ar.gz http://www.mysql.com/Downloads/MySQL-3.23/gtar-i386.gz and then done gzip -cd

RE: Problems in Foreign Key Syntax

I do not see this as a feature(documented bug). It is a handy implementation method for potentially saving storage space. Not all database designers (people who design databases as opposed to those who have a qualification to do so) understand the meaning of the various types. One database I

Re: Problems in Foreign Key Syntax

Hi! Heikki == Heikki Tuuri [EMAIL PROTECTED] writes: Heikki Hi! Heikki Ok, I looked in the manual and found the following: Heikki http://www.mysql.com/doc/S/i/Silent_column_changes.html cut Heikki So the bug is actually a 'feature'. Of course it would be better if the Heikki parser would

hostname.pid

How do I correct this database problem ? Please also reply to my E-Mail address. /usr/local/libexec/mysqld: Can't create/write to file '/usr/loc al/var/hostname.pid' (Errcode: 13) - Before posting, please check:

RE: hostname.pid

Hi, Check your autorisations for this file for the user mysql runs under. It does not have permissions to access the specified directory. Regards, Almar van Pel -Oorspronkelijk bericht- Van: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]] Verzonden: zondag, december 23, 2001 16.09 Aan:

RE: hostname.pid

Does the unix user who wunns mysqld have write permissions to /var/local/var (and does it exist?) M -Original Message- From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]] Sent: 23 December 2001 15:09 To: Mysql maillist Subject: hostname.pid How do I correct this database problem ?

RE: hostname.pid

Thanks for fast reply's :) How can I change it so that MySQL looks for the file at /var2/db by using the my.cnf file ? Regards Jacob [ www.sharksforum.com | www.eksperten.dk | +45 70 27 07 67 ] -Original Message- From: Almar van Pel [mailto:[EMAIL PROTECTED]] Sent: Sunday, December

RE: hostname.pid

The option --pid-file=/var2/db can be used for mysqld In my.cnf use pid-file=/var2/db Matthew -Original Message- From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]] Sent: 23 December 2001 15:26 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Mysql maillist Subject: RE: hostname.pid

Re: Is this possible with MySQL?

Ok, I will, but I CC it to the mailinglist, maybe others have interest and/or comments. Besides, I think I may have found a bug... Yes, of course my fault not to post directly to the list :) I have another problem with this query. If the textvalue field is the text type, then i get this

Query returns all records when a search box is empty

When I do a search for Author, Keyword, or Title and I leave a search box blank, the search is returning ALL records in the database: I only want it to return records from fields that match with the search criteria. I exported the database from MSAccess (with ALLOW ZERO LENGTH set to YES and

16Bit Dos Appl.

Hi mysql list, I am just new to the list. I have a 16 bit DOS APP which runs currently under a Windows box and I would like to access to a Mysql DB running on a LINUX Server. The appl. is made with MSC 6.0. Is there any API or Client for me which I could use, or somebody has a tip how solve

Perl Problem!

Hi! I have a proplem using my perl code to write some data into my mysql database. When running in consolemode anything works fine, but when executed by the wwwserver the scripts is processed without errors, except the data is not written into the database! Any idea how to fixit? Thanks in

MyODBC, MySQL Access 2000

I downloaded and installed the latest MyODBC drivers for Win2000 and got everything installed and configured. My question is this, when I run an append query, Access pops-up a message box saying something like: You are about to append 737 records, are you sure you wish to continue?

RE: Perl Problem!

Hi, Could it be that no data is written, or read from the files when executing from the server? Possible your server uses another user then mysql. And the server has no access to the files, or the permissons set on the files do not allow them to be read from that user. You should test it by

Can't create database

All: I have been trying to just simply create a database and I receive the following error: mysql create database MyCollection; ERROR 1006: Can't create database 'MyCollection'. (errno: 13) I know it is a privilege problem but I cannot figure out where it is located. i have tried creating

Re: Is this possible with MySQL?

select distinct t1.textkey, if(t2.textid,t2.languageid,t3.languageid) as languageid, if(t2.textid,t2.textid,t3.textid) as textid, if(t2.textid,t2.textvalue,t3.textvalue) as textvalue from texts t1 left join texts t2 on t2.textkey=t1.textkey and t2.languageid='da' left join

exporting from a local MySQL to remote ISP/MySQL

I have installed and configured MySQL server on my local win 98 machine How may I export the locally created DB to my remote ISP/MySQL? Any third party tool? My site is set on Linux/Apache my local machine is Win 98 Thank you Henry

Re: Time Weirdness

You must make sure you don't perform arithmetic differences between integer values such as 2000 representing 8:00 pm and 1945 representing 7:45 pm because that obviously would result in wrong values. For example 2000-1945=55, which is arithmetically correct but not the desired result if you want

Re: Query returns all records when a search box is empty

Hi, The part: AND 'varAuthor' '' is a test to see if the variable is empty or NULL -Michael Uh, I think the problem is that if nothing is entered, you search for '%' + nothing + '%' , so in effect, you search for '%%' , which is everything. Have your code check if the fields you're

Re: Is this possible with MySQL?

Ok, I will, but I CC it to the mailinglist, maybe others have interest and/or comments. Besides, I think I may have found a bug... Yes, of course my fault not to post directly to the list :) I have another problem with this query. If the textvalue field is the text type, then i get

String comparison (3.23.41)

select VERSION() +---+ | VERSION() | +---+ | 3.23.41 | +---+ select fff=fff +-+ | fff=fff | +-+ | 1 | +-+ Query OK, 1 rows in set (0,06 sec) Maybe this is not a bug, but in my case i need an

Re : String comparison.

You should use binary attribute. mysql select binary fff= fff ; +-+ | binary fff= fff | +-+ | 0 | +-+ 1 row in set (0.28 sec) mysql select fff= fff ; +--+ | fff= fff |

Cannot connect remotely to MySql Server

Hi I am a novice in Mysql, and have recently managed to configure my IIS-JRun server to connect to MySql. However, when I try to test the connection, I get an error message saying Server Configuration denies access to Data Source. Please let me know whether the configurations that I shall have

Re: How can i autostart MYSQL

edit your rc.local file and add the command to start your mysql server. Curtis On Sat, 22 Dec 2001, sreedhar wrote: hi all, How can i autostart MYSQL while starting of my LINUX server. regards, sreedhar - Before

Re: Problems in Foreign Key Syntax

I wasn't on the list when the thread below started, but I saw it on google and wanted to add some more information, but this time, my columns aren't char based and I get the same error. Here's my SQL: CREATE TABLE `user` ( `user_id` int(11) NOT NULL auto_increment, `username` varchar(30)

Amazing, zero length files in mysql install kit !!

Hello Gurus, I have downloaded the following mysql kit to install on Solaris (intel) and gtar-i386.gz http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.39-pc-solaris2.8-i386.t ar.gz http://www.mysql.com/Downloads/MySQL-3.23/gtar-i386.gz and then done gzip -cd

unable to run the mysql server on Start up on Solaris?

Hello Gurus, I have installed the mysql-3.22 on Solaris(Intel) and when I execute the bin/safe_mysqld --user=mysql and support-files/mysql.server start successfully, runing the server and able to enter in mysql client. So, hold on startup as per support-files/mysql.server script document

Problems in Foreign Key Syntax

Hi!! I have been trying to create the following tables:- 1) create table scenario ( scenario char(10) not null primary key, copyfromscenario char(10)) type = innodb; 2) create table attributekit( attributekit char(25) not null primary key, expression blob not null, linkoperator char(5)

Check Constraint In Mysql

Hi !!! Is there a check constraint available in Mysql? If there is one plase send the Syntax as well Amit Lonkar __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com

MySQL 4.0.1 released

Hi! MySQL 4.0.1 is now released. I would like to start by saying that the MySQL 4.0.0-alpha release has worked very well and we haven't (yet) found any really fatal bugs in it. Our intention is to continue with development on the 4.0 series for a couple of more weeks and then shift to work on