Hi all!
Regarding my earler question about storing text as binary - I found no
problem storing the text as mediumtext or longtext, and then dragging it out
with a normal "mysql_query ".This solves my problem.
However, if anyone has other ideas I'd love to hear them!
Thanks very much!
-W
Hi,
Thanks for all the advice, one question, the create a JOIN table, you
mean just create a table, is the naming convention for join tables
something like:-
join_jobTitles
In other words prefix all join tables with join_?
M.
In message <[EMAIL PROTECTED]>, Gerald L. Clark
<[EMAIL PROTECTE
please tell me about this error:
> Fatal error: Call to unsupported or undefined function mysql_pconnect() in
>mainfile.php on line 17
or
> Fatal error: Call to unsupported or undefined function mysql_pconnect() in
>./db_mysql.php on line 73
Thanks
--
If I run the following query , mysql server process hangs forever and
it shows the "Sending data" status.
select Count(*) from
Registration,Candidates,CompanyJobs,Resumes,CandQual
where
CompanyJobs.qualcode=Candidates.qualcode
or CompanyJobs.qualcode=CandQual.qualcode
Hi,
I'm trying to install RH7(Guiness) Mysql RPM. I installed mysql-3.23.22-6
RPM,mysql-devel-3.23.22-6 RPM,mysql-server-3.23.22-6 RPM
I used the GNOME RPM installer from files from the RedHat CD2.
I tried /usr/bin/mysqladmin -u root password 'new password'
and it returned
>connect to server a
Dear Santa,
here is my wishlist:
I wish that the mysql utility had support for the shell's history functions. I catch
mysql so many time doing something like !show
regards,
thalis
-
Before posting, please check:
ht
ok... this is stumping me perhaps I'm doing something wring, but It
doesn't appear that I am
Am I doing, or not doing something that makes the INET_ATON function
default to 127.255.255.255 ? why does it work for 24.18.10.5, but not
192.168.50.5 when inserting into a table?
mysql> SELEC
I am trying to figure out how to use the binary log
for incremental backups. I have read the section for
this in the manaul but I have not been able to get it
to work. My main problem is I don't know the exact
command to use or exactly how the process works. Any
suggestoins on how to set this u
Hi,
I can store and retrieve binary data in the form of image or sound files.
However, I wanted to store up to say, 10,000 bytes of textual data. Since
varchar has a 255 byte ceiling I thought that mediumblob might be nice for
this. I can store the stuff as mediumblob without difficulty.
Howe
Hi,
My main experience is with Informix databases, but am trying MySQL on
our web server (ver 3.23.33 running on Linux 2.2.16-3). In general
it's working well, but being a MySQL newbie I'm a bit mystified by
some odd select behavior.
With Informix, doing a simple select like "select * from foo"
On Tuesday 20 March 2001 12:28, Jeremy D. Zawodny wrote:
> On Tue, Mar 20, 2001 at 09:09:41AM -0700, Sasha Pachev wrote:
> > On Tuesday 20 March 2001 07:58, Richard Ellerbrock wrote:
> > >
> > > Also, it would be REALLY cool to be able to specify a time limit
> > > for a select after which time i
You'll have to be more specific in your example -- your select statement
below is rather ambiguous.
However, take a look at the CASE WHEN...THEN functions that MySQL offers.
I'm sure it's exactly what you are looking for.
- Original Message -
From: "Bryan Coon" <[EMAIL PROTECTED]>
To: <
You should look up mysqladmin in the manual. It depends on what you want
to know. mysqladmin ping will tell you if the server is alive or not, or
you can use mysqladmin status to get a brief stat report about the server.
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECT
Jason Bell wrote:
>
> Hello all!
>
> Does MySQL have a function that converts an IP address from dotted decimal to
>binary, and back
> again?
>
> Jason Bell
>
INET_NTOA
INET_ATON
I'll leave it as an exercise to you to read Manual Chapter 7.4.12.
Fabio Galarraga wrote:
>
> Hi to all:
> Somebody knows how to make a read/writa table lock?
> I'm trying with java source:
>
> stmt.execute("LOCK TABLES table-x READ, table-x WRITE");
>
> stmt.execute("UNLOCK TABLES");
>
> but it fails.
>
> Best regards,
> Fabio Galarraga
> [EMAIL PROTECT
Hopefully this is not too lame a question...
In oracle, I can do this:
select a, b, c from A, B, C where a = A.a (+) and b = B.b (+) and c = C.c;
What is the equivalent in MySQL? The (+) allows that 'where' statement to
be kind of optional (I think). Basically I want to do a select on multiple
On Tue, Mar 20, 2001 at 09:09:41AM -0700, Sasha Pachev wrote:
> On Tuesday 20 March 2001 07:58, Richard Ellerbrock wrote:
> >
> > Also, it would be REALLY cool to be able to specify a time limit
> > for a select after which time it would die. I know this can be set
> > globally, but this will not
Hi,
I have a problem with 3-23.34a, running a shell scripts like this:
.
for table in ${table-list} # that is a very long list, just about 1030
# different tables
do
Yes, but it makes it hard to track down who/what piece of code entered
those bad values. You just have to clean them up later and wonder.
Not the end of the world, but I have some cases where I'd rather fail and
deal with the error at time of input (have them re-enter or whatever).
thanks
-b
I am running linux 6.2 (2.4 kernel) with MySQL3.23 installed. This kernel
allows MySQL3.23 to support large file sizes, up to 4 Gigs.
It looks like the mysqldump utility is still bound by the 2 GB file size
limit. Does anyone know how to get mysqldump to recognize the
large files.
Heikki,
I hope Sinisa will be able to find out the problem :)
I noticed that it there were 2 connections to the server. But
I'm sure that I've no process of my own connecting to the server.
And another strange thing is that it's always the same connections:
===
On Tue, Mar 20, 2001 at 03:05:53PM -0300, Fabio Galarraga wrote:
> Hi to all:
> Somebody knows how to make a read/writa table lock?
> I'm trying with java source:
>
> stmt.execute("LOCK TABLES table-x READ, table-x WRITE");
>
> stmt.execute("UNLOCK TABLES");
>
> but it fails.
And what is t
Steven Glogger wrote:
> LOG FILE =
> 010303 18:30:11 Aborted connection 1727 to db: 'unconnected' user: 'admin'
> host: `localhost' (Got an error reading communication pa
> ckets)
> 010303 18:33:11 Aborted connection 1729 to db: 'unconnected' user: 'admin'
>
Hi.
It's kind of counter-intuitive to me as well, but the rationale is that
there obviously was an error if you have a "" value for an ENUM column. this
theoretically allows you at some later time to use that indicator to do some
sort of error-check or update/delete all erroneous rows, or whatev
Alex,
I looked at the new debug log you sent and obviously some client is
making connections to your server. This cannot come from
Innobase, there must be some client process running on your machine.
>From the debug log I find the following:
...
T@11 : info: handle_
Hello all!
Does MySQL have a function that converts an IP address from dotted decimal to binary,
and back
again?
Jason Bell
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
Yes, I have tried it both ways. I configure Apache a second time after
making php and it still does not work. :(
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
> Subject: Re: [PHP-DEV] RE: 4.0.5RC1 static build with Apache 1.3.19
> problem
>
>
> Did you configure Apache af
I have found at least three ways to check up/down status of MySQL. I am
wondering what is considered the most reliable method, please comment
and add if you have another method.
1. Check for existence of PID file created by MySQL
2. Check for existence of mysql.sock
3. Verify connection via teln
Hello,
We're are a little worried about the ratio of tmp_disk_tables to
tmp_tables. We are assuming the created_tmp_tables from `mysqladmin
extended-status` represents the total number of temporary tables created
and created_tmp_disk_tables from `mysqladmin extended-status` represents
the number
That was a mistake by myself.
it was /tmp/
so, if i make ps
i can see that there are 4 mysqld processes are running
could this be the problem?
And if i use:
ps -aux|grep mysqld
there is only a difference between the process id.
nothing else?
ideas???
Regards
Denis
On Tuesday 20 M
Hi to all:
Somebody knows how to make a read/writa table lock?
I'm trying with java source:
stmt.execute("LOCK TABLES table-x READ, table-x WRITE");
stmt.execute("UNLOCK TABLES");
but it fails.
Best regards,
Fabio Galarraga
[EMAIL PROTECTED]
-
At 11:22 AM 3/20/2001 -0500, Ravi Raman wrote:
>You can use an ENUM column type assuming the numerical range is less than
>65535 numbers.
>
>http://www.mysql.com/doc/E/N/ENUM.html
One problem I've seen with enums is that I end up with a blank ('') field
if I try to insert a row with a value in t
Did you quote the data before inserting it?
[EMAIL PROTECTED] wrote:
>
> Hello
> I am looking for help how to put gziped plain data file to mysql DB
> and then get it from there.
> Every time I try OUTFILE to file and then gzip -d file name I got file corrupted
> Any help will be appreciated
>
It is more likely /tmp/mysql.sock
tmp has no 'e'.
denis mettler wrote:
>
> Hi,
>
> I did. but the problem is the same.
>
> regards
> denis
>
> On Tuesday 20 March 2001 17:45, you wrote:
> > try:
> > [mysql]
> > mysql.default_socket = /temp/mysql.sock
> >
> >
> > Cal
> > http://www.calevans.c
Thank you, very much. Just glad to know nothing wrong.
Nick
- Original Message -
From: "Jeremy D. Zawodny" <[EMAIL PROTECTED]>
To: "Nick Taylor" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 12:20 PM
Subject: Re: why 3 processes?
> On Tue, Mar 20, 2001 at 1
You dont need a script or command to restore the database, mysqlhotcopy
just creates a copy of your database files (.MYI, etc.) in the
/pathToTheBackupDirectory/. It basicaly performs the same function as the
unix command cp, only it does the necessary locking, etc.
John Barton
Unix Systems Admin
On Tue, Mar 20, 2001 at 10:51:14AM -0500, Nick Taylor wrote:
> Howdy:
>
> New guy to MySql and just installed 3.23 to my redhat 6.2 server.
> Was wondering why I get 3 processes started for mysqld.
Because that's how the Linux kernel implements threads. (This seems to
come up every week.)
Jerem
My question is that,
why is he trying to connect through socket in /var/lib/mysql
cause i have installes in /usr/local
and the path to the mysql.sock is in php3.ini /temp/mysql.sock
any ideas?
regards
denis
On Tuesday 20 March 2001 14:52, you wrote:
> it looks like that:
>
> [MySQL]
> mysql.d
On Tue, Mar 20, 2001 at 11:55:59AM -0500, [EMAIL PROTECTED] wrote:
> Hello
> I am looking for help how to put gziped plain data file to mysql DB
> and then get it from there.
> Every time I try OUTFILE to file and then gzip -d file name I got file corrupted
> Any help will be appreciated
Are you
Hi again
No .. not really that big (the table)
-rw-rw 1 mysqlmysql 100916 Mar 16 17:09 imp_addr.ISD
-rw-rw 1 mysqlmysql1024 Mar 16 17:09 imp_addr.ISM
-rw-rw 1 mysqlmysql8648 Mar 9 11:06 imp_addr.frm
100K the ISD
Hello,
I encountered following problem: when using older mysql (3.22.23 vs
3.23.33) then older is about 4-6 times faster on the same machine. What
could be the problem? Sytem is Debian 2.2r2, older mysql was from .deb but
newer i built myself. The query looks like this:
SELECT f.foto_id, f.imgna
You mus use GNU tar.
±è°æ¾Ö wrote:
>
> Hello!!
> I have a question for the mysql install.
>
> Type of mysqlsource distribution
> Mysql Versionmysql-3.22.32.tar.gz
> My System SunOS stachyonbse01 5.7 Generic sun4u sparc SUNW,Ultra-60
>
> After upload
> > gunzip > mys
houda chraibi wrote:
>
> Hello everybody,
> I have some pb to administrate mysql, I can't create a new database error:
> you are an anonymous localhost
> I just can create a new tables in database already exist.
> what can I do , please help m!!!
Read chapter 6sss!!!
--
Hi,
I did. but the problem is the same.
regards
denis
On Tuesday 20 March 2001 17:45, you wrote:
> try:
> [mysql]
> mysql.default_socket = /temp/mysql.sock
>
>
> Cal
> http://www.calevans.com
>
>
> -Original Message-
> From: denis mettler [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, Marc
Hello
I am looking for help how to put gziped plain data file to mysql DB
and then get it from there.
Every time I try OUTFILE to file and then gzip -d file name I got file corrupted
Any help will be appreciated
Leo
**
T
Add execute permission to mysql.server.
It is compiled without it.
Tim Thorburn wrote:
>
> Hello,
>
> I'm a MySQL newbie (hopefully, there's a few others of me around so I won't
> feel like I stick out so much).
>
> I've setup a Linux box running Red Hat 7.0 with Apache 1.3.12, PHP 3.0.18,
>
After upgrading from 3.23.32 to 3.23.35 I stopped getting statistics
when using mysqlimport. (Records: Deleted: Skipped: Warnings:)
I took a quick look at 3.23.32 mysqlimport.c and it is the same code as
3.23.35.
The command
---
mysqlimport --ignore --verbose --fields-terminated-by='
Hi,
If I use "mysqlhotcopy database/pathToTheBackupDirectory/" to backup the
whole database, what's the script/command to restore it?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
try:
[mysql]
mysql.default_socket = /temp/mysql.sock
Cal
http://www.calevans.com
-Original Message-
From: denis mettler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 10:40 AM
To: [EMAIL PROTECTED]
Subject: Re: Can't connect server through socket
/var/lib/mysql/mysql.sock(111
Having works on the result table, not the source tables.
Since you did not select cnt, having can not examine it.
Maybe you ment 'where' instead of 'having' ?
\"Piotr Gapinski\" wrote:
>
> small problems with query below...
> my fault?
>
> mysql> desc poll_answer;
> +-+-+--
I am using Access as a front end to a MySQL database via MyODBC. All is well except
when I try to delete a record from a table that contains a dat field. I get various
results, all not the desired result. Most often I get prompted to verify that I want
to delete the current form. Is this a
Is there a way in MySQL to limit the values that a (numeric) field can hold. For
example if I want a given field to only have the values 1 - 10 can I do this and can
it be done in the definition of the field when the table is created?
---
you can use either an ENUM or a SET. Other than that, no.
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 10:05 AM
To: [EMAIL PROTECTED]
Subject: Second Request - Limit Filed Input
Is there a way in MySQL
Hi.
You can use an ENUM column type assuming the numerical range is less than
65535 numbers.
http://www.mysql.com/doc/E/N/ENUM.html
-ravi.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 11:05 AM
To: [EMAIL PROTECTED]
Subject: Second
Bonjour Sinisa,
SM> The above could indicate some timeout problem.
SM> Can you build mysql --with-debug and start it with --debug and see in
SM> the trace file when are the above timeouts reported ??
SM> Also, do you have clients that do not call mysql_close at the end ,
SM> like PHP programs ?
Dear Gerald Clark,
Thank you very much for your response. I tried your lines and apparently
it worked fine.
Alonso Guarisma
Gerald L. Clark wrote:
> edit /etc/ld.so.conf
> add a line for the directory that contains your library
>
> run ldconfig
>
> Alonso Guarisma wrote:
>
>> Dear MySQL Sir
On Tuesday 20 March 2001 07:58, Richard Ellerbrock wrote:
> It would also be VERY cool to be able to adjust the priority of selects
like you can with inserts. In some cases I know selects are going to take
long and thus do not want them to take all resources.
>
> Also, it would be REALLY cool t
Hei
If I send a SELECT sql-request to my DB and this request returns an
"Empty set" ...
mysql_num_rows(MYSQL_RES *result) returns 0 - This is OK
but mysql_num_fields(MYSQL_RES *result) returns 1 - This is not OK ;-)
Why? Am I missing anything?
Sincerely
Rafael Martinez
On 20.03.2001 14:48:58 Sinisa Milivojevic wrote:
> Also, do you have clients that do not call mysql_close at the end ,
> like PHP programs ?
Huh? According to the PHP manual, I always thought that it is unnecessary to
explicitly call mysql_close() in PHP. In the PHP manual it says, that the
c
Hi,
This is my first posting, although i've been signed up to the list for a
while.
My problem is this.
Table A (5000 rows)
ID, NAME, SCORE
Table B (1000 rows)
ID, NAME, SCORE
I want all records from Table A and those from Table B where they match, for
this i'm using a right join. However, t
An example query and an explanation of what you are trying to do
would be helpful.
Thanks
On Tue, 20 Mar 2001, Brunella del Sorbo wrote:
> Hi,
> the version mysql that I am using supports the transactions but these
> are not recognized from the DBD.
> How can I resolve the problem?
> Thanks
>
Howdy:
New guy to MySql and just installed 3.23 to my redhat 6.2 server. Was
wondering why I get 3 processes started for mysqld.
[nick@Dell1 nick]$ ps -ax | grep my
615 ?S 0:00 sh
/usr/bin/safe_mysqld --datadir=/var/lib/mysql --pi
646 ?S 0:00
/usr/sbin/mysqld --bas
Hi,
i deleted mysql in /var
and make re-install in /usr/local/
but received the same error.
so i make an entry in the php3.ini
[mysql]
mysql.default_socket = /temp
where i found the mysql.sock
the error message is still there?
Other ideas?
regards
denis
On Tuesday 20 March 2001 14:52, yo
Hi Nick,
I think u have to make the following.
go to mysql prompt:
use mysql;
then
select * from user;
is there an entry for the mysql client and the user on it?
i don't think so.
so u have to make a new entry.
then:
grant all on *.* to username@clienthostname
username (username u are conne
edit /etc/ld.so.conf
add a line for the directory that contains your library
run ldconfig
Alonso Guarisma wrote:
>
> Dear MySQL Sirs (or Andrew Schmidt)
> Please see attachament for error messages.
> Thaks in advance for any help.
>
> Alonso Guarisma
>
> Original Message
> S
Paul Coleman writes:
> I am running mysql version 3.23.35 on a linux platform.
> The hardware platform is a PIII 700 with 500Mb of ram and a fast SCSI drive.
> The server is currently supporting about 200 concurrent connections, with a
> view to up this to a couple of thousand.
>
> My probl
Tim Bunce writes:
> On Mon, Mar 19, 2001 at 02:24:52PM +0200, Sinisa Milivojevic wrote:
> >
> > Hi!
> >
> > I tested your test case and you are right !
>
> We've just discovered a very similar sounding problem immediately after
> upgrading to 3.23.35. In our case an update is reporting
Bonjour Heikki,
HT> let us see. A known bug with Innobase is that was not included
HT> in univ.i in directory mysql/innobase/include. Then Innobase files are
HT> created with arbitrary access permissions on some Unixes.
HT> Could you look with ls -l what permissions Innobase data file ibdat1 ha
This is documented in the manual as a "kernel fork bomb". See manual for solution.
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> "Paul Coleman" <[EMAIL PROTECTED]> 2001/03/21 12:35:28 >>>
I am running mysql version 3.23.35 on a linux platform.
The hardware platform is a PIII 700 with 500Mb of ram
>Description:
I have download the version 3.23.33 - BSDI(Intel) and when i tried to run
scripts/mysql_install_db, i receive the error below:
./bin/my_print_defaults: can't load library 'libz.so'
WARNING: The host 'wave.seachange.com' could not be looked up with resolveip.
This probably me
It would also be VERY cool to be able to adjust the priority of selects like you can
with inserts. In some cases I know selects are going to take long and thus do not want
them to take all resources.
Also, it would be REALLY cool to be able to specify a time limit for a select after
which time
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
On Mon, Mar 19, 2001 at 02:24:52PM +0200, Sinisa Milivojevic wrote:
>
> Hi!
>
> I tested your test case and you are right !
We've just discovered a very similar sounding problem immediately after
upgrading to 3.23.35. In our case an update is reporting 0 zero rows
updated which then triggers an
I am running mysql version 3.23.35 on a linux platform.
The hardware platform is a PIII 700 with 500Mb of ram and a fast SCSI drive.
The server is currently supporting about 200 concurrent connections, with a
view to up this to a couple of thousand.
My problem is the time it takes to make a conne
Your workstation may not be in the host table of the MySQL Server.
Pat...
- Original Message -
From: "Nick" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 9:31 AM
Subject: Problem Setting up MyODBC Driver
> HI
>
> I am trying to set up an ODBC connecti
for mysqld -child processes. i set it manually, but how to do it
automatically. has somebody done this ?
thanks
christoph
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
Hi Thanks for the help,
I checked again.
but i don't have an entry in php.ini
[mysql]
mysql.default_socket =
So, i did execute the tip from egon.
But now,
i don't get the content from .php files
but i think i'll get it to work today.
thanks
regards
denis
---
HI
I am trying to set up an ODBC connection between my Windows 2000 PC and
my Web Server which has a MySQL database on it. I installed the MyODBC
package for Windows NT and entered all the relevant information:
DSN E-SkyMySQL
MySQL host 192.168.1.100
MySQL Database Name eskylight
User httpd
and
>I get the following message if i try to connect to server:
>
>Can't connect server through socket /var/lib/mysql/mysql.sock(111)
Is mysqld running (ps -ax)?? is your mysql.sock in /var/lib/mysql?
I've only seen mysql.sock in /tmp if you've got a config file for
connection to mysql edit it to m
Alex,
let us see. A known bug with Innobase is that was not included
in univ.i in directory mysql/innobase/include. Then Innobase files are
created with arbitrary access permissions on some Unixes.
Could you look with ls -l what permissions Innobase data file ibdat1 has
on your machine and also
maillists writes:
> it looks like that:
>
> [MySQL]
> mysql.default_socket=
>
>
> but I think thats not the problem. has your apache enough rights to access
> the directory /var/lib/mysql ? if not edit /etc/group an add "apache" to
> group "mysql".
> -> "mysql:x:27:apache" or s
Jeremy,
Thanks for the info.
Do you happen to know how many actual hits a Yahoo or
eBay or Google get each day?
According to http://us.mediametrix.com/data/thetop.jsp
Yahoo had about 60 million "unique visitors" in Feb
Google had about 10 million
eBay was in the middle
Unique Visitor is the c
it looks like that:
[MySQL]
mysql.default_socket=
but I think thats not the problem. has your apache enough rights to access
the directory /var/lib/mysql ? if not edit /etc/group an add "apache" to
group "mysql".
-> "mysql:x:27:apache" or something similar, then make "chmod g+rx
/var/li
It's my mistake, for setting the same server-id on both servers.
Lois
-Original Message-
From: Neo Sok Lay [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 20 March, 2001 7:41 PM
To: [EMAIL PROTECTED]
Subject: URGENT: Replication problem
Hi,
I am currently exploring the replication feature
BAUMEISTER Alexandre writes:
> Bonjour,
>
> Here is my setup :
>
> Mysql-3.23.35 complied from sources with :
> ./configure --prefix=/usr/local/mysql --without-bench --enable-thread-safe-client
>--with-innobase
>
>==
Gilles Dumangin writes:
> Hi,
>
> I have a strange problem happening. I have created an application on a PC
> with Mysql-3.23.22-beta and I have different results than on a standard
> Mysql-3.23.35.
>
> The main problem seems to be at the following:
>
> Say have 6 rows with a column
Hi,
I get the following message if i try to connect to server:
Can't connect server through socket /var/lib/mysql/mysql.sock(111)
Cal said, i should modify my php.ini and should give the exact definition for
the mysql socket.
but i don't have an entry in the php.ini for mysql socket.
any idea
Hi Everyone
I know this type of question has been answered quite frequently so
please accept my apologies if this is "old hat" and just annoying. I
have spent a good few hours searching past discussions and the 'net
but I still haven't been successful so I'm posting my question here.
I am buildi
Hi,
U can check out this page to see what an alteon is:
http://www.alteonwebsystems.com/products/testing/
Regards
Pedro
- Original Message -
From: "Jeremy D. Zawodny" <[EMAIL PROTECTED]>
To: "Pedro" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 4:53 AM
Subject:
Hello all!
I have running now mysqld with --long-log option.
is it fully debug log of mysql?
becouse when phpmyadmin communicating with mysql it say
'Unknown database' error. But when i look to logs there is nothing
about this error.
How is possible turn on full log debuging.
Thank You!
S poz
Sorry,
MySQL does not yet support sub-selects.
Cal
http://www.calevans.com
-Original Message-
From: Budiono Tjiayono [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 6:17 AM
To: [EMAIL PROTECTED]
Subject: Exists and Not exists
Hi there,
I am a mysql newbie. Is there anybody t
Hi,
the version mysql that I am using supports the transactions but these
are not recognized from the DBD.
How can I resolve the problem?
Thanks
--
Brunella del Sorbo
Officine Digitali Srl
Idee Tecnologie & Soluzioni per il Web
Via Ferrarese 219/7 40128
Bo
You are getting that error because your JSP pages are trying to connect to
MySQL using the login javaworks and no password.
Either:
1: You've not GRANTed any permissions to javaworks@localhost
or
2: You did GRANT permissions but with a password and you are not sending the
password.
HTH,
Cal
http
At 09:47 AM 3/20/2001 +0100, \"Piotr Gapinski\" wrote:
>small problems with query below...
>my fault?
>
>mysql> desc poll_answer;
>+-+-+--+-+-+---+
>| Field | Type|Null | Key | Default | Extra |
>+-+-+--+-+-+--
Hi there,
I am a mysql newbie. Is there anybody that can help me solve this code, so that it can
run on mysql
$sql="CREATE TEMPORARY TABLE tempingr SELECT resepid FROM resep r WHERE NOT EXISTS
(SELECT * FROM what_ingr w WHERE w.resepid=r.resepid and NOT EXISTS
Hello!!
I have a question for the mysql install.
Type of mysqlsource distribution
Mysql Versionmysql-3.22.32.tar.gz
My System SunOS stachyonbse01 5.7 Generic sun4u sparc SUNW,Ultra-60
After upload
> gunzip > mysql-3.22.34.tar.gz | tar -xvf -
Result of the a
Hi!
On Mar 20, Basil Hussain wrote:
> Hi all,
>
> The original message below was posted to the BugTraq mailing list. Have the
> developers seen this? I know it talks about version mysql-3.20.32a (which is
> ancient), but he mentions that it affects other versions.
>
> Anyway, I don't run my MyS
Hi,
I am currently exploring the replication feature in 3.23.33 and
encountered this error the moment I start the slave server:
010320 18:38:13 Slave: connected to master '[EMAIL PROTECTED]:9900',
replication started in log 'FIRST' at posit
ion 4
010320 18:38:13 Slave: received 0 length pack
OH! You're running Apache. Why didn't you say so?
Can I also assume that the Apache processes are the clients of Mysql?
You can throttle back Apache to prevent a system crash much easier than you
can throttle Mysql (IMHO).
Use a line like this in Apache's httpd.conf file:
MaxClients 50
Thi
Hello everybody,
I have some pb to administrate mysql, I can't create a new database error:
you are an anonymous localhost
I just can create a new tables in database already exist.
what can I do , please help m!!!
1 - 100 of 120 matches
Mail list logo
