Dear all,
Now I'm using binary distribution of MySQL 3.23.30-gamma for
FreeBSD 4.2. The size of mysqld is 1339436 bytes. It can work
well without any crash.
But I need to use charset tis620 so I use 2 parameters when I
call mysqld.
--character-sets-dir=/usr/local/share/mysql/charsets
--default-
Hi,
I have a couple hundred text files in a directory that I want to import into
a mysql table. I have successfully imported a file, data looks ok. Is there
a way to automate the import of all files in a specified directory instead
of doing it one by one?
Kindly cc me on the reply when you send
On Thu, Mar 22, 2001 at 12:47:06PM +1100, Wayne Parrott wrote:
> Is their any way to have multiple masters for one slave? The
> purpose of this is to backup multiple databases to one server
> easily, if their is no way to do this with replication are their any
> other methods of remote backup?
Hi
When i create a ODBC-DSN, there are fields where i can fill in a user name
and password. When i filled these in, excel (and Delphi) don't ask for
usernames/passwords.
Regards
Gert
> -Original Message-
> From: Frank Hacker [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 22, 2001 8:
Hi!
How do I keep the MyODBC driver window (labeled "TDX mysql Driver connect")
from being displayed when I connect to MySQL via ODBC?
This behaviour makes it impossible to automate the task of updating a MySQL
Database from an Access 97 Database via ODBC using a Macro in Access, since
the wi
i've been trying to get this to compile for a while ... i have looked in
the list archives and used google ... bleah.
i hate MIPS now :) ... i've had trouble on the cobalt and now this SGI
box.
here's my configure line (i looked in the docs and changed -O3 to -O2,
'cause -O3 doesn't work on t
I just dl'ed the file from mysql.com and checked it with a current version of Symantec
AntiVirus with the latest virus definitions. Result: No viruses.
Mark Chalkley
-
Before posting, please check:
http://www.mysql.com/ma
Hi,
None of the files located at www.mysql.com nor official mirrors contain
viruses.
The problem you're experiencing might be due to one the following:
a) There is a bug in the "Trojan Remover" software you're using.
b) You downloaded the latest MySQL-Win32 version from some non-official
mirror
Tried sending this before, did not seem to work; if this already arrived,
my apologies for the re-send!
I downloaded version 3.23.35 from the MySQL web-site with the intention of
trying out transactions. After installation of binary RPMs from the
standard download section, these do not seem
Hi!!
I want to have a sql script to create the tables. i.e. have all the lines that I will
type at the sql prompt in a script file called create_tables or something and execute
that file to create the tables !!
How to do ?Is there an editor for mysql where I can type out these lines.
Please hel
Where did you download your MySQL executable from?. Did you download
it from MySQL official site or other Mirrors? If you download it from
the mirror (or worst from the Official site) and got the Virus then
you should let the MySQL Admin know as this is a pretty serious
problem.
> I've had MySQL
Additional Info:
010322 5:15:35 Verbindungsabbruch 13 zu db: 'sleid' user: 'sleid' host:
`archimedes.lippe-net.de' (Fehler beim Lesen eines Commu
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 b
Hello,
I've got a problem. If I remove multiple udf-Funktions of one udf-Library i
get a
'lost connection' error.
I'm using a sql-script deleting for example 4 functions and then recreate
them (because
of an update of the .so)
Any ideas??
TIA
Stephan Skusa
--
I downloaded version 3.23.35 from the MySQL web-site with the intention of
trying out transactions. After installation of binary RPMs from the
standard download section, these do not seem to recognise the --dbd-home
option, or allow me to create a BDB type table.
Should I be looking in anothe
Did you shutdown the mysql server before running skip grants?
- Original Message -
From: "anna" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 10:55
Subject: bug? no work on new version MySQL-3.23.33
> Dear Sir,
>
>problem:
> run command mysqld --ski
I wouldn't know myself, but geez, I'm glad I'm not using Windoze.
0 | 0
\___/
Cheers
Rolf
Your mouse has moved.
Windows NT must be restarted for the change to take effect.
Reboot now? [OK]
- Original Message -
From: "Brian Gan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Th
Hi,
Can someone advise on the best [fastest] way to search about
12 'text' fields from 2 tables for a keyword? It's fast from 1
table, but slows _way_ down when I add fields from the second table.
Should I:
1) Index all fields involved?
2) Get involved with mu
Dear Sir,
problem:
run command mysqld --skip-grant-tables no work, and got error messages
# /usr/sbin/mysqld --skip-grant-tables
Fatal error: Please read "Security" section of the manual to find out how to run
mysqld as root!
010322 13:44:51 Aborting
the server is fresh ins
I've had MySQL server 3.23.25 installed at first on my Windows2000 machine.
Then Trojan Remover 4.17 some how suspected a "Sky Dance 3.03" trojan horse
virus in \mysql\bin\mysqlshow.exe.
Then I download and installed the newer version 3.23.35a today. There are 2
more executables that are suspect
On 22-Mar-01 Mike Roberts wrote:
> Probably easy, but everything is easy once you know how to do it.
>
> In my database with PHP and MySQL, I have a description field with
> varchar set to 255. But what I want to do is have the database spit
> that out onto a webpage but only showing, say 100 ch
Hai,
I am using Red Hat Linux 7. From where can I get example programmes of
connectiong to MYSQL using PERL under Linux.
Thankyou
Rajeev Ramanujan
There are string functions in both PHP and MySQL that will do exactly what
you are wanting. Please read either manual for these. PHP- look up the
string functions. MySQL- read Ch. 7, the section that talks about functions
that can be used in SELECT statements.
- Original Message -
Fro
I'm sure he means for you to go back to the archives and beat the horse on
your own.
flat files are only useful for 1-on-1 relationships. A simple example. You
have a student record and each student takes several subjects in which you
keep results and other info for. You can do a flat file for
Hi,
Is their any way to have multiple masters for one slave?
The purpose of this is to backup multiple databases to one server
easily, if their is no way to do this with replication are their any
other methods of remote backup?
Thanks
Wayne
--
Databases are essentially just directories. What you do is create a
directory in the users home directory. Then, do this:
ln -s /path/to/home/dbdir /path/to/mysql/data/dir/somedbname
Then grant the user access to that db. Your all set :)
- Original Message -
From: "Andre Guerrero" <[E
I have been trying to think of naturally occuring unique identifiers that
people might use on the internet.
I think that e-mail addresses would be a unique way to indentify an
individual.
Only one e-mail can exist per person. Although an email address could change
owners for the most part, each e-
Can anyone offer some insight into the following topic?
I would like to provide web access to search a large database of
information. Currently, I am using MySQL to do this, and it works great.
However, this database is almost entirely static, there are virtually no
inserts or updates done.
You need to read the mailing list archives, This has been discussed to
death. Please try to follow the directions outlined when posting.
See the 'http://lists.mysql.com/ (the list archive)' ?
Bryan Coon wrote:
>
> Can anyone offer some insight into the following topic?
>
> I would
I am having trouble too! The AutoResponder/SubScriber seems to be not working Did
you hear anything positive on how to unsubscribe???
120 emails per day while Traveling on Business is Tooo Much
At 03:12 PM 3/21/01 -, anna soobrattee wrote:
>please tell how to get an auth code -
Since you feel that you should never have more than 15 simultaneous
connections at a given time, I don't think modifying max_connections
will help. I would first verify that the PHP code is closing the
connection. If it isn't, then the connection will stay open until it
times out. If you do, ho
MySQL has no support for XML and I hope it doesn't, ever. There was a big
discussion about this last month. You can read up about it in the archives
found at the mysql site.
- Original Message -
From: "Bryan Coon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 200
Runs like a charm here. Just need myodbc from the mysql website.
- Original Message -
From: "licita" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 18:53
Subject: Accessing MySQL remote DB from VB5
Can anybody tell me if my VB5 programs can query an MySQL D
Strictly speaking, they're not unique - there's a lot of many to one
mappings- eg my work email address and my home email address - and a
hell of a lot of one to many mappings - ie [EMAIL PROTECTED] As long
as you're happy with that, most people end up being happy assuming that
a user's email add
Bryan,
You've given no indication of what "this structure" is - the fact that
your data is rarely read or updated will have little bearing on whether
an RDBMS is suitable for your needs. It would be a very rare case,
however, where a simple flat text file gave you quicker access to a search
of a
The "dead horse" I'm referring to is XML, it's come up quite a few times :)
The major advantage to flat files is that you don't have the MySQL overhead.
However, you have to remember a few things. You will have to implement a
key structure similiar to MySQL's to get the performance your getting
On 21-Mar-01 roger westin wrote:
> Hi I solved it my self.
> If anyone whats to know the awnser to this it was NOT as easy as the manual
> would have described.
> The only thing I got to work was:
> 1. Drop the index
> 2. create new field (whitout index and auto_inc) if any of them where added
>
Probably easy, but everything is easy once you know how to do it.
In my database with PHP and MySQL, I have a description field with
varchar set to 255. But what I want to do is have the database spit
that out onto a webpage but only showing, say 100 characters.
---
Hmm, seems strange. Are you sure you set the charset properly?
- Original Message -
From: "Apisilp Trunganont" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 23:15
Subject: Problem in SELECT for Thai language.
> Dear,
>
> I use MySQL 3.23.30-gamma for unknow
What are the advantages of flat files? I am having no speed issues at
all... in fact Im quite happy to stay with MySQL. But my boss is loaded
with ideas you see, so I have to be able to justify why mysql is better than
flat files.
Thanks for the response, feel free to kick the dead horse one m
Original Message -
From: "Bryan Wheelock" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 5:31 PM
Subject: Is email unique?
> I have been trying to think of naturally occuring unique identifiers that
> people might use on the internet.
> I think that e-mail a
Well list, I think we have a new weekly dead horse to with which to use our
sticks on :)
To answer your question, no, XML is not being added currently to MySQL.
Flat files have some advantages, but have to be implented well to work well,
you can't just open the whole thing and scan through it loo
And won't Adding the column, using AUTO_INCREMENT, as described in 7.8 of
the manual help? Never tried it myself.
- Original Message -
From: "roger westin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 3:49
Subject: Hilfe!!! Help!!! ADDing AUTO_INC col into t
On 21-Mar-01 Jared Rogge wrote:
> Does anybody know how to
> reset or disable this feature if you have root access to the machine?
>
localhost.dread$ grep skip-grant $MANUAL
`--skip-grant-tables' option and add the privilege information
s
Hi, i have a table with a field
varchar(15).
I use the Mysql CAPI to get the value this field.
The problem is:
What's the function's type to return this
value?
What's the variable's type that will receive the
data?
In attach is a file with a piece of my
code.
Tanks for attention and pl
I'm working on a web-hosting site where we'll be giving users a MySQL
database. We wanted to store the database in the user's own directory,
where we'll be enforcing size quotas. So far though, I haven't been able to
find a way to create a database in a directory other than MySQL/data. I've
see
On 21-Mar-01 roger westin wrote:
> Hi there,
> Question:
> Whats the Easiest way to insert an AUTO_INCREMENT column into an existing
> table,
> the new field will take over the primary key and the index.
>
>
alter table da_table drop primary key, drop old_id;
alter table da_table add id int
Most people have more than one email address, if that's what you're getting at.
Some email addresses are also used by more than one person.
--jfarr
- Original Message -
From: "Bryan Wheelock" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 12:55 PM
Subject: un
Some people use the method you are describing without using a
database. This is especially useful when working with tables. As most
know, using tables is great, however, you end up duplicating a lot of code
for the menus. This makes updating the menu someone difficult. Rather
than go through
Restart mysqld with the --skip-grant-tables option, this will allow you to
bypass mysql's authentication. You can log in as root and then change the
password to something else.
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]
On Wed, 21 Mar 2001, Jared Rogge wrote:
Hi there!
I'm experiencing quite a strange behaviour when retrieving dates from a
mysql table.
I'm doing the following in Java:
StringBuffer sql = new StringBuffer( "SELECT datum FROM runde WHERE
runde_id = 146" );
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(
Have you checked the permissions on mysql.sock? This happened to me once.
Since your webserver is running as 'nobody' you need to make sure the
permissions are correct for the socket and directories...
Just a thought.
Bryan
-Original Message-
From: denis mettler [mailto:[EMAIL PROTECT
Can anybody tell me if my VB5 programs can query an MySQL DataBase on a Remote server?
If so, what should I distribute with my software?
Thanks
Francisco
Hi list!
I try to change my data dir from the default /var/lib/mysql to /usr/mysql .
On a standard Suse install I did the following:
- copying all databases cp -R * /usr/mysql
- changing the datadir in /etc/my.cnf to /usr/mysql
- mysql restart
- works fine
On my ded. server I have RedHat 7 run
I'm not 100% familiar with the load data line, I've never had to do it (I
just write import proggies :)
I'd suggest a small little script like this (copy and paste this into a text
file on the server, give it execute permissions, and run it), please excuse
any wrapping:
#!/bin/sh
for file in *.
On Wed, Mar 21, 2001 at 01:49:07PM -0600, roger westin wrote:
>
> Hi there,
> Need to insert an AUTO_INC column into a table.
> And yes it will be the PRIMARY KEY
> Anyone done this?
>
> /roger
>
Sure. Use ALTER TABLE. Have you tried it and run into a problem?
If so, please provide mo
the email list seems to be very slow now and them... wouldn't it be an
option to make a web-based list ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
hi.
log in as root, kill the mysqld process.
restart mysqld with the --skip-grant option.
once it is running you can connect and alter the password directly in the
'mysql' table.
maybe a flush privileges to reload the permissions after that?
you really just forgot the password you typed, didn't
Any ETA on corrected RPM's?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubsc
>password to MySQL and I cannot into it of course. Does anybody know how to
>reset or disable this feature if you have root access to the machine?
Read the manual you can find at http://www.mysql.com
This is explained into great detail.
Bye,
B.
-
Joe McPherson wrote:
> Hi,
>
> I installed the rpms that come w/ redhat 7.0. I am getting the following error in
>the log file, when I run safe_mysqld.
>
> can't find host.frm
>
> This file does exist in the /var/lib/mysql/mysql directory.
>
> I think that may be the wrong dir, but I installed
In the last episode (Mar 21), Alessandro de Manzano said:
> a question I did not see on FAQs :
>
> does MyODBC 2.50.xx works on Windows 2000 ?
>
> I was told that works fine on Win9x and NT4 but not on W2K, what's the
> true ?
It works just fine.
--
Dan Nelson
[EMAIL PROTECTED
em php
tenho um array tipo:
10,15,20
como faço p/ pegar separadamente
10
15
20
sendo q esse numero pode variar
tenho uma rotina em delphi q faz isso, porem estou com dificuldades p/
passar para php por causa da minha inexperiencia nesta linguagem
em delphi é assim:
x := 1;
i := 1;
repeat
I have been trying to think of naturally occuring unique identifiers that
people might use on the internet.
I think that e-mail addresses would be a unique way to indentify an
individual.
Only one e-mail can exist per person. Although an email address could change
owners for the most part, each e-
Readers of the mailing list,
when I was writing about recovery in the upcoming Innobase manual,
I realized that a logical log used in MySQL in the roll-forward recovery
from a backup does not work properly. The problem is that
the log does not contain enough information on the snapshot a consiste
At 02:59 PM 3/21/2001 +, soon chee keong wrote:
>Table_1
>
>-
> A B C
>-
> 1018 9
> 4 3 1
>--
>
>how can i change column C's "9" to say "20" without inserting a new record
>and columns A and B
Hi I solved it my self.
If anyone whats to know the awnser to this it was NOT as easy as the manual
would have described.
The only thing I got to work was:
1. Drop the index
2. create new field (whitout index and auto_inc) if any of them where added
I got an error and nothing worked.
3. make the n
Hi there,
I recently upgraded my Linux kernel to 2.4.2 and my perl DBI/DBD
and now MySQL is behaving strangely. If I'm logged into my system as root
I can see that the mysql server is up and running and I can access it just
fine using either the root database login or a user login. Howe
Have the same problem, nither the server or any client seems to read the
my.cfg files,
they are just going on the precompiled default value.
Have tried to recomplie and alot off stuff but I always have to add
the --socket /tmp/mysql.sock
I got this problem after I installed the rpm clients and ad
Is there any work going on with DBD::mysql for Perl to support
transactions at the DBI abstraction? If you attempt to use DBI
autocommit=>0, DBD::mysql croaks.
It would seem that with BDB and the other new table types that support
transactions, it will become necessary...
--
=-=-=-=-=-=-=-=-=-
Make them a char(32). They will also be 32 chars long, have the DB expect
that.
At 10:48 AM 3/21/2001 -0600, roger westin wrote:
>Whats the best way, any realy good space saving way to store a MD5 value?
>
>/roger
-
Scott Bak
On my website, http://www.cdn.f2s.com
The links under the 'Network' menu (Home, Affiliates, Contact, & Get Hosted)
are trying to call from MySQL to receive a link specified in the column
which it is calling from.
I have no idea what I am doing though. I have seen other websites with links
like
Putting on my Captain Obvious hat. Are you sure that you only have 1 php.ini
and that PHP is picking up the right one? PHP thinks your mysql.sock is in
/var/lib/mysql.
Also, make sure that it's /tmp/mysql.sock and not /tmp/mysqld.sock. I seem
to remember mine being mysqld.sock.
Cal
http://www.
Charles Mégnin wrote:
>
> Although the my.cnf file specifies
> socket = /tmp/mysql.sock
> the server expects mysql.sock to reside in
> /var/lib/mysql
>
> [mysql@localhost]$ /usr/bin/mysqladmin -u root -p password
> Enter password:
> /usr/bin/mysqladmin: connect to server at 'localhost'
Well, since PHP is trying to use a socket in the wrong directory,
you might check the PHP list to see if they can help you.
This is not, strictly speaking a MySQL problem, so waiting here for the
correct answer may not be the quickest route to the answer.
I have seen several answers indicating th
Hi there,
Need to insert an AUTO_INC column into a table.
And yes it will be the PRIMARY KEY
Anyone done this?
/roger
That depends.
Just the one 9, or all instances of 9 in 'C'?
This is a basic SQL question, not a MySQL question.
I would suggest finding a book on SQL.
You could try:
update Table_1 set c=20 where a=10 and b=18 and c=9;
This will guarantee that only the first line ( O one just like it ) will
be
I am trying to load data from several lists. This is what I was trying:
LOAD DATA INFILE '*.*' INTO TABLE table2 FIELDS TERMINATED BY '\t';
For a single file I would have used:
LOAD DATA INFILE 'data.txt' INTO TABLE table2 FIELDS TERMINATED BY '\t';
Any ideas? I have several files that all cha
UPDATE Table_1 SET C = 20 WHERE A = 10 AND B = 18
you might want to read a basic SQL book before asking this type of
question
HTH,
christopher oson
-Original Message-
From: soon chee keong [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 6:59 AM
To: [EMAIL PROTECTED]
Subj
Sinisa,
This time I compiled with :
CFLAGS=-DSOLARIS CXXFLAGS="-DSOLARIS -felide-constructors -fno-exceptions -fno-rtti"
./configure
--prefix=/usr/local/mysql --without-bench --enable-thread-safe-client --with-innobase
--without-debug
--with-named-thread-libs=-lthread --without-berkeley-db
On Wed, 21 Mar 2001 14:59:38 -, "soon chee keong" <[EMAIL PROTECTED]>
wrote:
A very basic UPDATE will do the trick.
UPDATE Table_1 SET
C = '20'
WHERE C = '9'
>>Table_1
>>
>>-
>> A B C
>>-
>> 1018 9
>> 4 3 1
>>-
update table_1 set C="20" where C="9";
Cal
http://www.calevans.com
-Original Message-
From: soon chee keong [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 8:59 AM
To: [EMAIL PROTECTED]
Subject: replace qeustion
Table_1
-
A B C
I would like to know if anyone has worked with implementing a MySQL
database backend with BIND 9. I'm interested in table design,
implementation, how/if dynamic dns is stored there, etc.
Thanks.
-
Before posting, please che
What is the error message?
Ensure /var, /var/lib, /var/lib/mysql have these permissions: drwxr-xr-x
-Original Message-
From: webmaster [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 2:56 PM
To: [EMAIL PROTECTED]
Subject: mysql error
I have suse linux 7.1, I installed mysql an
I don't see implementation of "CHECK" CONSTRAINTS in the TODO list (e.g.
CONSTRAINT val_ck check (val >= 0 and val <=5)
Is this planned?
I do see FOREIGN KEY constraints on the 4.0 list, so there is a way to do
this kind of checking once this is implemented:
* Create an associated "range-c
I have recently tried to install a new Trouble Ticket application on a Unix
machine that was previously administered by somebody else. They have set a
password to MySQL and I cannot into it of course. Does anybody know how to
reset or disable this feature if you have root access to the machine?
T
Bonjour,
SM> Ok, start from the fresh tarball. Beside everything, add (in configure
SM> options):
SM> --with-mit-threads=no
==
My last try (for today) :
CFLAGS=-DSOLARIS \
CXXFLAGS="-DSOLARIS -felide-constructors -fno-e
I am trying to figure out how to do this so I can do
incremental backups. Any ideas would be appreciated.
Thanks,
Shane
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
Hi again Sanisa, I just wanted to tell you that I had the same error
message regarding libsqlplus.so.1 when I tried to run mysqlgui and I fixed
it using the same command line you told me but of course replacing
libsqlplus.so.1 for libsqlplus.so
Thanks again,
Alonso Guarisma
On Wed, 21 Mar 2001, S
>Description:
mysql_convert_table_format ignores password setting for client in my.cnf.
>How-To-Repeat:
create ~/.my.cnf with this:
[client]
password=SomeThing
with that as your account's password.
run 'mysql_convert_table_format test'
this error comes back:
Can't connect to database vkmlm:
Peter,
try
SELECT * FROM table WHERE title IS NULL LIMIT 1;
HTH,
Christopher Oson
-Original Message-
From: Peter Szekszardi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 5:36 AM
To: [EMAIL PROTECTED]
Subject: selecting null values
Hi,
I have a database which has a text
Thanks a lot Sanisa, I got it run at last!!
Regards,
Alonso Guarisma
On Wed, 21 Mar 2001, Sinisa Milivojevic wrote:
> alonso guarisma writes:
> >
> > Dear Sanisa, do you mean that I have to create a symbolink link called
> > "sqlplus" and point it to /usr/lib ?
> > like: ln -s /usr/lib sqlp
Hello!
a question I did not see on FAQs :
does MyODBC 2.50.xx works on Windows 2000 ?
I was told that works fine on Win9x and NT4 but not on W2K, what's the
true ?
thanks a lot!
Alessandro de Manzano
Playstos - TIMA S.p.A.
Corso Sempione 63
20149 Milano, Italy
tel.: +39-023314153
fax: +3
alonso guarisma writes:
>
> Dear Sanisa, do you mean that I have to create a symbolink link called
> "sqlplus" and point it to /usr/lib ?
> like: ln -s /usr/lib sqlplus
> Thanks, wait for your answer.
> Alonso
>
No,
ln -s /usr/local/mysql./libsqlplus.so /usr/lib/libsqlplus.so
Reg
Dieter Becker writes:
> >Description:
> Update does not work correctly
> >How-To-Repeat:
> Don't know
> >Fix:
>
> Please look to the followin output:
>
> mysql> select * from hkt_op_anmeld where hktnr = 63833;
>
>++---++--+--+--+
Hi,
I installed the rpms that come w/ redhat 7.0. I am getting the following error in the
log file, when I run safe_mysqld.
can't find host.frm
This file does exist in the /var/lib/mysql/mysql directory.
I think that may be the wrong dir, but I installed the rpms and ran mysql_install_db
a
Hi!
There were two bugs reported in 3.23.35.
First one deals with info not being displayed after table has been
changed with UPDATE, LOAD DATA or similar. Here is patch for that bug:
= sql_parse.cc 1.118 vs edited =
*** /tmp/sql_parse.cc-1.118-23407 Wed Mar 21 00:58:38 2001
---
No .. not really that big (the table)
-rw-rw 1 mysqlmysql 100916 Mar 16 17:09 imp_addr.ISD
-rw-rw 1 mysqlmysql1024 Mar 16 17:09 imp_addr.ISM
-rw-rw 1 mysqlmysql8648 Mar 9 11:06 imp_addr.frm
100K the ISD part ... anyway i have
I have been on occasion recieving "Too Many Connections" errors which
lock up mysql.. I know i can set the connections in my.cnf.. atleast
thats what i've seen on this listover the past few months..
For starters.. i dont seem to have a my.cnf according to mysqladmin
Default options are read from
On Wed, Mar 21, 2001 at 02:36:02PM +0100, Peter Szekszardi wrote:
> Hi,
>
> I have a database which has a text field (let's name it title). The field
> is NULL initially. Now I have about a hundred thousand records in the db,
> where the title field is NULL. I have to fill these NULL title fields
Hi.
On Wed, 21 Mar 2001 14:36:02 +0100 (CET)
Peter Szekszardi <[EMAIL PROTECTED]> wrote:
> SELECT * FROM table WHERE title = NULL LIMIT 1;
SELECT * FROM table WHERE title IS NULL LIMIT 1;
http://www.mysql.com/doc/W/o/Working_with_NULL.html>
http://www.mysql.com/doc/P/r/Problems_with_NULL.html>
1 - 100 of 254 matches
Mail list logo
