Oi,
I cannot get my head around that.
I got a QS that worked fine, then I edited the PHP-script, not the part
which is now causing errors, and it does not work anymore. That is strange,
if there was a mistake in my query qhy should it work on my PC but not on
the web? Well maybe different vers
Dear J.T. -
Fowler, J.T. writes:
> This does not have to be fancy with lots of bells & whistles. In fact - the
> simpler the screen interface the better for the people who will be using
> this. I.E. text entry - tabular displays of valid entry values. Point and
> click would be nice but r
hi
When I run the command
shell> /usr/local/mysql/bin/safe_mysqld --user=mysql &
it creates the file /tmp/mysql.sock
the problem is that when i run the command
shell> mysql
it gives me this error:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.so
Hi,
I constantly get error messages like "ERROR 1114: The table 'SQL4b3_0'
is full" for a fairly simple query.
It works if I leave the "ORDER BY" away, but I really need that. The
result only has something like 2500 Results and there is an index on the
field by which I want to sort.
What can I d
Hi,
if I use a query like
SELECT id FROM table WHERE id IN (7,2,100,65)
is it possible to get the results ordered in exactly the same way as the IN
list (7,2,100,65)?
Mit freundlichen Grüßen,
REDLINK Mediendienste
Jens Vonderheide, Dipl.-Inform.
Telefon: (0171) 8395997
---
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject:table modification [ALTER TABLE DROP COLUMN name];
on large table (1.7gb) crashed mysqldnt
Description:- attempt to extract a longblob column from a large table
Hi,
I'm building a DBMs for distributed platforms using MySQL and CORBA. It's
completely written but I have a question 'bout the performance, does it
sound normal that I can call the next function ony 150 - 200 times a second
a PIII 700mhz with 128 mb ram??
int resolvequery(char * vraag, MYSQ
Hi.
Im occuring some proglems after the configure is done and I start the
'make' process, below is my result
from 'make':
make[2]: Entering directory `/usr/src/mysql-3.23.37/libmysql'
make[2]: stat:libmysql.c: Too many levels of symbolic links
make[2]: *** No rule to make target `libmysql.c', ne
Hi.
Im occuring some proglems after the configure is done and I start the
'make' process, below is my result
Note: This is on Slackware 7.1, Piii 650, 128ram etc and so on
from 'make':
make[2]: Entering directory `/usr/src/mysql-3.23.37/libmysql'
make[2]: stat:libmysql.c: Too many levels o
Hi~
I have inserted 1,000,000 record into table.
and selected 1 record using order by rand().
but, it was very very slow.
mysql> explain member ;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra
Have you looked at mysql_error() ? Are you sure $select_ is a valid php
variable name?
> Oi,
>
> I cannot get my head around that.
> I got a QS that worked fine, then I edited the PHP-script, not the part
> which is now causing errors, and it does not work anymore. That
> is strange,
> if there w
if you are not getting a valid result set back,
then the sql server is returning some type of
error.
to find the error, try this:
if($select_=mysql_query($sql,$db->CONN)) {
//query is good
//continue code
} else {
//query is bad
$err=1
$errMsg="Failed Query
>I've seen this problem posted before but I can't find any replies.
>
>When I start the server I get the following
>
>./mysql.server: @HOSTNAME@: command not found
>./mysql.server: my_print_defaults: command not found
>
>Obviously I've setup something wrong.
Looks like you installed mysql.server.
If anyone can tell what I'm doing wrong, I will be greatly appreciaed.
Here is the php code.
MySql Connection
And here are the error messages:
If anyone can tell what I'm doing wrong, I will be greatly appreciaed.
Here is the php code.
MySql Connection
And here are the
Try
mysql_connect( "localhost:/where/your/real/socket/path/is", ...
or
mysql_connect( "127.0.0.1:3306", .
And make sure mysqld is really running.
- Markus
- Original Message -
From: "Daniel Goldin (E-mail)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 06, 20
Hi,
I have two tables: table1 and table2.
Both tables share the same 'account_id'
column. In table1 there is a column
'active' which is always either 'y' (account
active) or 'n' (account inactive).
Now here is what I want to do...
I want to delete all entries from table2
with account_id matchin
Simon Grabowski wrote:
> Hi,
>
> I have two tables: table1 and table2.
> Both tables share the same 'account_id'
> column. In table1 there is a column
> 'active' which is always either 'y' (account
> active) or 'n' (account inactive).
>
> Now here is what I want to do...
>
> I want to delete all
NEWBIE QUESTION
Hello,
Just installed mysql on a solaris2.7 sparc machine, but I don't seem to have
permission to do
anything! I add a user by typing
useradd username
BUT HOW DO I SET THE PASSWORD? Someone suggested doing this:
mysql>insert into user (host, user, password) values ('localhos
Hi, i have the Mysql install in 1 host. I create 2 databases for my project.
One program access a database and the other program access the second
database.
The problem is: when i start the 2 programs, the response is slow.
Are there anything form to optimize my project.
---
I have two tables with exactly the same structure :
CREATE TABLE
threadhardwarefr9 (numeropost bigint(20) unsigned DEFAULT '0' NOT NULL,
icone tinyint(2) unsigned DEFAULT '0' NOT NULL,
numreponse bigint(20) unsigned NOT NULL auto_increment,
contenu text NOT NULL,pseudo varchar(35) NOT NULL,
date
Here's the saga.
1) I installed php, apache and mysql via redhat seven installation disks.
2) problems with mysql
3) reinstalled latest mysql from official site. (rpm wouldnt remove
distributions, so I renamed the old mysql bin files to a .bak extension
before installing new version on /usr/local
Use
\u mysql;
to select the database
In the query:
insert into user (host, user, password) values
('localhost', 'myname' password('testpass');
you are missing a bracket after ...('testpass')
--zak
- Original Message -
From: "Simon Chan" <[EMAIL PROTECTED]>
To: "mysql Mail Li
Does you /var/lib/mysql/mysql.sock exist ?
If not, try connecting through TCP/IP by removing localhost and writing
"127.0.0.1:3306"
- Markus
- Original Message -
From: "Daniel Goldin (E-mail)" <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Sunday, May 06, 2001 9:41 P
So sprach Alexander 'Digital Projects' Skwar am Sat, May 05, 2001 at 02:36:18PM +0200:
> So sprach [EMAIL PROTECTED] am Sat, May 05, 2001 at 12:30:27PM -:
> > Your message cannot be posted because it appears to be either spam or
> > simply off topic to our filter. To bypass the filter you must
If you wanted to do this using a SELECT you would do a LEFT JOIN or
equivalent action. Glancing over the DELETE syntax in the documentation it
does not look like DELETE supports any such mechanism. I dont think it is
possible to involve more than one table in a DELETE query.
ryan
> I have two ta
Is there a version of MySql for Windoze that supports BDB tables?
Rohit.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Sudhir" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, 03 May, 2001 9:23 PM
Subject: Re: Rolling back of a transaction
> At 5:34 PM +0800
I have had to install MySQL from a source distribution as the RPM
supplied with RH 7.1 doesn't work. Being new to Linux (stop laughing),
I have no idea how to get MySQL to start every time the server starts.
Anyone who has a detailed instruction sheet (I am a newbie) on how to
set-up the MySQL se
The RPMS supplied by RedHat with version 7.1, work flawlessly. However,
on a redhat linux system, do an RPM install, making sure you meet all
the dependency requirements (i.e. libmysqlclient, etc). Most recent RPMs
already have a configuration to have the MySQL daemon automagically
start on boot..
- Original Message -
From: "Siomara Pantarotto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 05, 2001 4:32
Subject: Problem with a simple select
> Hi all,
>
> I am able to show all the table in a database but when I try a simple
selct
> in one of the table I get the f
May mean that it is already running. Check with ps -ef | grep mysqld
- Original Message -
From: "Xiaowu Gai" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 05, 2001 6:07
Subject: mysql install problem
> Hi:
>
> I tried to install mysql on my machine. So I download the
At 12:16 PM -0700 5/6/01, Simon Chan wrote:
>NEWBIE QUESTION
>Hello,
>
>Just installed mysql on a solaris2.7 sparc machine, but I don't seem
>to have permission to do
>anything! I add a user by typing
>
>useradd username
That creates a UNIX user account, not a MySQL user account. They have not
Check to see if the socket file exists in the right place with the right
permissions.
- Original Message -
From: "Gordon Stewart" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 06, 2001 0:08
Subject: Error 2002
> Hi
>
> I have installed Mysql from the latest tar file and
What I did was leave those fields blank and then just specify them in my VB
code. Works for me.
- Original Message -
From: "Warren van der Merwe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 06, 2001 1:16
Subject: myODBC
> Hi there
>
> I have an ODBC connection to my d
- Original Message -
From: "Gordon Stewart" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 06, 2001 19:57
Subject: location of mysql.sock
> hi
>
> When I run the command
>
> shell> /usr/local/mysql/bin/safe_mysqld --user=mysql &
>
> it creates the file /tmp/mysql.sock
Hello,
I've got a problem:
My MySQL-Server gets signal 11 almost every day arround 0:00 am ... I have a
nice
mrtg - graph showing this ... ;o)
In fact every time the server crashes the statement shown in the server.log
(or a
similar one with other memID) is executed.
topsitesTEMP is a tempora
Yes,
If you use a Japanese OS for your server, you can set the language and
character set to Japanese. Manual will tell you how.
If you use an English OS for your server, leave the database as English and
use a front end that is capable of displaying and entering Japanese
characters. Viewing t
hi list,
thanx for answering my question.
i recompiled mysql with CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS
and now it works for me.
special thx to Shankar, who declared my problem in better words than
mine
and to Paul for knowing all from mysqlDocu.
ttfn
stefan
--
st3V13h
nach diktat verreist
Well... maybe it's off topic to some degree. There's also the PHP mailing
list, but I don't think they are quite as helpful.
Yeah, it's to do with the building of your .so file. I used mysql RPMs on
redhat system and built PHP from source. There are 2 particular options you
need to specify whe
So sprach kuttappan am Sun, May 06, 2001 at 11:20:40PM +0530:
> Is there a version of MySql for Windoze that supports BDB tables?
Don't know, but you can always compile it yourself, can't you?
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepag
I am currently investigating which software to use for a database and search
engine for a site currently under construction.
We are a mac-based design studio that has designed and constructed a 400 or
so page site, which is basically a product catalogue.
We want to include a simple search mechan
I am currently investigating which software to use for a database and search
engine for a site currently under construction.
We are a mac-based design studio that has designed and constructed a 400 or
so page site, which is basically a product catalogue.
We want to include a simple search mechan
>Description:
Compiled source on Slackware 7.2 Linux Sparc and install it. I then
ran mysql_install_db
and I get errors when installing the grant tables. It tells me that
mysqld caught signal 4.
>How-To-Repeat:
Either try and start mysqld or
Firstly, I'm not a Mac fan but from the list, I've read that it is possible.
Someone else may shed a light on this.
Since your not programmers, MS Access would be the easiest to use and set
up. Oracle, MS SQL server may be way too complicated without assistance.
However, Access doesn't handle a
Yes, I checked that "/var/lib/mysql/mysql.sock" exists. It does. I tried
connecting with "/var/lib/mysql/mysql.sock" suffixed after "localhost." Same
error.
I tried substituting "127.0.0.1:3306." Again, no luck.
I very much appreciate all the help I've been getting on this list. Mysql
seems to b
I've had similiatr problems setting passwords on my redhat box.
Tried % mysql -p -u root mysql:
Got error message:
"Access denied for user root@localhost" (using password:YES)
Help, please!!!
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Sunday,
Try chmod 755 /var/lib/mysql/
Good luck!
Eduard
__
CityCom
Virtual Spaces Real Solutions
www : http://www.citycom.ro
E-mail : [EMAIL PROTECTED]
Tel./fax : +40 56 143062
__
-
i use mysql 3.23.34a and using BLOB's and timestamps leads to errors (
when giving all timestamps the value "now()" only some of them return
the correct date the BLOB's don't even return anything ... )
... is this version that buggy ?
Hi guys
I wanted to setup password for mysql access so I typed 'mysqladmin
mypasswordhere' but now I have problems even doing mysqlshow
because it requires a password.
How do I disable the password ?
thanks
Tom
---
Use the -p option to allow you to enter the password.
--zak
- Original Message -
From: "Tom Gao" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 07, 2001 12:46 AM
Subject: mysqladmin
> Hi guys
>
> I wanted to setup password for mysql access so I typed 'mysqladmin
> mypass
I have installed mysql during the install of RH linux. When I try and
start the service, there is an entry in the error log stating it can't
find the host.frm file. Any ideas would be appreciated. I have copied
the host.frm file to every location under a ./mysql/ directory.
Thanks
Dane Knudso
50 matches
Mail list logo
