mysql.sock

i've fix itthanksi've got another problem... when i rebooted the system...i can't anymore connect to the mysql database ...error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' thanks, rizal Megan Payne wrote: It is looking for the DBD perl module

how to creat stored procedure ??

Hi, i am a new userof mySQL, however i have experience inMSSQL server. ihave difficulties on creating stored procedure, triggers and views in mySQL. /---\ Confidential and/ or privileged information may be contained in

Mysql Keep restarting. help pls

Could anyone pls help ? I have installed mysql-3.23.38-1 into my linux server (SuSe) 6.4 Kernel 2.2.14 It keep dying and restart itself. Here is the Error log file listing: Number of processes running now: 2 mysqld process hanging, pid 16852 - killed mysqld process hanging, pid 16851 - killed

Re: how to creat stored procedure ??

Neither triggers, views or stored procedures are supported by MySQL. However you can write your application in a way so that you don't need either of them. Alice wrote: Hi, i am a new user of mySQL, however i have experience in MSSQL server. i have difficulties on creating stored

RE: why does it not work

On 22-May-01 Adrian D'Costa wrote: snip Thanks. Now I am into another problem. I am not sure whether it is php or mysql. Though it works in the command prompt of mysql. Below is the snippet of my php script. What I am trying to do is to randomly display a scroll from the special

Re: Possible UPDATE bug

[EMAIL PROTECTED] writes: Description: When updating a table after it has been selected with a LEFT JOIN, some UPDATE queries execute normally without actually updating the data, unless the data to be updated is selected normally first. This script is written in mod_perl, using

Re: AW: Another signal 11 dump ...

Stephan Skusa writes: What?? ... no I haven't ... It's slightly a problem doing exact logs ... cause this Database-Server crashes every 2-4 Days ... and does about 600,000 Queries an hour ... I generated a mysqld.sym ... if anybody needs this ... I'll send it ... I think this

Re: Strange error message for create-select query

alex writes: Hi ppl! I've a strange problem - I'm creating HEAP-type table and filling it with the result of select query from a relatively big table (containing ~2187000 records). The resulting error message is the following Got error code 127 from table handler And that's all :0)

Re: DBD::MySQL Help!!

If this was the binary install, I had the same problemso I compiled from source.problem went away. Hi, Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 --- I know this is prolly not the best list for this question, but its the only related list im currently

design question.

Ok, im working on a dynamic site with php and mysql. I allow people to upload csv files that I process via cron job and php script to get the data from the files into a table in my DB. My first thought was to read through each file line by line and do an insert for each line

RE: Installation Trouble

I installed the RPM from the MySQL site. I finally have it installed and the server appears to be running, but I have none of the access tools to get to the databases. I am setting this machine up in another country, so all is done via command line through ssh, that means I can't use any X

Cold Fusion Express

Hi. I am new to this list and I am having some problems. I have set up a small personal server at my house to set up a site for family and such. I am by trade a cold fusion developer. On the server at home I have a cold fusion express application server running on a win2k box using iis as my

Performance tweaking

I have developed a ftp searchengine, which uses a database for backend data storage. While mysql is indeed the fastest db for my needs, I wish to improve the searchtime a bit further. A typical query would be SELECT id, field FROM table WHERE field LIKE '%query%' I understand that the use

RE: Cold Fusion Express

Perhaps MyODBC would help you out... http://www.mysql.com/downloads/api-myodbc.html Don't know for sure but it's probably worth a look :-) HTH Jon -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: 23 May 2001 13:57 To: [EMAIL PROTECTED] Subject: Cold Fusion

fulltext match against score

Hi, I'm trying to switch my database searching over to the Fulltext method, but I'm having some problems. The search function works with single words, but when I search for multiple words I'm getting hundreds of results with no relevence to what I'm looking for. The score on these results is

RE: Porting Access to MySQL

Hi, You can use DBTools (http://dbtools.vila.bol.com.br). It's free, for Win32 and imports from MSAccess, Paradox, xBase and ODBC databases. []'s Crercio O. Silva -Original Message- From: Mitchell [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 22 de maio de 2001 19:43 To: [EMAIL

RE: mysql.sock

Raymond, Make sure the mysql server is running. If it is running.. check permissions on the file. If there are ok.. find where mysql puts your mysql.sock file and add a symbolic link from it to /var/lib/mysql/mysql.sock -C -Original Message- From: Raymund D. Nones [mailto:[EMAIL

innodb bug

Downloaded latest version of MySQL for Win95 (3.23.38-win) on May 21st. After mysqld command this is the response: C:\cd mysql|cd bin|mysqld Innobase: Assertion failure in thread 4293273545 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap.

RE: Sun-Solaris 2.6 binary

Jermey, I would really appreciate that. Our sysadmin said it'll take another few days before I can get the latest gnu compiler. Thanks, -eva- -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 3:47 PM To: Eva Hammel Cc: '[EMAIL PROTECTED]'

Help with a semi-complex select statement..

I have 4 tables, named: players - stores player id, name, team id teams - teamid, teamname goals - goals scored, player id, team id penalty - penaltys accumulated, player id What I'm trying to do is write a query to get the top 10 from any category and display them. I can do them individually

Re:innodb bug

Claudio, in the source distribution the macro __NT__ is defined. That makes it work only on NT and 2000. You should compile without __NT__ . See a posting by Miguel about 5 days ago. Regards, Heikki Downloaded latest version of MySQL for Win95 (3.23.38-win) on May 21st. After mysqld command

nothing append

I am using mysql 3.22.32 on solaris. when i start safe_mysqld , two process start : safe_mysqld and mysqld. But when i try to access to the database with an http request, or with mysql (the command line) nothing append ... there is nothing in var/server.err do you have an idee or where to

works in SQL not on page

When I execute this in mysql it works fine, but when I execute it on a web page it gives a Not Unique table/alias 'sporttable' I would expect errors if 'playerpayment' was in my FROM clause but as you can see it is not. Note my example: INSERT INTO playerpayment ( Family_ID, Player_ID,

Remote connect failure

Hi, I just installed mysql 3.23.37 on a FreeBSD 4.2 server. The access to the db works fine from the command line with -h=localhost option but when the localhost is replaced with the IP address it doesn't. I've added an entry in the user table with the IP address restarted mysqld. The entries

Re:innodb bug

At 18:10 23/5/2001 +0300, Heikki Tuuri wrote: Hi, Claudio, in the source distribution the macro __NT__ is defined. That makes it work only on NT and 2000. You should compile without __NT__ . See a posting by Miguel about 5 days ago. If you don't have the VC++ compiler use mysqld-max.exe

Problem with Update to 3.23.38

HI, I got the following problem with apache_1.3.20 + modssl-2.8.4-1.3.20 + openssl-0.9.6a + php-4.0.5 + mysql-3.23.38. After I upgrade the system, I can only connect to mysql server via the consle window. But, I am not able to use the php-mysql command to connect to the server via the

Re: Problems with sum() in a query.

I'm gaving a problem with adding several sums together when using a group by clause. The table I have looks like this: school_id int school_name varchar sport varchar cost_a float(9,2) cost_b float(9,2) cost_c float(9,2) The real table is normalized, figured it

Documentation for using MySQL with WebMail

Could someone point me to where I could find documentation for incorporating MySQL with WebMail? http://www.linuxdoc.org/LDP/solrhe/Securing-Optimizing-Linux-RH-Edition- v1.3/webmlimp.html walks you through installing WebMail, but it assumes you are using PostgreSQL. Any help would be

longblob

Hello everyone, I have mySQL 3.23 running on win2000 and encounter the odd problem: longblob-type field is treated as blob-type since I cannot put data more than 64kb in size into that field. Any suggestions are highly appreciated. Best of luck, Yuriy Zubarev

Re: Problems with sum() in a query.

The errors are in the example below not in the code that i'm working with. the group by would be school_name or school_id otherwise the query would error and I wouldn't be experiencing the oddities that I am. What it seems to be is that if I want to preform math on 2 sum functions, (+-*/) it

Advice on Random Numbers

I need to generate a RANDOM UNIQUE number for every new record. Is there an easy way to accomplish this inside of mySQL. TIA Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 (mail filter bologna: sql,database,query)

Re: Advice on Random Numbers

On Wed, May 23, 2001 at 02:22:02PM -0400, Dave Carter spake thusly: *] I need to generate a RANDOM UNIQUE number for every new record. Is there an *] easy way to accomplish this inside of mySQL. *] The way I do this for session ids is through a perl function that I wrote a long time ago.

Help needed

Hi there all, A little bit of a silly question here, I am used to using PHP Myadmin. What the problem is I have just been learning the command for creating etc.. using telnet, but I have a 2.5mb sql file that I need to run. The questions are; 1: How do I run this file via telnet 2: If I

Re: Advice on Random Numbers

*] I need to generate a RANDOM UNIQUE number for every new record. Is there an *] easy way to accomplish this inside of mySQL. *] The way I do this for session ids is through a perl function that I wrote a long time ago. Essentially I create a really long string of mixed case alpha

RE: DBD::MySQL Help!!

I had the same problem too. If you go to CPAN and then go to DBD::Mysql, click on the ftp site to Jochen Wiedmann's directory and scroll past the one that says DBD-Mysql-yada to the one that says Msql-Mysql-modules-1.2216.tar.gz and install that one instead, it should work. Worked like a charm

byte[] in mysql DB?

All, In order to save very large strings (fully-formatted HTML) in a mysql column, I have run it through java.util.zip's GZIP classes. The result of this process is a byte[] of variable length. I have as yet been unsuccessful at saving and retrieving this byte[]. (My column is currently a

RE: why does it not work

You didn't show the code where the mysql_query() is done. Further, you have RAND as r coded in your select statement, not RAND( ) as r. Is this live code? Cheers, Kent (filter feeder: database) - Before posting, please

Problem starting Mysql

I keep getting this message in the mysql .err file I have no id as to what to do or even look at. 010519 11:57:54 mysqld started /usr/sbin/mysqld: ready for connections 010520 4:02:33 /usr/sbin/mysqld: Binlog closed, cannot RESET MASTER Status information: Current locks: key_cache status:

Mysql Bug Report about Latin5 in 3.23.38max

Mysql Bug Report about Latin5 in 3.23.38max I downloaded Mysql Win32 sources and saw that : in share directory , in Index file there is #30 latin5 line. but in directory this file does not exist. all other files are correct and exist but there is not latin5 file??? Yusuf Incekara Regards

RE: mysql.sock file

At 05:48 PM 05/22/2001, Angerer, Chad wrote: Dennis, do a find / -name mysql.sock 2/dev/null to find exactly where mysql puts this file.. My rpm install put it in /var/lib/mysql/mysql.sock Find where your mysql.sock file is and make a symbolic on it pointing to /tmp/mysql.sock ln -s

How many queries per second do you get?

Hello, I was just looking at my MySQL databse using mytop and saw that I was getting over 60 queries per second. Can people give me an idea of how many queries per second they get? Thanks, Nathan Hendler Tucson, AZ USA http://retards.org/

How to tell when I need more memory?

How does one know if their database server needs more memory? I have several tables around 600,000+ rows that are being joined. I have 512MB of memory. Is there a rule of thumb, or a good way to calculate how much memory my database server needs. Can I run my bigest query through some

RE: mysql.sock file

At 04:47 PM 05/23/2001, Angerer, Chad wrote: Well.. not sure if this is right but if you start up the mysqld server on startup the mysql.sock should be created in that directory always, so the symbolic link will always point to the same place. Otherwise.. I believe the directory will be in your

replication involving now() is sketchy if the two server clocks differ.

Description: replication involving now() is sketchy if the two server clocks differ. How-To-Repeat: Have a replicating server with a different clock (or timezone!) than the primary server. Do an insert or update or anything involving now() and it'll get weird, since the second server may or

RE: Help with a semi-complex select statement..

hi. i would suggest doing this in 2 queries, one to get the penalties, and one to get the goals...as you can only really get the top 10 for one of them. if you want the top 10 leaders in penalty minutes, and the goals scored for that player, you can join the goals table in there as well and

Request for feature: making SELECT FROM ... IS NULL mirror LAST_INSERT_ID

I've been arguing with MS Access lately. Fortunately, I won. But only because I had the source to MySQL available. Here's the situation: (If you're looking for the feature request, skip to the end of the e-mail. This message is a summary of a series of message posted on the MyODBC list.

Best Choice?

Hi everyone! I'm going to be working on a Honors Project and I'm wondering if I've chosen the best set of tools. The software I am designing is intended to be installed on isolated Win32 machines (hopefully will be ported to Linux and/or WWW app someday). I have chosen to use Visual C++ and

Mysql Compile Problem ..

Hey, After configuring MySQL 3.23.36 (first using Apachetoolbox but then just compiling it from the downloaded source). I have run into this problem. Any ideas? I'm running RedHat 7.0 on an X86 box. Making all in libmysql make[2]: Entering directory

Re: Problem with Update to 3.23.38

This is no bug. This is usually a result of 1. The mysql server not starting. 2. Incorrect permissions. 3. socket file is in the wrong place and yes, you can define the location of the socket file. RTFM for this. - Original Message - From: Mark Lo [EMAIL PROTECTED] To: [EMAIL

Bug Report - Installation on MacOS X (10.0.3 Build 4P13)

Machine: PPC G3 (Rev. A iMac), 288 MB RAM Problem occurred when running 'make install'. It configured fine (Configure command: ./configure --prefix=/usr/local/mysql-3.23.38) and compiled fine. However, 'make install' exited as follows: . . . /usr/bin/install: run-all-tests and

newbie question

Dear, I apologize if this question stupid. I was see many question about MySQL file system with the word INNODB, MyISAM and other. I wonder which the best type to use in Linux because I did not know more about Unix file system. So, I was install mysql by default and I want to know

weird indexing behavior in presense of limit

I have a very large table, where one of the columns is color enum(red, blue, black) The distribution of values is 90% black, 8% blue, and 2% red. I want to be able to randomly select 10 rows matching a certain color from the table. Of course, select * from my_table where color = black

BerkleyBD compat

using berkleydb3.2.9 with patch1 and patch2 when compiling MySQL 3.23.38 I add --with-berkeley-db --with-berkeley-db-includes=/usr/local/BerkeleyDB.3.2/include --with-berkeley-db-libs=/usr/local/BerkeleyDB.3.2/lib so it configure and

Re: mysqlgui: Can't connect to local MySQL server through socket '' ( 111) error

Hi there, Where do I find mysql.sock file? I couldn't find it under mysql or mysql-gui directory. Thanks Wei --- Sinisa Milivojevic [EMAIL PROTECTED] wrote: Jausions, Philippe writes: Hi, Just wondering how to get through that Can't connect to local MySQL server through socket ''

database directory permissions (unix)

is there any way to (config file or something) to preset what a database directory's permissions are when it is created (i want the database's directory to have permissions of 755 for a program that i'm writing, but it appears to default to 700)... i know i can write a script to perform this

RE: why does it not work

On Wed, 23 May 2001, Don Read wrote: !-- end -- /script form ?php while($row = mysql_fetch_object($result)) Do you plan on executing a mysql_query() some time before this ? Actually it is executed before this. This scripts works fine on my local host running php 4.0.1pl2.

RE: Porting Access to MySQL

hello all this is to inform u that i am running mysql 3.23.26 on linux 7.1 redhat but some problem with the mysql demon i am not able to stop the service through /etc/inet.d/mysqld it is showing serviece failed can any aone help me Thanking You, CBayScribe SysAdmin, CBayScribe Support.