Antigen for Exchange found ½ðɽ¶¾°Ô.bat matching =*.bat file filter.
The file is currently Removed. The message, "½ðɽ¶¾°Ô", was
sent from mysql and was discovered in IMC Queues\Inbound
located at UCONN/SBA/ENTERPRISE3.
-
Befor
Hi All those responded!
Thanks Thomas Spahni and Jan. First thing fisrt. I did see the manual doc
pages (a lot) when I was trying the date_format function. Once I could not
succeed (and could not understood the docs) I posted my question. Now the
point is that date_format is not really for format
Hello,
i need function that will convert non-english characters (ěščřžýáíé)
to english.
Some values in table contains non-english characters and i need search
them. (via LIKE)
In posgresql is function to_ascii.
Regards
Michal Dvoracek [EMAIL PROTECTED]
sql,query,table
Problem
Mysql version 3.23.39 Linux version
SQL: INSERT INTO Pictures(Pers_ID, Picture) VALUES (1,
LOAD_FILE('\Database\pictures\1.bmp'));
above sql works fine.
Mysql version 3.23.49-max Windows version
SQL: INSERT INTO Pictures(Pers_ID, Picture) VALUE
folders = /var/lib/mysql - db tables i think..
commands will be on bin* dir, i think 2.
louie.
- Original Message -
From: "mandar m pohnerkar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 1:49 PM
Subject: installation problem
> Dear Sir,
>
> I have R.H L
yes. www.mysql.com
- Original Message -
From: "mandar m pohnerkar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 1:49 PM
Subject: installation problem
Dear Sir,
I have R.H Linux 7.2 and i have installed mysql
MySQL-client-3.23.49a-1.i386.rpm .But now i m
Dear Sir,
I have R.H Linux 7.2 and i have installed mysql
MySQL-client-3.23.49a-1.i386.rpm .But now i m confused that how
should i proceed?how to start the database and afterinstallation
where r the folders/files created?
Is there any manual for basic step on installation and starting
the d
char(1) default to either 0 or 1. I do not believe that SQL93 has a boolean
data type nor a standard for implementing it.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Michael Ivanyo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday
I am designing a database using MySql and need a
column that can hold a boolean value of T or F. I am
considering both the enum type and char type.
I would like to know if the enum type is a standard
type as defined by the ANSI SQL standard.
--Michael
try to do a search on google with the error message you posted here. i'm
sure this will help.
Liu Qianghua-qch1942 wrote:
>
> Hi, everyone,
>
> I am making use of mySQL to provide my client a solution. However, one of tables
>often crash and produces the folloing error message when I try to us
Hi, everyone,
I am making use of mySQL to provide my client a solution. However, one of tables often
crash and produces the folloing error message when I try to use the table in a query:
mysql> select * from action;
error 1016: Can't open file: 'action.MYD'. (errno: 145).
The record in this t
I won't purport to tell you the 'correct' way to do it but I will tell you
how I would do it.
When I have information (marital status) I create a 'domain table'. I have 2
rules for most of my domain tables.
1: they end in the word Type. (maritalStatusType)
2: they have 3 fields:
The PK (marital
Ok, what actualy do you wanna do? Sort records by dependencies, then
other records(that don't have them) sort in other order(alphabeticaly
or in order of appearance in the table)? if it is so you can do
this:
SELECT fieldName FROM table ORDER BY dependatOn,fieldName(or id - an auto_increment
fiel
Would it not be better to suggest that the poster gets a clue and goes buy a
book. I dare say there are hundreds that are useful. In all honesty should
the poster of a question like this not just give up?
http://www.mysql.com/doc/M/y/MySQL-Books.html
I'm sure one of these books would give some i
I have a question about the setup of the tables in my database.
In my members table, I store a lot of info about demographics, such as
marital status, income, etc. The way I'm doing this is the enum type. Is
it better to use this, or would it be better to create separate tables
for each demograp
>Description:
I'm trying to compile mysql on solaris 2.6. Getting these errors:
mysql.cc: In function `int sql_connect(char*, char*, char*, char*, unsigned
int)':
mysql.cc:2175: `sleep' undeclared (first use this function)
mysql.cc:2175: (Each undeclared identifier is reported only on
SELECT DISTINCT(mi.interest_id), COUNT(*) AS count,
i.name
FROM member_interests AS mi left join outer interests AS i on
mi.interest_id = i.id
GROUP BY mi.interest_id
ORDER BY i.name
You are correct, a left outer join is what you need.
*
* Cal Evans
* Journeyman Programmer
* Techno-M
This is the way databases work. I'm guessing you (like I) come from a
desktop database background where the system will lock a record for editing.
Not so for SQL servers.
One strategy you can use is to add a lock field to your record.
Then, before you commit your change (issue the UPDATE stateme
On 4 Jun 2002, at 15:43, Jared Richardson wrote:
> | >AVG_ROW_LENGTH=4096 MAX_ROWS=4294967295;
> |
> | Why do you use AVG_ROW_LENGTH=4096? It seems to me the max record |
> length is 528...? |
>
> According to the MySql docs, the max table size is AVG_ROW_LENGTH *
> MAX_ROWS
>
> We were try
I using MySQL (type=MyISAM) with Delphi5 -MyODBC, the problem is that when I
edit one row The MySQL not lock for other machines, therefore other person
can edit the same row and save the changes and when I try to save, it get
one error.
Tell me I to do?
Thanks.
-
Cesar,
looks like the indexes of some of your tables are corrupt.
Did you upgrade from a version < 4.0.1 to 4.0.1 lately? The sorting order of
accent characters changed in October 2001, which might cause the problem.
If you run CHECK TABLE on tables docmserv, relmrela, repmkt, what does it
prin
what you would have to do is have that button run a CGI script of some
sort that connects to the mysql server and performs the action. you
could also use php for this
Jamie Buck wrote:
>Is there a way to develop buttons on a webpage that can send command
>line instructions to MySQL, such as to
Before I get started, let me say that I have looked at the manual, gone
through a number of posts to the lists and read Paul's MySQL book. I've
tried a lot of things over the course of the past three hours and am hoping
that someone can shed some light on this one.
When I do the load data loca
Hello,
I am trying to develop a back-up procedure for our MySQL database.
The database is housed on our production Web server. My thought is to
simply make a slave on our file server that is backed up. I use InnoDB
type tables and my application uses transactions. I am wondering how
table/ro
I replied below
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 3:24 PM
Subject: Re: Bug related to large tables and it's indexes on Win2k
| * Jared Richardson
| [...]
| > CREATE TABLE IcAlias(
| >IcAliasID BIGINT N
Is there a way to develop buttons on a webpage that can send command
line instructions to MySQL, such as to run a script in a file that
already exists on the server? The command line instruction would be as
follows: >mysql database_name < file_name
Is it feasible to get this sent to MySQL throug
| Jared, I can't help solve your problem, but I'd be very interested if you
| got an answer!
|
| Two suggestions though that may be of use:
| 1) Make sure your indexes are healthy
| 2) Try using a MERGE table
Thanks! The indexes are the problem as I understand it... it appears that
MySql is
1) Add 1 or 2 gigs of ram
2) Adjust the my.ini (or my.cnf) settings to use it
This will get your data into memory and off the disk. This will make it run
an order of magnitude faster.
Also, you can buy a P4 from Dell for $599. You might want to throw more
hardware at the problem.
- Origi
* Jared Richardson
[...]
> CREATE TABLE IcAlias(
>IcAliasID BIGINT NOT NULL PRIMARY KEY,
>mID VARCHAR(255) NOT NULL,
>IcEntityID BIGINT NOT NULL,
>IcTypeID SMALLINT NOT NULL,
>IcDupSortID VARCHAR(255) NOT NULL,
>INDEX mIDIdx (mID),
>INDEX IcTypeIDIdx (IcTypeID),
>IN
I have the following tables:
Member_interests:
Member_id
Interest_id
Interests:
Name
Interest_id
I need a query that selects each interest name, and the # of members who
have selected it...sample output:
Boating 25
Hiking 10
..
Swimming0
Jumping 0
Talking 0
The following query works g
I downloaded mysql win 32 1.75-2 and downloaded the GUI for it. How do I
tie the SDK to the gui? Pardon me if this sounds vague.
AMeet
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
I have a file containing commands to add and drop tables as a means of
synchronizing two databases. What i want to happen is for MySQL to open
this file and read it at a specific time without the user having to
explicitly connect to MySQL and type in the commands in order to get it
to read the fil
Hi
I have a Huge amounts of data imported into mysql.
My database has about 1,500,000 rows.each row has a text
field with approx 70 words in it!.Size of my .MYD is 1013MB
mysql has been starting to make fulltext index on text field since 55 hours
ago!!!
and now it dose not accomplish this job yet!
Have you looked at cron on LINUX?
- Original Message -
From: "Jamie Buck" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 11:37 AM
Subject: Is it possible to have MySQL perform an action at a specifictime?
> I have a file containing commands to add and drop tab
[snip]
I have a file containing commands to add and drop tables as a means of
synchronizing two databases. What i want to happen is for MySQL to open
this file and read it at a specific time without the user having to
explicitly connect to MySQL and type in the commands in order to get it
to read
I have a file containing commands to add and drop tables as a means of
synchronizing two databases. What i want to happen is for MySQL to open
this file and read it at a specific time without the user having to
explicitly connect to MySQL and type in the commands in order to get it
to read the fil
Yes, It's easy to upgrade, but this version of zeoslib is sufficient stable
to use?
Also what enhancements it has?
Thanks for your help.
Iago.
-Mensaje original-
De: Fredrick Bartlett [mailto:[EMAIL PROTECTED]]
Enviado el: martes 4 de junio de 2002 17:02
Para: Informatica Handem; Kiss
[snip]
"Texas A&M University","College Station, TX","1999","Design, install, test
and run blah, blah.","Whatever Industry"
LOAD DATA INFILE 'd:\\text.csv' INTO TABLE projects FIELDS TERMINATED BY
',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n';
Have you tried this...
L
[snip]
"Texas A&M University","College Station, TX","1999","Design, install, test
and run blah, blah.","Whatever Industry"
LOAD DATA INFILE 'd:\\text.csv' INTO TABLE projects FIELDS TERMINATED BY
',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n';
[/snip]
Have you tried t
Before I get started, let me say that I have looked at the manual, gone
through a number of posts to the lists and read Paul's MySQL book. I've
tried a lot of things over the course of the past three hours and am hoping
that someone can shed some light on this one.
When I do the load data loca
Hi,
It happened to me ...with Red Hat 7.2 and MySQL 3.23.47.
Anyway if you want to see easily what's wrong you can do:
Identify the PID of your process which make monitoring processes.
In other task you can do :
strace -d -p the_PID
...and let it open.
When MySQL crash strace tell you with what s
My objective is to create a clean new and installed system (with a clean
database) from a developpement environment (where I do tests and
developpement) where the database is full of "things" I clean.
One solution would be to recreate from zero the database. But I have
decided to use a cleaned v
> sql,query
> Is there any option to do this on a windows version?
> All the documentation ( and from what I see of the
> installation of the =
> windows version ) leads me to believe there is not
>
> Luc
>
>
-
Before posti
> -Original Message-
> From: Tom Worobec [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 12:56 AM
> To: MySQl Lists
> Subject: MySQL & Access 97 slow
>
>
> Why do linked MySQl tables in Access 97 take longer to open
> thne linked
> Access 97 tables in Access 97?
> Is it MyOD
OK got this sorted in the end, by putting a soft link in to the /tmp
folder pointing to the /var/lib - thanks one and all.
Adam
Dicky Wahyu Purnomo wrote:
> On Tue, 04 Jun 2002 08:04:01 +0100
> adam <[EMAIL PROTECTED]> wrote:
>
>
>>Apologies for posting such a basic query, but I couldn't find
Egor Egorov wrote:
> adam,
>
> Tuesday, June 04, 2002, 12:05:30 PM, you wrote:
>
>>>the mysql.sock file is automatically created when mysqld is started.
>>>please check your configuration (/etc/my.cnf) and your mysql daemon ... :D
>>>
>>
>
> a> Thanks. However, something's still wrong.
>
> a
Dicky Wahyu Purnomo wrote:
> On Tue, 04 Jun 2002 08:04:01 +0100
> adam <[EMAIL PROTECTED]> wrote:
>
>
>>Apologies for posting such a basic query, but I couldn't find an
>>archived version of the mailing list, or a fix to my problem. Using
>>Linux Mandrake 8.2.
>>
>>It's the problem with mysql.
hi,
I have finished an application about online exam using
java servlet and tomcat and mysql.
I am trying to write a testing script to simulate 180
students to take the exam during the period of one
hour. so far i have no idea how to start. I didn't
find anything talking about that. I just found s
- Original Message -
From: "Mark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 6:19 PM
Subject: Re: grant ALL on *.* to ... Error
> - Original Message -
> From: "vlady" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, June 04, 2002 4:14 P
On 4 Jun 2002 at 18:57, R.C.Nougain wrote:
> Bad answer. If you 'guess', then don't answer. The idea behind the
> date_format is to format a date as per user's need and should not be forced
> to a particular format just because some countries follows some format.
> Still looking for serious answe
- Original Message -
From: "vlady" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 4:14 PM
Subject: grant ALL on *.* to ... Error
> Hi all,
> I have a strange problem,
> I am startirng my mysql-4.0.1 with option --skip-grant-tables.
> I am using "mysql" and when
You might want to have a look at urSQL --
http://www.urbanresearch.com/ursql -- it has built in support for
exporting query results in a variety of formats...
On Tue, 4 Jun 2002, Petre Agenbag wrote:
> Hi Can anyone tell me if they know about a good frontend for mysql with
> reporting facilities
Jay Blanchard wrote:
>[snip]
>I am trying to get only records out of a table mathing a query. This should
>be piped into a textfile. My problem is that I have to transmit this records
>to a new machine. So the output should be a kind of sql commands which I
>could run with phpadmin or similar t
It's ODBC in general. One more layer of abstraction to deal with.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Tom Worobec [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:56 AM
To: MySQl Lists
Subject: MySQL & A
I've read a couple posts about problems issuing updates to mysql on
full-text key'd columns, unfortunately the only answer found is that its
will be fixed in the upcoming 4.0.2 release. any idea when that will go
beta? or should I trying using the cvs version?
I could post a stack trace, but I
http://www.mysql.com/doc/G/R/GRANT.html
It's in there...keep digging.
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: vlady [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 9:15 AM
To: [EMAIL PROTECTED]
Subject: grant ALL
Hi Jared and Walter
I don't suggest changing to InnoDB just to try solve a unknown problem!
MyISAM tables are usually less problematic, being the default table type,
and most tested in MySQL. And it seems Jared has benchmarked it as being
more suited to his situation.
InnoDb tables are usually b
I agree, I would like to use multi table delete and other new features in
win32...
- Original Message -
From: "Artem V. Ryabov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 1:00 AM
Subject: release 4.0.2
> Hello developers,
>
> What problem with release 4.0.
It's easy to upgrade. I just did a search and replace in the .dfm files.
Fredrick
- Original Message -
From: "Informatica Handem" <[EMAIL PROTECTED]>
To: "Kiss Dániel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 3:00 AM
Subject: RE: WinZeos and Transactions
> T
vlady,
Tuesday, June 04, 2002, 5:14:54 PM, you wrote:
v> I have a strange problem,
v> I am startirng my mysql-4.0.1 with option --skip-grant-tables.
v> I am using "mysql" and when I try :
v> grant ALL on *.* to admin@localhost identified by "passwd"
v> i get the following errot:
v> ERROR 1047: U
David,
Tuesday, June 04, 2002, 5:43:16 PM, you wrote:
DS> I've implemented a full-text index on several of my database fields in a
DS> table, populated those fields with some very simple, yet distinct records,
DS> and have run recommended queries against that table. Alas, I still end up
DS> getti
grant ALL PRIVILEGES on *.* to admin@localhost identified by "passwd"
you may want to include "with grant option"
> -Original Message-
> From: vlady [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 10:15 AM
> To: [EMAIL PROTECTED]
> Subject: grant ALL on *.* to ... Error
>
>
>
> Yes, the concepts he presents are in generic SQL. I've used them in 2
> different systems (menus and security) and they work fine. (NOTE: You DO
> have to write your own code.) ;)
Ok, I picked up the book yesterday. It has alot of really good information.
However, with regards to the concept
On Tue, 4 Jun 2002, R.C.Nougain wrote:
> Bad answer. If you 'guess', then don't answer. The idea behind the
> date_format is to format a date as per user's need and should not be forced
> to a particular format just because some countries follows some format.
> Still looking for serious answer?
Did you check out the -w option to mysqldump?
andy wrote:
>Hi there,
>
>I am trying to get only records out of a table mathing a query. This should
>be piped into a textfile. My problem is that I have to transmit this records
>to a new machine. So the output should be a kind of sql commands whi
* Steve Katen
> alright, not sure if i can even do this or not, but i figured the list
> would know.
>
> here is the query i have:
> SELECT count(ID),sum(pnt1)+sum(pnt2)+sum(pnt3)+sum(pnt4) FROM
> wiseQuiz_questions WHERE test='$test'
>
> here is the table structure i have:
> CREATE TABLE `wiseQui
Terry,
Tuesday, June 04, 2002, 12:46:44 PM, you wrote:
T> i have a broken table and mysql seems not to fix it:
mysql>> repair table ksiegi;
T> +--++--+--+
T> | Table| Op | Msg_type | Msg_text |
T> +--++--+--+
T>
Steven,
Tuesday, June 04, 2002, 5:29:06 AM, you wrote:
>> Description:
SW> Our mysql server crashes relatively often. Most of the time after a
crash, the error logs show a line like "thd->query at 0x84aef98 = show processlist"
(although some have "0x50e64580
SW> is invalid pointer" an
R.C.Nougain,
Tuesday, June 04, 2002, 1:56:13 PM, you wrote:
RCN> create table dt (dt datetime);
RCN> --- OK
RCN> insert into dt values ( date_format('04/06/2002 13:48:38', '%d/%m/%Y
RCN> %H:%i:%s'));
RCN> --- Surprisingly it enters NULL
RCN> insert into dt values ( date_format('2002/04/06 13:48
Yogesh,
Tuesday, June 04, 2002, 12:26:10 PM, you wrote:
YM> >Description:
YM>
YM> mysql-4.0.1-alpha (Official MySQL RPM) installtion problem
YM> >How-To-Repeat:
YM>
YM> >Fix:
YM>
YM> >Submitter-Id:
YM> >Originator:
YM> >Organization:
YM>
YM> >MySQL support: [none |
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Installation of mysql on Solaris 2.6 using
3.23.49-sun-solaris2.7-sparc version
content-length: 2557
>Description:
>How-To-Repeat:
I followed the documentation regarding the steps
of installation.
groupadd mysql
Thanks Walter since their is no reason (that I am aware of) for the
system not to handle the current problem, I want to try to solve it if
possible. I have been using MySql for a number of years... if this is an
actual bug, it will be the first one I've ever encountered! :)
Also, we've teste
[snip]
I am trying to get only records out of a table mathing a query. This should
be piped into a textfile. My problem is that I have to transmit this records
to a new machine. So the output should be a kind of sql commands which I
could run with phpadmin or similar to import them to the other db
The table type is the default, MYISAM
- Original Message -
From: "Schneck Walter" <[EMAIL PROTECTED]>
To: "'Jared Richardson '" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 10:11 AM
Subject: AW: Bug related to large tables and it's indexes on
Hi all,
I have a strange problem,
I am startirng my mysql-4.0.1 with option --skip-grant-tables.
I am using "mysql" and when I try :
grant ALL on *.* to admin@localhost identified by "passwd"
i get the following errot:
ERROR 1047: Unknown command
Can some one felp me with that?
Gregards
Vlady
Luke Sather wrote:
>
> Greetings. I'd really enjoy having a SQL GUI for my Mac laptop, is it
> likely that one of BSD sources will compile under OSX? I haven't
> compiling anything yet, so I thought I'd should ask if it has been
> mentioned before.
Here is a list of many GUI MySQL clients for
alright, not sure if i can even do this or not, but i figured the list
would know.
here is the query i have:
SELECT count(ID),sum(pnt1)+sum(pnt2)+sum(pnt3)+sum(pnt4) FROM
wiseQuiz_questions WHERE test='$test'
here is the table structure i have:
CREATE TABLE `wiseQuiz_questions` (
`ID` int(1
This date formatting is how mysql handles dates. If it cannot parse the
date then is will store an invalid date.
Please see http://www.mysql.com/doc/D/A/DATETIME.html as this will
answer some of your datetime questions.
Accept your rebuke. You should have read up on datetimes before
posting.
Hi
Can anyone tell me if they know about a good frontend for mysql with
reporting facilities, or alternatively only a report generator?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi there,
I am trying to get only records out of a table mathing a query. This should
be piped into a textfile. My problem is that I have to transmit this records
to a new machine. So the output should be a kind of sql commands which I
could run with phpadmin or similar to import them to the othe
Hello all,
Are there any system_table which I can to do a pure SELECT command to get the same
results that MySql SHOW command, in the same way that Oracle DB ?
Thanks..
-
Before posting, please check:
http://www.mysql.com/m
SQL4X Manager by InterServices has worked for me, it doesn't have much for
meta edit guis though (alter tables and grant/revoke users)
On Tuesday 04 June 2002 8:05, you wrote:
> Is anyone successfully accessing MySQL from Mac OS X
> via a GUI front-end?
>
> Any advice?
>
> Thanks,
>
> Andrew
>
>
No, there are no STANDARD libraries that will do this for you.
There are some good database abstraction layers that you can employ, my fav
is ADODB (hit google to find it) but it only handles the basics. You will
have to write PHP code that you call each time you delete a record to do
additional
Win2k (at least the version that we are on) does indeed support files much
larger than 2 gigs. Another db we use has index files that are 6.8 gigs and
4.7 gigs.
- Original Message -
From: "miguel solorzano" <[EMAIL PROTECTED]>
To: "Jared Richardson" <[EMAIL PROTECTED]>; <[EMAIL PROTECT
I've implemented a full-text index on several of my database fields in a
table, populated those fields with some very simple, yet distinct records,
and have run recommended queries against that table. Alas, I still end up
getting back empty query sets. I have read about having a minimum of 3
recor
Bad answer. If you 'guess', then don't answer. The idea behind the
date_format is to format a date as per user's need and should not be forced
to a particular format just because some countries follows some format.
Still looking for serious answer?
- Original Message -
From: "Harald Fu
Hi,
If "show processlist" is not satisfied for you the try :
"show full processlist;"
On the right you can see the current query.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Good Morning,
Please see into file mysql.err look the InnoDB errors.
We are working with 4.0.1-alpha-max-nt-log versión under operating system
Windows 2000 advance Server. Our database have about 13GB of disk.
Thank you for your help.
We are waiting for your solutions or comments.
Best regar
Think that even if mysql don't have connection, there are severals processes
running ...
For waiting connection for exemple.
<< with 11.5 Mgs or so >>
This memory is i think a buffer or a cache shared by each mysql process such
as indexes for exemple ...
David
From: <[EMAIL PROTECTED]>
To: "Ser
Bret
Thanks for the reply. I put that message up on three list (PHP,
MySQL, RedHat) and this has been the only reply. There are a lot of
software packages that I found searching google.com, but they are all for
cyber cafe's that have the computers all ready set up for people to log
Hi
Could anyone suggest me the JDBC Drivers available for MySql.
Can the driver support Connection Pooling and RowSet
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
Is anyone successfully accessing MySQL from Mac OS X
via a GUI front-end?
Any advice?
Thanks,
Andrew
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
---
thanks Sergey,
but that command line only shows the total processlist, it doesn't show
exactlly witch queries are happening on my tables besids my one that says 'show
full processlist'.The others are sleep , but if they are really, why is my
mysql server running severls processes with 11.5 Mgs or
adam,
Tuesday, June 04, 2002, 12:05:30 PM, you wrote:
>>
>> the mysql.sock file is automatically created when mysqld is started.
>> please check your configuration (/etc/my.cnf) and your mysql daemon ... :D
>>
a> Thanks. However, something's still wrong.
a> Restarted the daemon - /usr/sbin/s
thanks David,
i have allready seen that but what is exactlly them command line to do so?
EX: the select queries or the update ones in all databases or in just in one.
regards
tsa
On 04-Jun-2002 David BORDAS wrote:
> Hi,
>
> Just connect to mysql and use this query :
> show processlit;
> http:
Chris,
Tuesday, June 04, 2002, 12:08:38 AM, you wrote:
CS> I can't remember my root password. I know that there is a way to set it by
CS> starting mysql with certain parameters, but I can't remember what those
CS> parameters are. Can you help me out? Thanks!
You should start mysqld with --sk
Arul,
Tuesday, June 04, 2002, 9:23:34 AM, you wrote:
A> I have created a table parent and also another table child where parentid
A> column in child is a foreign key to the id column in parent table
A> Is it possible that i have no entries in parent table , and i am inserting
A> null values
Don,
Monday, June 03, 2002, 11:13:59 PM, you wrote:
DV> there are 2 files in my /tmp directory that look like mysql datafiles:
DV> #sql208_ecc_0.MYD
DV> #sql208_ecc_0.MYI
DV> They're on the same box as our development mysql instance but I don't see them on
any of our other instances. Anyone ha
Mary,
Monday, June 03, 2002, 11:00:17 PM, you wrote:
MD>I just installed MySQL. Win 2000 Professional.
MD>I am logged in as none.
MD>No User Id. No Password.
MD>I wonder how. :)
Check the manual. By default on Windows all local users have full
privileges on all databases.
MD>
Alexandre,
Monday, June 03, 2002, 8:08:14 PM, you wrote:
AZ> Maybe this thread has already been solved. If so im sorry for the disturb.
AZ> Here is my problem:
AZ> I want to use InnoDB transactionnal table types with mysql on Windows 2000 .
AZ> I set my ini file correctly, start the console a
1 - 100 of 129 matches
Mail list logo
