In the last episode (Feb 04), Shomal Bafna said:
The box is running a MySQL 3.23-47 Max rpm based version on a
Mandrake 8.2 Linux with Duron processor and 256MB Ram. Thera are 10
InnoDb type tables created and several MyISAM types too (approx 30
more.). On adding the 11 table of InnoDb type
Hi,
I am trying out mysql-4.1.
I got the source code;
configured it using --with-sharset=big5;
successfully build it and got it installed.
However, the following error occurrs,
while mysqld is starting up.
/usr/local/libexec/mysqld start
/usr/local/libexec/mysqld: File
Hello,
sorry for this question, after googling for nearly 2 hours, I really
thought I found out everything I could on my own.
Just found this one:
http://www.mysql.com/doc/en/Full_table.html
and my questions are answered. Thanks and sorry again.
--
Manuel Kiessling
I have mysql in a redhat machine. I need to use mysql do user
authentication to a website.
I have a table like following.
+--+--+
| username | passwd |
+--+--+
| jianping | jian1830 |
| chichi | jian1830 |
+--+--+
I want the passwd field not
At 14:36 04/02/2003 +0200, Ciprian Trofin wrote:
Hi,
I tested against the last release 3.23.55/4.0.10 and
below the results:
c:\mysql\binmysql -uroot -p test
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version:
On Tue, Feb 04, 2003 at 12:32:27PM +0900, kk wrote:
I have previously used a company in India and I am not averse to
trying this again.
You are not supposed to turn your face against all indian companies and just
pass your personal comments in a userlist like this.
Your experience may
Hello all,
I want to change some of our database host settings to allow for other host
connection other then the default 'localhost' setting. what is the proper way to
assign a different host to connect to, like an IP address or something like
mysql.somedomain.com,..etc..
thx's
--
On Tue, Feb 04, 2003 at 01:27:13PM +0200, Okan CIMEN wrote:
Hi all,
First of all , the version of mysql is 3.23.52. I am using When I do a
truncate table on a MyIsam table, the show table command shows thatt there
are no records but the table size is about 100 MBs.
Afterwards, I run an
- Original Message -
From: Alex Shi [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; mysql group
[EMAIL PROTECTED]
Sent: Monday, February 03, 2003 10:39 PM
Subject: Re: datadir and socket
But still I have question regarding my.cnf: I searched the whole
file
Locate the mysql.sock file and create a symbolic link to the
/var/lib/mysql/mysql.sock file. :)
- Brian J.
-Original Message-
From: Tomasz Krasiel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 6:56 AM
To: [EMAIL PROTECTED]
Subject: ERROR 2002
I installed MySQL 3.23.54
Hello all,
I want to change some of our database host settings to allow for other host
connection other then the default 'localhost' setting. what is the proper way to
assign a different host to connect to, like an IP address or something like
mysql.somedomain.com,..etc..
thx's
mysql
Shomal,
- Original Message -
From: Shomal Bafna [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, February 04, 2003 7:46 PM
Subject: Innodb: Limited creation of tables
The box is running a MySQL 3.23-47 Max rpm based version on a Mandrake 8.2
Linux with Duron
Crescent,
if you look at the yourhostname.err file in the MySQL datadir, does it
contain anything?
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
sql query
Hello,
On Tuesday 04 February 2003 14:46, Grover Cussi N. wrote:
restore to the original size ?, I see that the tendence of the innodb
tables is to grow, and grow, and never will reduce the size, it is
posible to control this?
I had the same problem, it went on until I had 44G of InnoDB
What type of 'hang' are you reporting? Have you checked the processlist to
see if the connection is processing a request? Are you returning a large
result set that needs to be displayed?
-Original Message-
From: pazenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 7:43 AM
the whole program halts by itself, this is how my software work
* form loads, then i open a connection, then i close connection but not
terminating it to be use later
* the user click the 'add' button, all related textbox will be enabled.
* the user type in all the details, while typing the
Hi!
InnoDB is a MySQL table type which provides transactions, foreign key
constraints, and a non-free hot backup tool. InnoDB is included in all
versions of MySQL-4.0. You can download MySQL-4.0 from http://www.mysql.com.
As the MySQL-4.0 branch approaches declaration of stability, this InnoDB
Description:
Multiple IS NULL tests in a WHERE clause appear to be broken
when testing NOT NULL date fields. Queries work fine against
varchar and int, probably(?) others.
How-To-Repeat:
create temporary table test (a date not null, b date not null);
insert
You are absolutely right! In the /usr/bin/safe_mysqld, there're two lines
where /var/lib/mysql... is residing. To me this looks kind of rediculous
(sorry for my stupid comment), why they have those configuration
info hard-coded in the script? Since we already have my.cnf so the
conf info was
Hi.
On Mon 2003-02-03 at 10:19:59 +0100, [EMAIL PROTECTED] wrote:
[...]
That can be made to work with several versions. In other words, it
would not check a version number saved in the database, but determine
the version by the database structure itself.
That would give #2 with the
I have a MySQL table:
++--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-++
| id | int(10) unsigned | | PRI | NULL
From the 4.0.8 changelog:
o We now send big queries/result rows in bigger hunks,
which should give a small speed improvement.
Is this configurable ? I'd like to measure various hunk
sizes for my sql query.
/GG
-
Before
I was just reading through the Mysql manual section 3.32
And came across a sentence that started like this
Animal sex can be represented in a variety of ways
My mother tongue is not English but doesn't it sound rude ? :-)
mysql CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-
Hi.
On Tue 2003-02-04 at 17:04:39 -, [EMAIL PROTECTED] wrote:
I noticed that when you return a zerofill field from a select statement into
a server-side language, say PHP or Perl, it will store the number with the
zeros included, great no problem.
However, if I insert into that table
Description:
I have a delete statement and an insert statment. I'm replacing a line but I
want
to make sure, that its deleted. The insertion is successful as per sql batch
output.
But when I dump the data from the table, there is no record for the date !
Seems like
hi all
i am working on a very huge MyISAM table in mysql which is updated
every second. this table keeps on increasing.
so i want to store it on different disks(as one would not be
sufficient).
is there any method so that i can store the table on a different disk
once the present disk is full
I notice some of my colleagues using SET in INSERT statements.
DuBois makes a short reference on p565, DoorStop1.
The Manual has some mention in http://www.mysql.com/doc/en/SET.html
I sort of get it but I am looking for a fuller explanation.
Louise
I notice some of my colleagues have used SET in INSERT statements.
DuBois makes a short reference on p565, DoorStop1.
The Manual has some mention in http://www.mysql.com/doc/en/SET.html
I sort of get it but I am looking for a fuller explanation.
Louise
(for the filter this time:
MySQL,
My first post, please go easy if this is the wrong pleace!
I'm trying to find an IMAP server which used MySQL so that my Mozilla
Email client can file it's email a little faster.
Has anybody heard of such a device?
I just finished configuring courier-imap to use a MySQL table to
refer to 1.7.4.1 Subselects in the manual for the
answer. here's a brief example:
The queries:
SELECT * FROM table1 WHERE id NOT IN (SELECT id FROM
table2);
SELECT * FROM table1 WHERE NOT EXISTS (SELECT id FROM
table2 WHERE table1.id=table2.id);
Can be rewritten as:
SELECT table1.* FROM
Nicholas,
Tuesday, February 4, 2003, 12:25:08 PM:
Ok I'm stumped on what I think should be a somewhat simple query. What I
have so far is a list of names that is in a list of projects AND in a the
main contact list by doing the following query:
SELECT p.name, p.company FROM contacts c,
Hi all,
Does anyone know a program for Windows that can create reports for MySQL
databases?
If you know more, please tell me more, because I need to check which of them
are accessible for the blind.
Thank you.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
Hi all
where do i mention with-raid option in my.cnf file(under which
program)?
i could not find it out in the manual.
thanks in advance
prasanth
mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the
I don't know such product running with MySQL. There is something called
Bill storage server which runs with PostgreSQL, perhaps someone knows a way
to put MySQL behind it instead of PostgreSQL.
B.
At 17:26 04-02-2003 +, Ben Clewett wrote:
MySQL,
My first post, please go easy if this is
Hi.
On Tue 2003-02-04 at 12:25:08 -0500, [EMAIL PROTECTED] wrote:
Ok I'm stumped on what I think should be a somewhat simple query. What I
have so far is a list of names that is in a list of projects AND in a the
main contact list by doing the following query:
SELECT p.name, p.company FROM
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 3 Feb 2003 [EMAIL PROTECTED] wrote:
Quoting [EMAIL PROTECTED]:
Also, I used this command:
CC=cc -pthread CXX=cxx -pthread -O \
./configure --with-named-thread-libs=-lpthread -lmach -lexc -lc
This is the configure line I use on our
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 4 Feb 2003, Manuel Kiessling wrote:
to allow tables bigger than 2GB, I want to compile MySQL in a way that
it can utilize the LFS support on my Linux box (SuSE 8.1, ext3 FS,
should support files up to 2048GB).
Anyone has an advice?
The
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.10, a new version of the popular Open Source Database, has been
released. It is now available in source and binary form for a number of
platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
Note that
Hello everybody,
Is it possible to set up this kind of replication and what parameters I have
to set in the my.cnf file ?
Table A own by server A and replicated to server B and C
Table B own by server B and replicated to server A
Table C own by server C and replicated to server A
The mysql
try to use the password() function.
update user set password=password('your_psw') where
user='your_user'
bye
--- Jianping Zhu [EMAIL PROTECTED] ha scritto:
I have mysql in a redhat machine. I need to use
mysql do user
authentication to a website.
I have a table like following.
- Original Message -
From: Jianping Zhu [EMAIL PROTECTED]
Sent: Tuesday, February 04, 2003 1:58 PM
I want the passwd field not to be plain text but encrypted. how can i do
that?
Use the password function:
mysql create table users (
- name varchar(12),
- pass varchar(16));
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Hi,
Simply do the following:
INSERT INTO yourtable (username, password)
VALUES ('chichi', PASSWORD('jian1830'));
The encrypted password will look like this... 2748c558120ee3c9. This is
MySQL's own internal encrypting function.
Remember to set the password to a, CHAR(16) binary not null,
Hi,
Use the PASSWORD() function to encrypt the password.
There are other encryptation functions in MySQL like MD5(), SHA1(),
ENCRYPT(). Have a look at functions you can use in SELECT statement at
the manual.
http://www.mysql.com/doc/en/Miscellaneous_functions.html
On Tue, 2003-02-04 at 19:58,
hi there i was wondering if mysql 4 will become production quality soon ? i
would like to convince work to start using it, so i can start using the
transactions, sub selects and query cache
-
Before posting, please check:
I'm thinking of setting up a bulletin board for a system with Windows
2000
OS.
Most of the good, affordable BB software uses MySQL databases.
Is it possible/practical to run MySQL on Windows OS? Does it take a lot
of
techy knowledge, time trouble?
Yes, you can run it on Windows. No, it is
* Wilbert Enserink
I have a string containing recordID's in a specific order (e.g.
$string=17,2,33,5,99)
How can I select those records from a table in the right order (as
determined in $string)?
SELECT * FROM table WHERE recordID IN ($string)
results in the right records but not in the
On Tue, 4 Feb 2003, Jianping Zhu wrote:
I have mysql in a redhat machine. I need to use mysql do user
authentication to a website.
I have a table like following.
+--+--+
| username | passwd |
+--+--+
| jianping | jian1830 |
| chichi | jian1830 |
On Tue, 4 Feb 2003, Mike Blezien wrote:
Hello all,
I want to change some of our database host settings to allow for other host
connection other then the default 'localhost' setting. what is the proper way to
assign a different host to connect to, like an IP address or something like
Hi Derek,
No it doesn't take alot of techy knowledge, time or trouble to run MySQL
on windows...Just download it and install and it will be ready to
run.Infact installation on a Windows sytem should be easier than on *nix.
Regards,
Eric
===
Kamara Eric Rukidi Mpuuga
Yes,
You can use the FIELD() function:
SELECT * FROM table WHERE recordID IN ($string)
ORDER BY FIELD(recordID,$string)
On Tue, 2003-02-04 at 13:15, Wilbert Enserink wrote:
Hi All,
I have a string containing recordID's in a specific order (e.g.
$string=17,2,33,5,99)
How can I select
Hi People,
I have been trying to get InnoDb to run on my windows XP machine. I have
MySQL 3.23.55 installed and i am running the mysqld-max-nt server. I
have added the following lines to my my.ini file: (note the # because i
didnt get it to work, i dissabled it)
[mysqld]
.
Hi
Thanks for the information, my Microsoft SQL DBA is looking the DTS VB Script
stuff.
I will post the information if it works
Cheers
--
Jonathan Bedford
Quoting Victor Pendleton [EMAIL PROTECTED]:
In the DTS engine you can write a VB script to handle the quotations during
the
no mysql.sock file on machine. I'll remove mysql package and reinstall it
and see if things go better then.On Tue, 4 Feb 2003, Brian Johnson wrote:
Date: Tue, 4 Feb 2003 14:33:54 -0600
From: Brian Johnson [EMAIL PROTECTED]
To: 'Tomasz Krasiel' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject:
Dear Ladies and Gentlemen,
in order to backup databases or better the whole server file-based , I'd
like
to know , if there is a way to get a read-Lock for all tables in a database
or even better for all tables in all databases.
Something like:
LOCK TABLES db_name.% READ;
which I tried cause
Hi!
When running a query like:
LOAD DATA CONCURRENT INFILE '...' REPLACE INTO TABLE l_data FIELDS
TERMINATED BY ',' ENCLOSED BY '\' LINES TERMINATED BY '\n'
(list_id,email,f1,f2,f3)
mysql seems to forget to invalidate the query cache, because added rows are
not displayed in following
SELECT
56 matches
Mail list logo
