Seems like MySQL 3.23.34a has a problem (?). I'm using the RPMs from the
MySQL web site on RH 7.0.
CREATE TABLE files (
id int(11) NOT NULL auto_increment,
folderid int(11) NOT NULL default '0',
name varchar(100) NOT NULL default '',
date datetime default NULL,
PRIMARY KEY (id)
) TYPE=
I log all page requests to a rotating table name based on day of
week. Logging image requests is probably a bridge too far. This
gives me 7 days grace to archive off old tables to an analysis
database.
Originally it was done to one table, but this idea didnt work too
well because a purge based on
Hello ,
I am developing front end applications with backend mysql server in
vc++. Can anyone tell how to connect to mysql server using odbc. Where is
that specific api documentation is found. I badly need it for my project.
satish.
I've used both Visual FoxPro and PHP without a problem.
Cal
http://www.calevans.com
-Original Message-
From: Roberto Meyer [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 11, 2001 9:28 PM
To: [EMAIL PROTECTED]
Subject: Replace Axess as frontend
Hi,
We have had a lot of trouble with M
I installed the MySQL 3.23.34-1 rpm on my redhat 7 box. It all seemed to
work fine, but suddenly i got this error in numerous of my php scripts. it
happens only on update and insert statements. The data however might have
been stored in the db.
Warning: MySQL: Unable to save result set in /var/ww
Hello:
I am attempting to teach myself SQL. In pursuit of this, I want to install mySQL on
my home PC. I downloaded the file "mysql-3.23.34-win.zip". After unzipping this file
I couldn't find the "setup.exe" that the instructions state I need to run.
Am I doing something wrong? Is it po
I checked the known bugs in replication, and I've found a situation where it
definitely does not propogate changes. I'd just like to know if this is normal or
not.
Say you have two databases (call them data1 and data2) on your master server. Only
data1 is being replicated.
Within the mysq
Hi All,
I've been lurking around on this list for a few days, and searching archives and
darn near anything else I can get my hands on. What I'm curious to find out is,
how many people are using MySQL for logging Squid/Aapache (more Squid) and how
did you go about doing it.
I've already implim
>Description:
the *tab* auto-completion does not work if tablename has 1st 2 chars uppercase.
>How-To-Repeat:
Open mysql command line. "Create table BLahblahblah(ID integer);"
Then try to tab-complete it on a SELECT statement. (SELECT * from B..)
>Fix:
No fix known
Hi,
We have had a lot of trouble with M$Access2k as a frontend to
MySQL... even if we've installed SR1, SP2 and M$ Jet 4 SP 5!!!
(using the latest MyODBC driver and MySQL 3.22.32 over Debian
GNU/Linux)
I've read M$Access2k has problems even with M$ SQL Server, so the big
questions here are: whic
Subject: [Missing files in 3.23.34 and .33 --> .34 patch]
>Description:
Theses (innobase) files are not being included,
and thus compiles fail (all are /innobase/):
mem/mem0dbg.c
pars/pars0grm.h
>How-To-Repeat:
compile with --with-innobase
>Dear Sir or Madam,
>
>Re: Installation MySQL version 3.23.22-beta.
>
>I am awfully sorry to bother you with some basics. I am a novice.
>I am trying to use the above on my PC which is running on Windows
>98. In WinMySQLAdmin, my.ini set up appears complete. I have
>looked at the starting tu
Yes always. :p
"Charles L. Hagen" wrote:
>
> Are you always this hospitable to others?
>
> Charles
> - Original Message -
> From: "Colin Faber" <[EMAIL PROTECTED]>
> To: "Lyman Neuschaefer" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Sunday, March 11, 2001 4:46 PM
> Subject: R
Are you always this hospitable to others?
Charles
- Original Message -
From: "Colin Faber" <[EMAIL PROTECTED]>
To: "Lyman Neuschaefer" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, March 11, 2001 4:46 PM
Subject: Re: configure fails on linux-2.2.14 (Redhat 7.0), mysql-3.23.33
Hi!
MySQL 3.23.34 is now finally released. It took a little extra time to
do this as we added Berkeley DB and Innobase to the MySQL
source distribution. In MySQL 3.23.35 we will probably also add
GEMINI tables.
The reason for adding the table handlers in 3.23 and not in 4.0 is that
the table
Sir, if you look through the documentation on the PHP site, you will
find the strtoupper function, and a number of PHP mail lists where
PHP related questions can be posted. If you have any MySQL related
questions, the contributors to this MySQL mail list will be happy to
try and help you.
Bob
This has been discussed to death,
DO NOT RUN GCC 2.96 TO COMPILE MySQL IT IS FAR TO BUGGY
Please check the mailing list archives _BEFORE_ posting
Lyman Neuschaefer wrote:
>
> Greetings,
>
> The configure process fails on attempting to compile and link the executable
>
> conftest. Below i
Greetings,
The configure process fails on attempting to compile and link the executable
conftest. Below is some of the output generated by configdebug.
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2
Today, Sinisa Milivojevic ([EMAIL PROTECTED]) wrote:
> [EMAIL PROTECTED] writes:
> > >Description:
> >
> > It appears that if a column generated by a select is
> > a sum of variables generated in other columns of the
> > select (see example below!), the column will have a
> >
Thank you Sinisa,
I actually did try the upgade, but rapidly reverted due to errors
such as these:
mysqld got signal 11;
stack range sanity check, ok, backtrace follows
0x812cfea
0x809f541
0x809da87
:
:
etc
AND...
read_const: Got error 127 when reading table ./
read_next_with_key: Got erro
No, nothing concerning the replication user that is.
I do get this error alot (ie, every second):
010311 21:38:37 Aborted connection 2318 to db: 'gotforum' user: 'mysql'
host: `aphrodite' (Got an error reading communication packets)
010311 21:38:38 Aborted connection 4700 to db: 'gotforum' user
On Sun, Mar 11, 2001 at 09:02:57PM +0100, Rick Jansen - Tweakers.net wrote:
>
> Thanks for your time.
>
> I disabled replication (slave stop), removed the master.info file
> (it did contain a wrong/old password), stopped the mysqld
> (mysqladmin -p shutdown), and restarted it (safe_mysqld &). The
Thanks for your time.
I disabled replication (slave stop), removed the master.info file (it did
contain a wrong/old password), stopped the mysqld (mysqladmin -p shutdown),
and restarted it (safe_mysqld &).
The information in master.info is correct now, but still it gets an access
denied. The passw
- Original Message -
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Thomas Morton" <[EMAIL PROTECTED]>
Sent: Sunday, March 11, 2001 8:42 PM
Subject: Re: May I ask for your assistance?
> Thomas,
>
> as far as i know, i didn't notice _any_ difference in the behaviour if
mysql
> on linux or w
Dear Sir or Madam,
Re: Installation MySQL version 3.23.22-beta.
I am awfully sorry to bother you with some basics. I am a novice. I am trying to use
the above on my PC which is running on Windows 98. In WinMySQLAdmin, my.ini set up
appears complete. I have looked at the starting tutorial
How can I, from the mysql-client command line, insert a local binary fil
(i.e. an image) into a blob column in a table - using a standard insert
query?
For reference: Tablename = "pictures", Columnname(type
mediumblob)="picture",Localfile="/tmp/test.gif"
- Erling Paulsen
-
Justin wrote:
>
> What is your key buffer size?
mysql> show variables;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:47881
Current database: *** NO ONE ***
|
| key_buffer_size
On Sun, Mar 11, 2001 at 06:16:22PM +0100, Rick Jansen - Tweakers.net wrote:
> Hi there,
>
> I'm trying to set up replication. But it's not working, for some
> strange reason. This is the error out of the slave log: 010311
> 18:11:25 Slave thread: error connecting to master:Access denied for
> use
Did you check the ownership on your database? Make suer that mysql is the
owner...
On Mon, 12 Mar 2001, Nark wrote:
nark => Date: Mon, 12 Mar 2001 00:02:05 +1100
nark => From: Nark <[EMAIL PROTECTED]>
nark => To: [EMAIL PROTECTED]
nark => Subject: No table names
nark =>
nark => Hi!
nark => I h
Hi,
I need mysql (under linux) tool's -q (--quick "don't cache result, print it row by
row") in myodbc.
How can I configure the myodbc??
I have been using MyODBC 2.50.36 and I'm connecting to MySQL Server at Linux (Red Hat
7.0 2.2.16-22) under MS Win98.
Thanks.
h.
Hi there,
I'm trying to set up replication. But it's not working, for some strange
reason. This is the error out of the slave log:
010311 18:11:25 Slave thread: error connecting to master:Access denied for
user: 'repl@athena' (Using password: YES)(0), retry in 60 sec
When i try to connect "manu
hi,
just take a look at http://www.mysql.com/documentation/lists.html or send an empty
mail from your accout to mailto:[EMAIL PROTECTED]
Greetings
Andreas
> Can anyone tell me how to UNSUBSCRIBE from this list. I have sent numerous mails to
>the [EMAIL PROTECTED] but theres no action take
dear sir:
I use mysql 3.22 for a long time, it seems ok on our native language
traditional chinese, charset big5.
I use '--with-charset=big5' as the only one configure parameter, but
when I use it on 3.23.32, the client will yield this error message:
--
File 'NONEXISTENT/charsets/?.conf'
Can anyone tell me how to UNSUBSCRIBE from this list. I have sent numerous mails to
the [EMAIL PROTECTED] but theres no action take
I would appreciate if someone can exactly tell me how to unsubscribe
Thx in adv.
__
Get your own
Hi!
As it has been posted to this mailinglist, you have to upgrade your
system to 4.2 STABLE.
Then, please use a contributed 3.23.33 binary for 4.2 stable from 3.23
download page.
And what do you use MySQL for in your esteemed Institute ??
Regards,
Sinisa
__ _ _
>Description:
Database:
total: about 500Mb now
mostly used table: about 300Mb data, about 150Mb index, about 6,7 millions of records,
two indexes(primary key contains 3 fields, and other index contains 2 fields)
other tables is negligible (U see)
>How-To-Repeat:
we repeatin
Hello,
I wrote my own C code which is using MySQL C API to connect to
MySQL server. I compile with follow line:
>gcc -I/usr/local/include/mysql -L/usr/local/lib/mysql mysql_auth.c -o
mysql_auth -lm -lmysqlclient
My Free BSD 4.0 writes me:
: No such file or
Hi!
I have a strange problem with my MySQL database!!
mysql> show databases;
+--+
| Database |
+--+
| |
| |
| |
| |
| |
| |
| |
+--+
7 rows in set (0.00 sec)
Using mysql version 3.23.32 on Red Hat 7
Anyone go
[EMAIL PROTECTED] writes:
> >Description:
>
> It appears that if a column generated by a select is
> a sum of variables generated in other columns of the
> select (see example below!), the column will have a
> bogus result if the select is 'DISTINCT'. If the
> DISTINCT
Justin writes:
> What is your key buffer size? In my case, key buffer size is set
> to 384mb .. and mysqld starts out small, perhaps 18mb and grows
> within a day to 100mb, and within a few days to pretty much 300+mb
> ..so it is doing what one would expect it to.
>
> The other mem paramet
Hi,
Having a problem running safe_mysqld from my init scripts.
I use simpleinit, and i simply call /usr/local/mysqld/bin/safe_mysqld & from
my rc file.
This works for all other services, however, mysqld ends immediately. The
.err file shows:
010312 07:51:43 mysqld started
/usr/local/libexec/mysq
>Description:
I wrote my own C code which is using MySQL C API to connect to
MySQL server. I compile with follow line:
>gcc -I/usr/local/include/mysql -L/usr/local/lib/mysql mysql_auth.c -o
mysql_auth -lm -lmysqlclient
My Free BSD 4.0 writes me:
: No such f
Shen Yingshuo writes:
> Hello,
>
> I have been trying to install MySQLGUI but I have not been so
> lucky. I am running on SUN Solaris 7 Sparc... but after I downloaded
> your static binary of MySQLGUI1.6... I
>
> could not install it... any suggestion and help will be greatly
> wel
Thanks Maes,
It works like a charm.
At 12:14 PM 11-03-01 +0100, Maes Jean-Claude wrote:
>Funtion name is strtoupper()
>
>See PHP4 manual, function reference, string functions.
>
>Regards
>
>JC
>
>- Original Message -
>From: "Hoo Kok Mun" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent
I tried. It doesn't work. It sais "Table 'absences' is read-only". I
checked the files absences.* and owner is user mysql and permissions are
644.
Any ideas?
On Sat, 10 Mar 2001, Siim Einfeldt aka Itpunk wrote:
>
> Try REPAIR TABLE absences; This should do the trick:-)
>
> > Hy!
> >
> > I have
Funtion name is strtoupper()
See PHP4 manual, function reference, string functions.
Regards
JC
- Original Message -
From: "Hoo Kok Mun" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 11, 2001 11:00 AM
Subject: upper and ucase
> Hi,
>
> I am using mysql-3.22.32 with p
yesss, i got the solution from Vladislav Shulgin --> thanx very much...
he wrote:
> Try this:
> select pilote.name from pilote, flight flight, flight flight1
> where
> flight.id_pilote=pilote.id and
> flight1.id_pilote=pilote.id and
> fligth.id_flight=1 and
> fligth1.id_flight=3
---
Hi,
I am using mysql-3.22.32 with php4.
I have a little problem with the uppercase.
I wanted to display a user input field in CAPS.
This is what I did and it did not work.
$userfield = upper('$userfield');
echo "User Field - $userfield";
Errors (tried both ucase and upper)
Call to undefined fu
I recently just moved my entire site (and all databases) to a new server.
One of the queries I run every day to track inactive members has stopped
working. When I run it from the mysql server, I get the error:
Error 2013: Lost connection to MySQL Server during query
I'm thinking perhaps this is
Jeremy Huddleston wrote:
> Has anyone had similar problems or know a way around other than just not
> using BerkeleyDB?
That's not a valid problem. And it's not MySQL's fault either that no one
reads the README and/or INSTALL files that come with the product.
You need to download the p
I am compileing MySQL 3.23.33 with the following options:
--prefix=/usr/local
--with-berkeley-db=/disks/eradicator/i686/BerkeleyDB
--with-berkeley-db-includes=/disks/eradicator/i686/BerkeleyDB/include/
--with-berkeley-db-libs=/disks/eradicator/i686/BerkeleyDB/lib/
I have BerkeleyDB 3.2.9, and whe
Version: 3.23.33
I'm experiencing a problem... Whenever I use LEFT JOIN in my SELECT
statement, it no longer appears to use the index to sort, hence making the
query slow.
I have two tables: "files" (~3000 rows) and "folders" (~500 rows). In the
tables, the "id" columns are the primary keys, and
52 matches
Mail list logo
