In the last episode (Mar 05), Praveen Kallakuri said:
hello there,
i am a novice, so bear with this rather trivial question.
how do i turn off the column-headers for select statements in mysql??
couldn't find any help with the online manual.
-N, --skip-column-names
Don't
Go back to redhat.com and get the RPM that works,
Or search the mysql list archives.
This has been answered a hundred times ( No exageration. )
Charles L Hagen wrote:
OK, here is the story.
I have a PII Linux RedHat 7.0 server. I installed the Mysql package that
comes with it and
Dear,
I use Red Head 6 with mysql, php3 and apache, past all of them are work well, but one
day the our DNS had some problem, after solve the DNS problems, we found we cannot
restart our mysql. The error message is "mysqld daemon ended".
The host.err is as below:
mysqld started on Wed
Hi all,
I'm doing another bout of MySQL server tuning as the load on my server has
nearly doubled due to recent projects, so I'm trying to squeeze some more
performance out of it.
Again, I'm looking at thread_cache_size, which I currently have set to 16.
The manual says that "by examining the
Description:
Selecting for a number in a char table is REALLY slow.
How-To-Repeat:
Large table, main index on column 'id' varchar(100).
mysql select id from ticketid where id = '15473';
Empty set (0.00 sec)
mysql select id from ticketid where id = 15473;
In the last episode (Mar 06), Christian Hammers said:
I have a table with a normal multiple key on a datetime field called
"end". I want to search for the number of records in some months. I
know that there are none.
Now "explain" tells me that a querey with a WHERE clause of
end
I try to create a new table and setup a datatype for comment column that has
about 7000 characters long. How do I define it in Oracle?
**Here's my SQL and the error I got.
SQL create table test
(comment varchar(7000));
ERROR --- Character field too long
Thanks,
David
Does anyone know any mailing lists like this one that is really good that
are just about linux systems administration etc? Thanx!
Mike Richards
Network Administrator
Harmony Integrated
www.hi.ca
Simon Windsor wrote:
Hi
On two separate but identical servers I am runing MySql, 3.22, on Debian (2.2.16)
kernel.
Using top, one mysqld server uses 10MB whilst the other uses just 3MB.
Both servers have identical configuaration files, the only difference is that server
1 is much
Hi! I just upgraded from 3.22.26a to 3.23.33. We've got a database
that has a table that has a column with the name: FullText. Unfortunately,
now with 3.23.33, any queries that explicitly refer to this column/field
return an SQL error. So far this has been tested with SELECT and
Glenn Thimmes wrote:
Hello everyone. I am in a real bind. I am trying to get a list of names
from a table where for each name there are several specific entries.
For example, the table looks like this:
ContactID
FactName
Value
for each ContactID, there may be several entries with
On Tue, Feb 27, 2001 at 01:21:52AM +, Peter Skipworth wrote:
How is this superior to SQL?
It includes the letters "XML", which, apparantly, can do everything from
butter your toast to giving you an orgasm like no other you've had
before. Don't you just *love* buzzwords!
Sorry...I
Description:
Sometimes the query below appears to hang on the table below.
The problem seems worse on queries which come from a
webserver, where persistent DB connections are used. :
The online manual page hints at the same problem elsewhere:
see Tomi
Try giving a number instead of a string as a default for an int.
Also, what do you mean by blank?
If you pass '' as a value, it will become 0 when converted to an int.
What happens if you omit the column completely on the insert?
"MikeBlezien" wrote:
Hello All,
I've created a table(using
Hi,
Is it possible to insert a file into the MySQL database? I want a table with certain
entries such as name, address etc. but I also I a photo for each member. Is that
possible?
Thanks,
Kev.
On Tue, 6 Mar 2001 11:14:36 +0100, Fred van Engen [EMAIL PROTECTED]
wrote:
Thanks Fred,
INSERT INTO referral
VALUES (NULL, 'xxx.yyy', 'xxx.yyy', '[EMAIL PROTECTED]');
But an INSERT like this:
This is where I was making the mistake! It works fine now. I was inserting an
blank empty value
My database was working fine then the server crashed and now I am getting
this error:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
I have checked and verified that the file exists:
srwxrwxrwx 1 root root0 Jan 16 23:00
Hi,
I'm working in a project to simulate the database
servers efficiency. The system consists in some modules, one of that is
a protocol analyser (to spy the net).
My problem, is that I need to work with Oracle servers,
and I don't have the Oracle SQLNet protocol, so I decided to make an ODBC
Running 3.23.33 on Windows 2000 Server.
I have noticed that executing an ALTER TABLE works... but the next query on
the alter table crashes MySQL and corrupts the table.
If I FLUSH TABLES after an ALTER TABLE, it seems to reduce the occurance,
but should this be required?
[EMAIL PROTECTED]
Well yes, i had troubles with the list as well - i did not see any message
on nor the mysql list nor the win32-mysql list... i figured i could be our
is' mail server, so i offered to join the list with another e-mail account.
I only got it confirmed after 24 hours...
So there are networking
On Tue, 6 Mar 2001, MikemickaloBlezien wrote:
Try giving a number instead of a string as a default for an int.
Not sure I follow, it is a number??
refer_id int(10) UNSIGNED DEFAULT '100' NOT NULL,
Your '100' is a string. Try something like this:
refer_id int(10) UNSIGNED NOT NULL DEFAULT
I'm attempting to do a select from my table, but the only odd thing is the
customer wants the results to be completely random every time...
is there anything like this??
$query = "SELECT * FROM members where Name like 'A%' ORDER BY random";
Matt "Trollboy" Wiseman
If I have a connection that executes a bad query shouldn't I
ALWAYS be able to kill it with "kill connect num"?
I have a query that keeps getting stuck, (who knows what
it is doing) but that State is "statistics"
I can't ever kill it without taking down the server..
If it seems interesting for somebody, I find what a problem. I mean, I can
neutralize problem.
Mysql started to works after I boot system with kernel 2.2.3 (before I used
2.2.14). I think, impotant difference between its kernels are in system
function sys_rt_sigsuspend.
Any time, in kernel 2.2.3
MySQL-client-VERSION.i386.rpm The standard MySQL client programs. You probably always
want to install this package.
What is the MySQL Client used for?
Hi all,
Im kind of strugling with a query for some time now and I need extra input:
What is the desired answer from mysql:
a date.
what is the input:
a week number
What dat do I need:
The date of the monday (week starts at sunday) in the weeknumber.
something like: select
Description:
I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
all 'show' commands doesn't works. They display empty tables.
How-To-Repeat:
Install RedHat 7.0 on Intel platform, apply all updates from RedHat
(up to March, 01 2001), compile kernel
Hello
I have uploaded a table from Access 97 to the MySQL database and apart from
changing the name from "Mailing List" to " Mailing_List" it appears fine. Now
that I am putting data into the linked MySQL table in a "live " environment I
need the MySQL table to update the Access records and
... i forgot i am not registered list user so please answer on priv
thx
I 've got problem with ODBC support for Microsoft Access
Very ofeten i can't edit records because one error. ODBC driver says "there
is another user editing same record in this time"
This isn't true - because i work alone :-(
Is anyone who can help me?
Thanks
Wojtek
You wrote:
hello there,
i am a novice, so bear with this rather trivial question.
how do i turn off the column-headers for select statements in mysql??
couldn't find any help with the online manual.
waiting.
praveen
If you're running the mysql client, try adding the command line
I haven't done what you are trying to do, but I suspect you will need at least the
MySQL-shared libraries on your system.
On Tuesday, March 6, 2001, at 06:57 AM, John Tsangaris wrote:
Tried sending this once and it didn't go through.
-
I am trying to
Hello,
I am running MYSQL 3.23.34 on NT.
I have two processes running at the same time trying
to access same database file.
Process A : repeatedly doing - open, write one
record, close.
Process B : repeatedly doing - open, read, close.
Both process stars and the process B will be aborted
by
I am having trouble getting this query to run faster:
SELECT * FROM t1 WHERE col1 = 'text' OR col2 = 'text';
Here is the output of the explain for that query
+---+--+---+--+-+--+--+-
---+
| table | type | possible_keys | key | key_len |
Ok, I've been battling this SELECT statement for the better part of the day.
The SELECT statement is this:
SELECT DISTINCT request.id AS requestid, request.date, request.type,
request.status,
faculty.f_name, faculty.l_name, action.id AS actionid, faculty.id AS
facultyid FROM faculty,
dear,
I have installed mysql for windows NT. I installed the mysql
is for support my PHP-NUKE.
In PHP NUKE, there is file "nuke.sql" may be its content of
the table of NUKE.
So, my question is
1. how to made the table in winmysqladmin and entry the list
(like field, type at table
Hi-o! I was wondering if it's possible when inserting a value into a table
that has an auto_increment field to have MySQL return the value of the
auto_increment field right after doing the insert, w/out having to run a
seperate query?
For example if I had a table with two collums, ID and name.
Hi,
I just discovered with mysql 3.22.32 that it is possible to make a table
with more than one primary key. Shouldn't that be impossible?
Thanks,
Eric
Frazier Consulting
http://www.kwinternet.com/eric
(250) 655 - 9513
fulltext is now a reserved word - either change the name of the field,
or use quotes when refering to it.
regards,
P
On Tue, 6 Mar 2001
[EMAIL PROTECTED] wrote:
Hi! I just upgraded from 3.22.26a to 3.23.33. We've got a database
that has a table that has a column with the name:
On 06-Mar-01 Kevin Connolly wrote:
Hi,
Is it possible to insert a file into the MySQL database? I want a table with
certain entries such as name, address etc. but I also I a photo for each
member. Is that possible?
Thanks,
Kev.
Yes. Ok. Yes, LOAD_FILE(). Welcome.
Regards,
--
Don Read
Hi, I'm using mysql-3.23.30 Linux binary downloaded directly from the mysql
site, and after a while the server tanks and many copies of this are all
over the error log:
Number of processes running now: 0
010306 09:19:24 mysqld restarted
/usr/local/mysql/bin/mysqld: ready for connections
mysqld
Hi,
OK, I now still have the same problem after upgrading to
3.23.33-pc-linux-gnu-i686 binary. After myisamchking all tables, this time
it took just about one minute before crashing:
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or
Hi,
Ah, today's problems are from a bug that dates back a year or more.
Streaming a large number of insert delayeds into a table that does not exist
causes the crash. The table was not created correctly last night.
Is there a web version of mysql code like PHP has http://lxr.php.net ? I'd
like
On 06.03.2001 19:05:34 iso-8859-1 wrote:
Is this expected behavior? Or is this an actual bug?
I suppose this may be expected behavior, as FullText now is a reserved word in
MySQL
-
Before posting, please check:
Description:
I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
all 'show' commands doesn't works. They display empty tables.
How-To-Repeat:
Install RedHat 7.0 on Intel platform, apply all updates from RedHat
(up to March, 01 2001), compile kernel
Ensure each table has a TIMESTAMP(14) and a PRIMARY KEY (recommend an
AUTO_INCREMENT field).
Pat...
- Original Message -
From: "Wojciech Spychaa" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 07, 2001 4:14 AM
Subject: ODBC trouble - please help
I 've got problem with
Eugene Lineitzev wrote:
Description:
I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
all 'show' commands doesn't works. They display empty tables.
How-To-Repeat:
Install RedHat 7.0 on Intel platform, apply all updates from RedHat
(up to
[EMAIL PROTECTED] writes:
Description:
Selecting for a number in a char table is REALLY slow.
How-To-Repeat:
Large table, main index on column 'id' varchar(100).
mysql select id from ticketid where id = '15473';
Empty set (0.00 sec)
mysql select id
Hello all, I hope someone can help. I have a fresh install of Red Hat
7.0, I installed mysql-3.23.22-6.i386.rpm and then
mysql-server-3.23.22-6.i386.rpm. Supposedly the daemon is automatically
starts, well it doesn't. I tried the mysql_install_db and it runs, but
I don't think it makes the
BLOBS and TEXT columns used as indices require the length to be specifically
enumerated.
(Sec 7.26 of the manual)
CREATE TABLE foo(
id INT NOT NULL AUTO_INCREMENT,
name BLOB NOT NULL,
PRIMARY KEY(id),
UNIQUE(name(500))
);
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Mike
I would recommend the book MySQL by Paul Dubois to anybody that want to do
some seriou work on MySQL . It is a really god book with everything
explained.
I am not earning money by recommending it nor have any financial ties with
them. I am just a satisfied customer of that book
From: [EMAIL
Meyer, Patrick writes:
Running 3.23.33 on Windows 2000 Server.
I have noticed that executing an ALTER TABLE works... but the next query on
the alter table crashes MySQL and corrupts the table.
If I FLUSH TABLES after an ALTER TABLE, it seems to reduce the occurance,
but should
You may have a corrupt library or mysqld. Signal 11 is a memory error
(likely overwrite). I would try deleting and reinstalling mysqld from a
fresh download.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Steven Roussey" [EMAIL PROTECTED]
To: "Mysql" [EMAIL PROTECTED]
Sent:
Hi,
Sinisa Milivojevic:
First of all, where have you got 3.23.34 when it is not out ??
It's the version in your current BitKeeper archive.
Second what type of column is id and what does PRIMARY KEY consist of.
explain ticketid;
Field Type Null Key Default Extra
id
Hi!
I have a problem with UDF.
For acceleration of spell check I needed in UDF function which be able to
replace substrings based on regular expressions.
Such PHP functions are ereg_replace and preg_replace.
Trying to write UDF for MySQL I has confronted with a strange problem.
At
Hi,
I have downloaded the latest version of MyODBC2.50.36NT and finished my setup.
Now everything works fine if I display ASCII
But if my table contains EUC-JP characters they dont get displayed properly.
My SQL Server is running on RedHat Linux7.0 with Mysql3.23.33.
I am using Access 2000
On Wednesday 07 March 2001 12:43, Richard Ellerbrock wrote:
Description:
I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
all 'show' commands doesn't works. They display empty tables.
How-To-Repeat:
Install RedHat 7.0 on Intel platform, apply all
Matthias Urlichs writes:
Hi,
Sinisa Milivojevic:
First of all, where have you got 3.23.34 when it is not out ??
It's the version in your current BitKeeper archive.
Second what type of column is id and what does PRIMARY KEY consist of.
explain ticketid;
Field Type
I seem to get integer size exceeded error windows popping up using
winmysqladmin (1.0) against mysqld-opt (3.23.22). This is all on a WIN98
Second Edition box.
Any clues?
(sorry for the vagueness, it's occurring on a machine not within my
immediate reach)
Pat...
Can anybody tell me what datatype exists in Oracle that is similar or could
be used instead of BIGINT and TIMESTAMP.
Also, what does the LIMIT # expression do in the select query. Can this be
converted to be used in Oracle somehow?
Thanks
Totalise - the Users ISP
--
To
Steven Roussey writes:
Hi,
Ah, today's problems are from a bug that dates back a year or more.
Streaming a large number of insert delayeds into a table that does not exist
causes the crash. The table was not created correctly last night.
Is there a web version of mysql code like
Hi,
I am currently working on a project in which we are using MySQL to store
data.
The database server (basic installation) is installed on Windows NT version
4. We
are currently doing some load testing on the software and have encountered
some
problems. The database server is hanging.
Our
I just d/loaded and compiled the mysql-3.23.33.tar.gz from www.mysql.com.
However, after make and make install, restarting mysql, if I type
mysqld --version I get:
mysqld Ver 3.23.22-beta for pc-linux-gnu on i686
Did they just not change the version number or is there something else I
need to
Hi,
I hope to be helpful for further investigation of the problem.
On Wed, Mar 07, 2001 at 08:20:16AM +0700, Eugene Lineitzev wrote:
Description:
I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
all 'show' commands doesn't works. They display empty tables.
In
Yes, I've tries that here is the error I get.
Your MySQL connection id is 247 to server version: 3.23.33
mysql CREATE TABLE foo(
- id INT NOT NULL AUTO_INCREMENT,
- name BLOB NOT NULL,
- PRIMARY KEY(id),
- UNIQUE(name(500))
- );
ERROR 1089: Incorrect sub part key. The
After doing an INSERT, you may do
SELECT last_insert_id();
and it will return the last id the last INSERT command used. it doesn't matter if your
MySQL server is very busy doing inserts, if
you call 'SELECT last_insert_id()' right after the INSERT, you will get the correct
value.
I don't know what you are trying to accomplish but here is the way I would
build a table using ALL the data field from two tables. first is a
straight join which will only build the records that have an equal in both
tables.
insert into tbla select distinct tblb.*, tblc.* from tblb, tblc where
Curtis Maurand wrote:
Hello,
I'm now lost. I cannot figure out what the make file is looking for. Anyone have
any ideas?
LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux/2.9
6" cc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o
foxwoo wrote:
Dear,
I use Red Head 6 with mysql, php3 and apache, past all of them are work well, but
one day the our DNS had some problem, after solve the DNS problems, we found we
cannot restart our mysql. The error message is "mysqld daemon ended".
The host.err is as below:
[EMAIL PROTECTED] wrote:
Description:
Sometimes the query below appears to hang on the table below.
The problem seems worse on queries which come from a
webserver, where persistent DB connections are used. :
The online manual page hints at the same problem
Joseph Greenawalt wrote:
Hello all, I hope someone can help. I have a fresh install of Red Hat
7.0, I installed mysql-3.23.22-6.i386.rpm and then
mysql-server-3.23.22-6.i386.rpm. Supposedly the daemon is automatically
starts, well it doesn't. I tried the mysql_install_db and it runs,
its looking for the z compression library.
To fix do this
1) perl Makefile.PL
2) cd mysql
3) vi Makefile
4) search for line LDLOADLIBS and add -lz to end
5) cd ..
6) make
7) make test
8) make install
Robin
-Original Message-
From: Curtis Maurand [mailto:[EMAIL PROTECTED]]
Sent: 06
Whenever my MySQL server (3.23.33) is under heavy load it restarts itself.
Stopping whatever was connected to it at the time.
In my .err log I've just got;
010307 00:12:32 mysqld started
/usr/local/libexec/mysqld: ready for connections
Killed
010307 00:16:56 mysqld restarted
Are there any plans for authentification of users in mysql
against an LDAP directory insteed of the mysql user table?
Or is there a patch known?
--
Helmut Wirth
[EMAIL PROTECTED]
-
bison GmbH phone +49 89 / 50
At 16:56 06/03/2001 -0500, [EMAIL PROTECTED] wrote:
Hi,
If you are using Access as front end, when you build the update
or append query you can use an expression like:
My Name: [TableName]![ColumnName]
You can do this manually or using the builder query of Access.
Regards,
Miguel
Hello
I have
I recently upgraded our database from 3.22.32 to 3.23.32
We run a ISAM check every night, to check for db problems. Ever since I did
the change, I get a email from the cron daemon like this:
/usr/bin/myisamchk: MyISAM file /var/lib/mysql/cayn21/customers.MYI
/usr/bin/myisamchk: warning: 1
Hi all,
Im kind of strugling with a query for some time now and I need extra input:
What is the desired answer from mysql:
a date.
what is the input:
a week number
What dat do I need:
The date of the monday (week starts at sunday) in the weeknumber.
something like: select
Sounds like it installed to a different directory than the previous
version - try
/usr/local/bin/mysqld --version
or
/usr/local/mysql/bin/mysqld --version
It would be a good idea to remove any previous binaries to avoid
confusion, as well.
Cheers,
P
On Wed, 7 Mar 2001, Cal Evans wrote:
I
Matthias Urlichs writes:
Hi,
select * from ticketid where id like "123%"
correctly uses the above index, but a more restrictive query, i.e.
select * from ticketid where id like "123%" and id = 123
doesn't. This is _not_ the expected result.
--
Matthias
Hi,
Sinisa Milivojevic:
And what happens if you put quotes ??? ... id = '123'...
Then it works, of course. But the nice thing about the numeric select is
that it also accepts values like 123x45 or 123-45-67 (but not 1234),
which is why I wanted to use it.
--
Matthias Urlichs |
Hi,
I have some problem running the ./configure
command for version mysql-3.23.33 see below:
checking size of char... 0
configure: error: No size for char type.
A likely cause for this could be that there isn't any
static libraries installed. You can verify this by checking if
you have
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API program which catched from the MySQL tutorial, it
chokes at the end of compile process . the program is as follows:
#include stdio.h
#include mysql.h
#define def_host_name NULL
#define def_user_name
"MV" == Michael Villalba [EMAIL PROTECTED] writes:
MV Thanks, Fred. The delete job has been running for 21 hours
MV at this point, and now rather simple queries on other tables hang
MV (e.g. SELECT COUNT(*) FROM other_table WHERE index=some_value).
MV I'll let it run overnight to see what
Dear Sirs:
Please can you tell me where I can get the Perl DBI interface
for Windows ???
Ernesto
-
Este mensaje fue enviado a través de Qnet
http://www.qnet.com.pe
-
Before
I've been reading the thread about SHOW DATABASES and SHOW TABLES
returning lists of blank entries or no results. Just out of curiosity,
I upgraded my RedHat 6.2 machine from MySQL 3.23.32 to MySQL 3.23.33
and found that suddenly I had the problem too! However, then I remembered
that I'd
"DN" == Dan Nelson [EMAIL PROTECTED] writes:
DN This looks like you used the binary package, right? That was built for
DN FreeBSD 4.2, which has a different set of c++ libraries from 4.0.
DN You'll have to either upgrade to 4.2, or build mysql from ports.
I'd highly recommend upgrading to
Canadian Lumberer wrote:
Hi,
I hope to be helpful for further investigation of the problem.
On Wed, Mar 07, 2001 at 08:20:16AM +0700, Eugene Lineitzev wrote:
Description:
I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
all 'show' commands doesn't
Steve Ruby wrote:
If I have a connection that executes a bad query shouldn't I
ALWAYS be able to kill it with "kill connect num"?
I have a query that keeps getting stuck, (who knows what
it is doing) but that State is "statistics"
I can't ever kill it without taking down the server..
Hi,
When I read the documents for MM.MySQL driver, I noticed that it is
mentioned that MM.MySQL driver can be used to make connections to APPLETS.
However, I could not find any further information and examples for this
issue. Could you please send me some examples on how to use MM.MySQL driver
to
I am using version 3.32.23 and I receive these errors frequently when using
the mysql client using select statements.
These messages are showing in the mysqld error log as a result:
010307 0:46:03 read_next: Got error 127 when reading table ./perf/webstats_apollo
010307 9:17:12 read_next:
Don Bowyer wrote:
I recently upgraded our database from 3.22.32 to 3.23.32
We run a ISAM check every night, to check for db problems. Ever since I did
the change, I get a email from the cron daemon like this:
/usr/bin/myisamchk: MyISAM file /var/lib/mysql/cayn21/customers.MYI
It looks like the addition of the distinct verb should do the job if in fact your
query only showed the fields on the display.
From your Sql however you are selecting more fields than are displayed and some
of those are different which distinct
will still display.
Chris Toth wrote:
Ok, I've
I am considering developing an application that relies on MySQL as for
database functionality. The application would include MySQL client API
calls and be linked with MySQL libraries. It would be distributed with the
MySQL database.
According to the license terms in MySQL 3.23.30 Reference
On Tue, 6 Mar 2001, Kevin Connolly wrote:
Date: Tue, 6 Mar 2001 18:15:17 - From: Kevin Connolly
[EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: file insertion?
Hi, Is it possible to insert a file into the MySQL database? I want a table
= with certain entries such as name, address
Phillip Bruce wrote:
Hi,
I have some problem running the ./configure
command for version mysql-3.23.33 see below:
checking size of char... 0
configure: error: No size for char type.
A likely cause for this could be that there isn't any
static libraries installed. You can verify
In the last episode (Mar 07), Don Bowyer said:
I recently upgraded our database from 3.22.32 to 3.23.32 We run a
ISAM check every night, to check for db problems. Ever since I did
the change, I get a email from the cron daemon like this:
/usr/bin/myisamchk: MyISAM file
If you are using a current "activestate" release it should be included,
if not use their package manager.
On Wed, 7 Mar 2001 [EMAIL PROTECTED] wrote:
Date: Wed, 7 Mar 2001 15:59:36 GMT
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: DBI for Windows
Dear Sirs:
Please can you
SELECT * FROM members where name like 'A%' ORDER BY RAND();
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]
On Tue, 6 Mar 2001, Matt "TrollBoy" Wiseman wrote:
I'm attempting to do a select from my table, but the only odd thing is the
customer wants the
Hello,
After having gotten sympa to run (with a few warnings), tried
running wwsympa.fcgi for configuration
purposes. Unfortunately, kept getting a internal server error. While
trying to see what was wrong,
I typed "perl wwsympa.fcgi". I received these error/warnings before it
outputed the
The reason we run the check scripts is because in the past we had all sorts
of trouble not with the daemon crashing, but with clients (who have no
technical skills) using Access ODBC to update tables, and somehow
corrupting them. This way we catch the problems before the client does.
Thanks
1 - 100 of 152 matches
Mail list logo