on 3/8/01 12:13 AM, Jennifer at [EMAIL PROTECTED] wrote:
> I'm trying to do a SELECT * INTO OUTFILE and I get an error saying that it
> can't create the file and Errcode 2. I've tried searching the archives,
> but for some reason it keeps crashing my browser.
On my system (Mac OS X) errcode 2 i
I have mysql 3.23.32 source tarball and Berkely DB 3.2.3h source
tarball.
BDB : configure --enable-static --enable-cxx; make ; make install
MySQL : configure --prefix=/usr/local/mysql --with-mysqld-user=mysql
--enable-thread-safe-client ; make ; make install.
Everythin
hello;
I meet a problem when I wont to install mysql3-23-33.
after I run the command
./configure
a error report to me
the last several line are printed as followed:
"
checking whether stat file-mode macros are broken... no
checking return type of signal handlers... void
checking for t
Hi all,
When having performed a query with a LIMIT, is there any way to get
the total records that would have been retrieved without the LIMIT
being used (other than building and executing a separate COUNT (*)
query) ?
Please CC to this email address as I'm not currently
subscribed to the list.
I'm trying to do a SELECT * INTO OUTFILE and I get an error saying that it
can't create the file and Errcode 2. I've tried searching the archives,
but for some reason it keeps crashing my browser.
Jennifer
~
Looking for books, software, movies, musi
Hi,
I wrote some days ago making this same question, but I had problems
witch my mail, and I lost messages (and probably some answers) ... so if
somebody answered me, please, re-send it. Thanks.
--
Sir,
I want to know the name of mySQL Driver. I am using the mySQL in
JAVA.
I am waiting your reply.
Thank you.
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
Dear Guys,
Is there any API or modules to connect MySQL from Python??
--
Best Regards,
Winson Chang
3F, 2, 150 Lane, Sec. 5, Hsin I Rd., Taipei, Taiwan, R.O.C.
Tel: +886-2-27225333 ext 376
Fax: +886-2-27222330
Email: [EMAIL PROTECTED]
Hi friends,
I am a beginner for mysql. finally i was able to set it up. now i have
problems to set myodbc upthe error is like
"An error occured while copying C:\WINDOWS\SYSTEM\MFC30.DLL the computer
asks me to restart the computer and try install again. but it does not
work,
so i am looking f
>010307 9:29:44 read_next: Got error 127 when reading table
./perf/webstats_apollo
>
>What causes them and how can I prevent them?
Check to be sure you have enough open file descriptors. Set open-files for
safe_mysqld or hack a ulimit in there yourself.
Sincerely,
Steven Roussey
Network54.com
Hello,
I ran some interesting queries on a certain table in my mysql-3.22.32,
solaris 2.6. The queries hanged and I got this error:
Error -1 from table handler.
Now I can only connect to the DB using the 'mysql -A' option and I
cannot access that particular table. All queries on it, even simple
on 3/7/01 6:39 PM, Cindy at [EMAIL PROTECTED] wrote:
> How would I copy ONE table from a database over to another?
>
> I used this last time:
>
> mysqldump -h mysql.io.com -u DB1 -p --opt DB1 > ! backup-file.sql
> mysql -h mysql.io.com -u DB2 -p DB2 < backup-file.sql
>
> But it copies the who
I would like to upgrade mysql 3.23.22to 3.23.33, anybody know how to do it?
PIVO
Put a % at the beginning of the string "%Classical%", (which will mean that
any index is not used)
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 March 2001 4:26 p.m.
To: MySQL List
Subject: Searching for string in field
Hello,
I've got a field name
Hello,
I've got a field named genres. It's got a bunch of different music genre's
in it. I want to let a user enter a genre to search for. Here's what I'm
using now:
SELECT * FROM $mysql_artist_table WHERE genres like '$search_genre%' ORDER
BY ARTIST ASC
And that only searches at the beginni
>- Original Message -
>From: "Travis Gant" <[EMAIL PROTECTED]>
>To: "MySQL Mailing List" <[EMAIL PROTECTED]>
>Sent: Thursday, March 08, 2001 5:57
>Subject: MySQL backend for website.
>Hi, new to the list.
>I'm trying to write a MySQL backend for my website to archive/search news
stories
One more thing:
In the processlist:
| Delayed_insert | 578 | reschedule | log_day_20010307
After another minute (now over 10 minutes to reschedule) I get a _lot_ of
these:
| Query | 9| waiting for handler insert | insert delayed into
logging.log_day_20010307 ...
Which fill
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that may
help in finding out why mysqld died
Attemping backtrace. You can use the following information to find out
where mysqld died. If you
>Description:
Using the pager option in .my.cnf breaks mysqldump
>How-To-Repeat:
Enter the following line in your .my.conf file under the [client] group:
[client]
pager=/usr/bin/less
Execute the mysqldump command
See the following output from mysqld
Suggestion only: Tried myisamchk on the table?
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 0:10
Subject: ERROR 1030 at line 1: Got error 127 from table handler
> I am using version 3.32.23 and I receive these errors frequently w
Hi,
I use MySQL version 3.23.33 on Windows NT 4.0 SP6. When I use the command
ALTER TABLE ... RENAME TO ... most of the time my MySQL service stop. I
need to restart it from the service control panel. I don't have any errors
in the logs. When restarted, my rename has been done correctly. Am I
mis
- Original Message -
From: "Joseph Greenawalt" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 8:05
Subject: Ignore the previous read this one: Help! Can't get server running.
Fresh installs RedHat and Mysql RPM
> Hello all, I hope someone can help.
Hi,
Just add your table name to the mysqldump command
Quentin
-Original Message-
From: Cindy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 March 2001 2:40 p.m.
To: [EMAIL PROTECTED]
Subject: mysqldump question
How would I copy ONE table from a database over to another?
I used this la
I have a puzzle..
Frequently, about, weekly? our data server gets into a state
where
select distinct(keyfield) from table
hangs in the 'sending data' phase, or the 'sorting result' phase,
the client is left waiting for the result, no rows are returned,
no errors are in the sql server error log
Hello All. I have some questions / requests for advice that I hope some of you
could help me with.
I have alot of virtual domains that I want to provide MySQL access to. These
virtual domains are spread out across several servers right now and continue
to grow. On each of these servers I curr
How would I copy ONE table from a database over to another?
I used this last time:
mysqldump -h mysql.io.com -u DB1 -p --opt DB1 > ! backup-file.sql
mysql -h mysql.io.com -u DB2 -p DB2 < backup-file.sql
But it copies the whole shebang (all tables in DB1). The situation I
have now is that I u
I'm trying to install the latest stable mysql on Solaris 2.6.
Seems like this should be a snap, since the developers work on
Solaris, but it's not - at least not for me.
I'm using gcc 2.95.2, gmake, and I even exec bash, to make sure
that I can follow the instructions in INSTALL-SOURCE precisely
Hi,
Without a where clause in your initial query, you will never get to use an
index.
How many rows are there in sessobjs? From the start of the sample output, it
looks like there are several thousand, so asking a complex question may,
indeed, take a long time.
You could create a result table,
Hi All,
This query takes 3-4 minutes to run from the mysql> command line:
select DAYOFMONTH(started_date), object_status, count(*) from sessobjs
where MONTH(started_date)=3 group by started_date, object_status
Sample Output:
mysql> select DAYOFMONTH(started_date), object_status, count(
An update:
o I found other queries that were insert delayed into non-existent tables
and others that had wrong column names. Removing these, I thought would fix
things. Nope.
o I tried writing a log and a trace file. Too slow and unworkable. I tried
just log (worked OK -- I got a crash but not
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 dat
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 dat
Hi,
We have apache 1.3.19, PHP4.0.2 and mysql installed in
our redhat linux 6.2 system. For some reasons, we got
error message " denied for user: nobody@localhost
(Password :YES)". Database in my local machine.
Code: mysql_pconnect("$localhost","$username",
"$password") or die ("couldnt connect
Do a search for an application called One Point.
Works pretty well.
Charles
On Wed, 7 Mar 2001, MikeBlezien wrote:
> Hello All,
>
> Apologize for the slightly off topic. but was wondering if any one on list knows
> of either a freeware or commercial program for setting up and maintaining
> App
Have you ever looked at Big Brother?
Charles Hagen
On Wed, 7 Mar 2001, jason davidson wrote:
> Can anyone recomend a reliable monitoring/reporting program for mysql.
> Im looking for something small, that will at given times, query mysql
> and report the results.
> Thanks
> Jason
>
>
>
Obviously I'm wrong, but I would expect that if the server can respond via another
connection then it should be able to kill the unresponsive one? It should
have control over it's own threads.
When the rogue query is running the server is still very responsinve to other
queries, now connections
Hello john,
Thursday, March 08, 2001, 12:19:22 AM, you wrote:
jrd> with MySQL 3.23.33 on Linux, shouldn't UNIQUE columns that contain NULL
jrd> values still reject rows that are the same? this isn't working (it allows
jrd> duplicate rows to be included if one of the columns is NULL). this seem
Hi
I think that kill will only take effect when the server pays attention - if
it is busy (calculating statistics), then it may not respond immediately.
Regards
Quentin
-Original Message-
From: Steve Ruby [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 March 2001 5:19 a.m.
To: [EMAIL PROT
with MySQL 3.23.33 on Linux, shouldn't UNIQUE columns that contain NULL
values still reject rows that are the same? this isn't working (it allows
duplicate rows to be included if one of the columns is NULL). this seems wrong.
here's an example:
mysql> create table n (
i
Hi all,
Im new to MySQL. I have the following questions that I hope someone can
clarify for me:
(1) I have learned from this list and other users group list that
MySQL is very fast on performance.
How do they measure this performance? Is it the execution time on
the command?
Hi, new to the list.
I'm trying to write a MySQL backend for my website to archive/search news stories, and
other things I have on my site, http://slardy.yi.org/nu-vision/ . I know that my site
is pretty small and I could probably go with using something else but I want to learn
the basics of
Hello All,
Apologize for the slightly off topic. but was wondering if any one on list knows
of either a freeware or commercial program for setting up and maintaining
Appointments. This is for a golf club that would like to set up a MySQL database
for golfer to register and reserver tee-off times.
Hi,
I tried to install the HP-UX Binary Distribution on
my HP-UX B.10.20; according to documentation I should use the command
shell> /usr/sbin/swinstall -s /path/to/depot mysql.full
After I tar the Binary file, I still can't find the depot file.
Can someone tell where can I find it?
Thank you
Your clibs are too old.
You need to update.
john1 wrote:
>
> 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
> #i
I forget to give the tail of the error log:
010307 12:33:41 Aborted connection 90714 to db: 'logging' user: 'apache'
host: `neo.f' (Got timeout reading communication pac
kets)
010307 12:33:41 Aborted connection 90722 to db: 'logging' user: 'apache'
host: `morpheus.f' (Got timeout reading commun
Hi,
I was trying to use debugging (creating a trace and log file) in order to
find the crashing problem we have been experiencing. However, I tend to come
up against another problem in the course of things -- mysql not shutting
down.
This time I have a log file and a trace file. When I shut down
on 3/6/01 9:35 PM, Chris Toth at [EMAIL PROTECTED] wrote:
> 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,
I'm getting this erros sometimes
DBI->connect failed: Can't create a new thread (errno 11). If you are not out of
available memory, you can consult the manual for a possible OS-dependent bug at
/usr/lib/perl5/INOVA/DB/libdb.pm line 113
This beggins to happen after I set max_connections up
I do not think that this can be solved using only SQL. Your system design my
require you to use one query for the display and another
for edit checking in order to achieve your goal.
Chris Toth wrote:
> Kentj
>
> Ok, I understand. I thought DISTINCT only worked on the field listed
> directly aft
> I have tried the above with 3.23.33 and was not able to reproduce it.
I could be wrong (imagine that!). It crashed again today even with the table
in place.
In order to take one item out of the equation, I stopped the replace delayed
process I had running. It still crashed (about 8 hours later
If I INSERT DELAYED into a table with an auto_increment column and specify a
value of NULL for that column, the query fails. This is to be expected.
After this failure however, normal INSERT queries start piling up in the
'Locked' state and remain there indefinitely. The only way to get things
bac
Can anyone recomend a reliable monitoring/reporting program for mysql.
Im looking for something small, that will at given times, query mysql
and report the results.
Thanks
Jason
-
Before posting, please check:
http://www.mysq
If I may, I'd like to have a brief explanation of how to use max_rows and
avg_row_length.
Of course I have seen them in the manual, but after trying them I just
haven't found the explanations very clear.
Thank you.
-
Before po
On Wed, Mar 07, 2001 at 05:38:55PM +, Greg Cope wrote:
> Paul DuBois wrote:
> >
> > 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.
Your query selects eight fields. Your Display shows five fields. The distinct verb
works on all eight fields and
apparently some of the fields not displayed are different. Limit the query for the
display to the five fields displayed
and the distinct verb should eliminate the duplicates from the d
Kilian Looser wrote:
>
> Hi,
>
> i've the following setup:
>
> LoadBalancer -> five Webserver with Apache and mysql -> Database
>
> Now i got a problem. i've user's they insert records in the database. Now the insert
>is going throu, for example, webserver1. Now i'm doing a select throu webse
Kilian Looser wrote:
>
> Hi,
>
> i've the following setup:
>
> LoadBalancer -> five Webserver with Apache and mysql -> Database
>
> Now i got a problem. i've user's they insert records in the database. Now the insert
>is going throu, for example, webserver1. Now i'm doing a select throu webse
is it possible to use the '%' in a match .. against statement?
I keep getting resultsets with only whole-word matches, for example
the statement
select * from table_x where match(field_y) against ("%multi%");
does not give back the rows where field_y
(which is a TEXT field with a FULLTEXT ind
I also did a fresh install of RH 7.0 with the mysql RPMS from the CD-ROMs.
The files installed correctly, including the RPMs; therefore, those are NOT
the problem.
There is no separate "data directory". Those are labelled "test" and
"mysql". As you create additional databases, those directories
I rearranged the query a little: 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, request, action WHERE request.id=action.request_id
AND request.requested_by=facult
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
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 h
Paul DuBois wrote:
>
> 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
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 resul
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 c
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 /var/lib/mysql/ca
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 ve
Hi,
i've the following setup:
LoadBalancer -> five Webserver with Apache and mysql -> Database
Now i got a problem. i've user's they insert records in the database. Now the insert
is going throu, for example, webserver1. Now i'm doing a select throu webserver2 and i
didn't get the infor
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, a
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 M
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 b
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
> /usr/
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: Got
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
Steve Ruby wrote:
>
> If I have a connection that executes a bad query shouldn't I
> ALWAYS be able to kill it with "kill "?
>
> 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..
>
[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: FullText. Unfortunately,
> now with 3.23.33, any queries that explicitly refer to this column/field
> return an SQL error. So far this ha
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
> "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 upgrad
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 upgrade
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 postin
> "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
>Description:
We recently changed T-1 providers at our office location. To allow office
access to our remote mysql server
we changed the permissions in the server for our new office ips using an
update and a flush privileges.
Unfortunately we changed the user table bu
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
#include
#define def_host_name NULL
#define def_user_name NULL
#define def_p
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 libm
Dear,
Thanks for your reply, but unluckly, after the suddently stop of electic of
the server, the "Segmentation fault(core dumped)" was occur.
So all the comand like "ps", "ls" , "dir" are functionless.
Is there any other method to solve it?
Fox.
- Original Message -
From: "Gerald L.
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 | nor
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.
>
> --
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
>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
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 clien
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
Hi,
Sinisa Milivojevic:
> > >>> explain ticketid;
> > Field Type Null Key Default Extra
> > id varchar(100) PRI
> >
> > >>> show index from ticketid;
> > TableNon_unique Key_name Seq_in_index Column_name Collation
> > ticketid 0 PRIMARY
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
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
/usr/local/libexec/
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 Marc
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
Mensaje citado por: Peter Skipworth <[EMAIL PROTECTED]>:
> fulltext is now a reserved word - either change the name of the field,
> or use quotes when refering to it.
>
> [EMAIL PROTECTED] wrote:
>
> > Hi! I just upgraded from 3.22.26a to 3.23.33. We've got a
> database
> > that has a tabl
[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
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:
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 dbdi
1 - 100 of 176 matches
Mail list logo
