Hello Andreas,
Thursday, February 01, 2001, 7:42:31 PM, you wrote:
I must confirm the problem with table locks. Mysql realy may deadlock
sometimes, and the funny thing is the solution to this case is to kill
the oldest locked thread waiting this condition - afterwards
everything resolves. So th
Hi okie heres a snippet of my php code:
the code below takes a file uploaded from the web with $file as declared filename on
the form.
if ($file_size>0) { //check whether the file is not empty
$data = addslashes(fread(fopen($file, "r"), filesize($file))); //read the file and
add neccessary quote
Hi there,
I am considering porting a MS-SQLServer database to MySQL. After reading
some of the documentation, I am concerned about inserts.
I run a sports prediction website, where players submit their predictions
for a competition. When a player submits their predictions, this is
generally 10
Thanks to everyone who replied. I got a lot of people who said I should
either use phpMyAdmin or webadmin. It turns out that neither will quite do
what I need it to, and I just wanted to try to get any other suggestions.
In particular, the former doesn't allow one to put any kind of good sec
Uhhh... You probably need to either recompile Apache and or PHP with your new
version of MySQL. Copying the old library over the new one is going to cause
problems.
> I have no experience with recompiling libraries (I know this must
> sound dumb). I am a bit desperate, so I tried some other thi
Hello all.
We are currently using MS Access for a multi-user application (4-5 clients).
We sent out a system to a customer with NT Service enabled in anticipation
of switching over to MySQL.
We noticed that when activity on the MS database got heavy (if you can call
3 clients heavy activity) t
I have no experience with recompiling libraries (I know this must
sound dumb). I am a bit desperate, so I tried some other things.
So I solved it by copying ./lib/mysql/libmysqlclient.so.6
from version 3.22.32 to the same path in version 3.23.32.
I then restarted httpd.
I don't know how dangero
> >
> >I suggest you look for a new file called libmysqlclient.so (maybe in
> >another location) and symlink libmysqlclient.so.6 against it. After that
> >run 'ldconfig' and try to restart apache.
> >
> >Greetings,
> >
> >-
> >Rop Slijkerman
> >
>
I had a similar problem but this was due to the p
The mysql version compiled into your web server uses shared libraries and
your current version (upgrade) apparently is a statically linked version.
Recompile your web server/php/mysql executable with consistent use of
libraries i.e. either static or shared.
I hope this helps...
Pat...
- Orig
Hey Rop,
wist je wel dat ik het was (Tim van Rockingstone).
wat toevallig dat je zat mee te kijken. (beetje laat of niet?)
bedankt voor de tip.
Tim Samshuijzen.
(Sorry for the Dutch everyone)
At 02:49 4-2-2001 +0100, you wrote:
>On Sat, Feb 03, 2001 at 11:13:14PM -0200, Fábio Ottolini wrote
On Sat, Feb 03, 2001 at 11:13:14PM -0200, Fábio Ottolini wrote:
> Sorry but I'm not a Linux specialist... I think WE are going to need the
> help of others. :)
> Anyway... Now you gave enough details to get help.
Tim,
I suggest you look for a new file called libmysqlclient.so (maybe in
another l
Sorry but I'm not a Linux specialist... I think WE are going to need the
help of others. :)
Anyway... Now you gave enough details to get help.
BR,
Fábio Ottolini
- Original Message -
From: "Tim Samshuijzen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 10
At 10:15 PM +0700 2/3/01, Kiky wrote:
>Thank you for your reply :-)
>
>> Yes, you can add a mysql user that has access to mysql server from the
>> windows host and use this user to create the connection.
>
>## Is it possible to do this in PHP under Windows, without installing
>any
>mysql driver
Dear Fábio Ottolini,
Thanks for your reply.
I'm using Linux 2.2.16-22.
The exact error that appears is:
/usr/local/etc/httpd/httpd: error in loading shared libraries:
libmysqlclient.so.6: cannot open shared object file: No such file or directory
In MySQL version 3.22.32 there was a file ./li
I suppose your operational system is Windows... Or is it Linux? Regarding
Windows at least, and I believe Linux also, MySQL has got nothing to do with
your problem. If PHP is not working on your system, probabily this is
something related to your web server. Are you sure the correct MIME types
are
Hi,
I have just upgraded from MySQL 3.22.32 to 3.23.32. Now PHP3 does
not work. I've tried restarting httpd, but an error appears "file
not found", and httpd fails to start up. HELP!
What am I doing wrong?
Thanks,
Tim Samshuijzen
--
In the last episode (Feb 01), Jeff Sorenson said:
> Does anyone know of an elegant way to determine, within a query, whether
> two arbitrary lists have common element?
>
> I am quite fond of queries using "in", e.g: select * from A where 23 in
> (A.list) - where A.list is a comma-separated l
You can pack entire directory with your DB then unpack it on server or you
can dump DB, pack it and then unpack on server and load with mysql.
- Original Message -
From: Donald Korth <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 7:25 PM
Subject: Help :- To
>Description:
As i wrote before, there's a bug with the replication in mysql. If the server is once
stopped, it will not read properly the informations stored in master.info. The
IP-number is in this case 0. Mysqld will then write the error-message to the log-file
AND will not stop writing it!
Spam is stupid. Check this out to see why:
http://www.data1.com/spamus.html
On 2 Feb 2001, at 20:16, Colin Faber wrote:
>
> [EMAIL PROTECTED] wrote:
>
> > where i live this is illegal.
> > i hope these jerks don't have my email address.
> > can you do anything about this TEnon?
> >
>
On 3 Feb 2001, at 19:44, John Williams wrote:
> I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew
> of a good robust program to put a web interface on a database so that
> it can be viewed and modified by people who don't know SQL syntax.
>
> Thanks,
> John
phpMyAdmin: http:
Background info: One main table with basic entry info joined to other tables with
additional info about the entry. The additional info about the entry is based on the
entry type and is located in single other table (which other table depends on the
entry type).
- table LOG_LOG (this is the m
Does anyone know of an elegant way to determine, within a query, whether
two arbitrary lists have common element?
I am quite fond of queries using "in", e.g: select * from A where 23 in
(A.list) - where A.list is a comma-separated list of numbers in a
varchar(255) field.
Now I need somethi
>># after starting safe_mysqld I try this:
>>> mysql -u root
>># this fails whether I run as mysql or root
>># I get this error "ERROR 1045: Access denied for user:
>>'root@localhost' (Using password: NO)"
Just add -p to the end of that, and it should prompt you for the root password and let
y
Hello, what is the correct syntax forignore?
I have a table with columsn already put in, and primary key has 0 as value.
When I do "load data infil 'file.txt'...
it gives a duplicate error. Documentation says to use 'ignore'. But I can't get it to
work.
What is the *correct* syntax to load a
I am trying to write a query using the fulltext and match and I've run into a problem.
I'm new to MySQL, so this question might have already been asked, but I just can't
seem to find it.
I'm using the fulltext capabilities to do a query. The query requires joins with four
different tables.
You might want to try the php-nuke 'construction kit'. Looks good
(www.wageningen.org was build using this, take a look)
- Original Message -
From: "John Williams" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 8:44 PM
Subject: Web Interface
> I'm running
Webmin
www.webmin.com
-Original Message-
From: John Williams [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 03, 2001 1:44 PM
To: [EMAIL PROTECTED]
Subject: Web Interface
I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew of a
good robust program to put a web inter
http://www.php.net/
http://httpd.apache.org/
John Williams wrote:
> I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew of a
> good robust program to put a web interface on a database so that it can be
> viewed and modified by people who don't know SQL syntax.
>
> Thanks,
> John
Webmin is robust and it gives a good database interface... You can customize
it to only perform Database Administration
Check www.webmin.com
Regards
Claudio
-Mensaje original-
De: John Williams [mailto:[EMAIL PROTECTED]]
Enviado el: Saturday, February 03, 2001 4:44 PM
Para: [EMAIL PROTE
I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew of a
good robust program to put a web interface on a database so that it can be
viewed and modified by people who don't know SQL syntax.
Thanks,
John
_
Get your F
At 10:09 PM +0200 2/2/01, Ciprian wrote:
>*This message was transferred with a trial version of CommuniGate(tm) Pro*
>
>Anybody knows where I can find a list with all SQL syntax -es.
>Eventually explained.
>Thanks
If you mean the SQL statements supported by MySQL, the MySQL Reference
Manual is a
AUTO_INCREMENT columns are for positive integers. You're trying to use
the column for an unintended use, so it's not surprising that there are
unintended consequences.
At 6:43 PM +0100 2/3/01, [EMAIL PROTECTED] wrote:
>Description:
> If I use a table containing AUTO_INCREMENT field, and I
Description:
If I use a table containing AUTO_INCREMENT field, and I have there
a 0 value, OPTIMIZE TABLE will fail.
How-To-Repeat:
CREATE TABLE test(
ID DECIMAL(5,0) NOT NULL AUTO_INCREMENT,
text CHAR(20) NOT NULL,
PRIMARY KEY(ID)); // o
>
>Maybe you should try
>
>SELECT count(*) FROM bench WHERE year = 95 and
>-> value BETWEEN (0.7*63000) and (1.3*63000) ;
>
Hmm -- I thought, yes! But...
mysql> select count(*) from bench where year = 95 and
-> value between (0.7*63000) and (1.3*63000);
+--+
| count(*)
How can i do an update a column in a
table width the fields of another table
i would like to do the folowing query:
UPDATE enc_oper set estado = "N",
quant_prod = 1 * opera.quantidade whe
re encomenda = 20010004580 and posicao =
1 and opera.codigo = enc_prod.opera;
But i dont kn
I found the solution by meself in the manual :)
mysql> INSERT INTO snoeien VALUES
mysql> ('Acer palmatum ''Atropurpureum''' , 10);
- Original Message -
From: Rudi Van Overloop - Tuinkrant <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 2:49 PM
Subject: new
Hi!
> "Tim" == Tim Bunce <[EMAIL PROTECTED]> writes:
Tim> On Fri, Feb 02, 2001 at 05:48:41PM +0100, Marcello Giovagnoli wrote:
>> >
>> > Do you mean that mysql_store_result() should store everything to a
>> > local file and and mysql_fetch... should read from this file?
>> > This should not
Hi!
> "Marcello" == Marcello Giovagnoli <[EMAIL PROTECTED]> writes:
>> Do you mean that mysql_store_result() should store everything to a
>> local file and and mysql_fetch... should read from this file?
>> This should not be that hard to do.
Marcello> Yes, you can use the actual SQL_CURSOR
Hello !!
I'm trying to upload my database that's build locally on Win ME machine to a remote
Linux server . I'm using Ace-Ftp to upload my normal files. But i couldn't seem to
find the data files to which i can upload my database thro' Ace-Ftp . I've heard that
uploading the database needs to d
On Sat, Feb 03, 2001 at 10:20:07PM +0800, Teddy A Jasin wrote:
> I have the scripts in php to do this if u want.
Yes, that would help! thanks.
>
> "Robert C. Paulsen Jr." wrote:
>
> > How can I put binary data into a MySQL database?
> >
> > I assume the data type is blob, but I don't see how I
Hello,
I would like to upgrade MySQL from version 3.22.32 to 3.23.32.
The upgrading needs to be done within seconds because the
database is queried many times per second on a busy website.
I am not an expert on compiling and installing software on Linux.
Is it possible to simply replace the bin
Hi,
i'm very new working with MYSQL,
i have a problem with the type VARCHAR for plantnames,
- MYSQL use single qoutes for a field
- i have a plantdatabase, to use the correct spelling latin names cultivar names are
wirting
between qoutes
Example:
- For MYSQL i have to use this (I think) for th
Thank you for your reply :-)
> Yes, you can add a mysql user that has access to mysql server from the
> windows host and use this user to create the connection.
## Is it possible to do this in PHP under Windows, without installing
any
mysql driver for ODBC, or any other additional installation ?
On Sat, 3 Feb 2001, Kiky wrote:
> Dear all,
> I have to work wih PHP on Win 98/Win 2K, but I have to access
> MySQL on Linux.
> At the first time, I was trying to use ASP and using ODBC to access
> MySQL on Linux, but the problem is that installing additional
> components, even for MySQL driver
I have the scripts in php to do this if u want.
"Robert C. Paulsen Jr." wrote:
> How can I put binary data into a MySQL database?
>
> I assume the data type is blob, but I don't see how I can
> use SQL syntax to insert anything but text data. I would
> like to include various binary files (tar f
How can I put binary data into a MySQL database?
I assume the data type is blob, but I don't see how I can
use SQL syntax to insert anything but text data. I would
like to include various binary files (tar files, zip files,
image files, etc.).
--
___
Use CONCAT
- Original Message -
From: Sanjeev Adhyapak <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 6:42 AM
Subject: Update
> Dear Sir,
>
> I want to update one table. situation is like this. i have a table with 3
> columns.
>
> tablename - sample
> Fiel
Maybe you should try
SELECT count(*) FROM bench WHERE year = 95 and
-> value BETWEEN (0.7*63000) and (1.3*63000) ;
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 3:53 AM
Subject: BETWEEN problem?
> Can anyone explain the fol
Germany: 0,99 US$ per litre - That´s expensive, too.
gOoD rIdE!
Andy Dingfelder
> -Ursprüngliche Nachricht-
> Von: Fábio Ottolini [mailto:[EMAIL PROTECTED]]
> Gesendet: Freitag, 2. Februar 2001 23:00
> An: [EMAIL PROTECTED]
> Betreff: Re: [CGI] Gas Prices
>
>
> Brazil: US$0,825/litre -
David Gholami writes:
> I'm having a little trouble running a program I made with mysql++1.7.8, when
> I run the app it segment faults when the connect object is created.
> this is what I am running
> Red Hat Linux release 7.0 (Guinness)
> Kernel 2.2.16-22 on an i586
> Mysql 3.23.32
> mysq
Never mind. Dumb mistake. I had an older version of mysql
on this system set to a password which I forgot.
--
Jeff Greer
- B.S. computer science - Univ. MO - Rolla
- web developer/software engineer,
dedicated to the struggle against the fascist
Microsoft hegemony
--
Thanks, I`ll try it out.
- Original Message -
From: "Aaron Williams" <[EMAIL PROTECTED]>
To: "Siim Einfeldt aka Itpunk" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 10:55 PM
Subject: Re: turn $2000.00 into $1600.00 in 14 days
> At 10:25 PM +0200 2/2/01, Si
Could someone tell me why I cannot connect to mysql as
root. I just installed the rpm for 3.23.32. I have root
access to my machine. How do I get root access to mysql?
What am I missing in the directions? I have read them over
many times.
Here is what I have done:
rpm took care of these ste
Dear all,
I have to work wih PHP on Win 98/Win 2K, but I have to access
MySQL on Linux.
At the first time, I was trying to use ASP and using ODBC to access
MySQL on Linux, but the problem is that installing additional
components, even for MySQL driver - ODBC is not allowed by our company
policy.
M
55 matches
Mail list logo
