Randall Perry wrote:
Mysterious. I assume `mysql -p` prompts you for root's password and
works as expected, since without -p it says you're not using a password,
rather than saying there's something wrong with the password.
Yes, that works.
When you tried the defaults-file option, did you use
Hi,
I've tried to compile MySQL 4.1 from src.rpm, but with no
success.
Can anybody help me to compile MySQL 4.1 from Source rpm? I
tried to do everything as said in documentation. First I tried to
compile it without making any changes to SPECS file. But Everytime it
exists with
Hi,
Has anybody created UDF's in MySQL? Is there a way to create UDF
without compiling MySQL with -with-ldflags=-rdynamic? Maybe they must be
simple expresion based without using somewhat wrom mysqld (as said in
documentation)?
Thanks for advice,
Arunas
--
MySQL General Mailing
Martin Gillström wrote:
I think it is. But I understand your point. But as you can see the key
ImgId with value 1 is never returned when I use limit.
The line
SELECT ImgId,CreatedDate FROM dogge ORDER BY CreatedDate DESC LIMIT 2,1
return ImgId 4
And the line
SELECT ImgId,CreatedDate FROM dogge
Hi to all,
I'm fed up with Access as a wysiwyg editor for mysql. Generaly, i'm fed
up with client that i have to install on each comp. Actualy, i'm looking
for an opensource wysiwyg web software. Something like the very good
phpMyAdmin but with 'visual' request editor for simple users.
If
Hi,
I Install R.H. 9.0 one dedicate pc but when i going restart mysql service or
access database it's given me
following error.
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
Please guide me what should i do. even i try to instal nushere tool
vikas kamble [EMAIL PROTECTED] wrote:
I Install R.H. 9.0 one dedicate pc but when i going restart mysql service or
access database it's given me
following error.
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
Please guide me what
Peter Larsen [EMAIL PROTECTED] wrote:
Replication does not happend if inserts (update not tested) is made without
mysql_select_db(database, $connection); (yes, I use php..).
Working:
mysql_select_db(database, $connection);
mysql_query(INSERT INTO table (text1, text2) VALUES ('bah',
Hi guys,
I have configure a daily backup for mysql database. the problem is that i
need to specifiy the password when using mysql
mysqldump --all-databases --opt --password=1234567 testing.sql
how can i encypt this --password=1234567
Thanks
patrick
hi all,
I am trying to insert data into MYSQL via a excel sheet.
But the minute i disconnect ..the data disappears from the data base..
some how the transaction is not getting committed..
I am using ADO Recordset and USing both insert and Update for Data
manipulation..
Do advise as to why this
On Monday, November 17, 2003, at 02:58 AM, Michael Stassen wrote:
cat $HOME/.my.cnf
[client]
password=rootpassword
/usr/local/mysql/bin/mysql --defaults-file=$HOME/.my.cnf
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
Oh. That changes things. The error says
Hi Guys,
Do you know what version user variables were introduced? I can't seem to
get them working in 3.22 and yet they work in 3.23.
Best regards,
Bruno Mustone
Mulugeta Maru [EMAIL PROTECTED] wrote:
My background is Micorosoft Access and SQL server. The InnoDB table type
gives me a much close option to move my databases. I found the database a
little complex and would like to know if there is a better step-by-step
explanation of setting up InnoDB
If most of my queries against a DB are goign to be related to when things
happened/within a date range... would it be more efficient to use
timestamps or datetime fields? I plan to index either column, as it will
be in many where clauses.
I'm currently still running 3.23.38 with plans to
W. Bauer [EMAIL PROTECTED] wrote:
Getting confused in the mysqlcc as a [EMAIL PROTECTED], I managed
that I cannot grant privileges any more. Any hint how I can undo
that?
If you still have privileges on the database 'mysql' you can set Grant_rpiv to 'Y'
with UPDATE statement.
--
For
Can you check to see what messages are logged in the error log? Did you
install MySQL as a service? Is the service set to start up automatically?
-Original Message-
From: William IT [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 6:41 PM
To: [EMAIL PROTECTED]
Subject: Mysql
Can you please post the error?
-Original Message-
From: Thai Thanh Ha [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 8:10 PM
To: '[EMAIL PROTECTED]'
Subject: Please help DB Error: unknown error
Hi all,
I have a problem with my query on mySQL 4.0.
DB Error: unknown error
I
You need to connect as a privileged user. You should delete the anonymous
account for security reasons.
-Original Message-
From: Shane Korosec [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 1:56 AM
To: [EMAIL PROTECTED]
Subject: Access denied error
I have recently installed
you could put the password in your .my.cnf file and change permissions so
that only the MySQL user can read the file.
-Original Message-
From: patrick kuah [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 5:15 AM
To: [EMAIL PROTECTED]
Subject: mysqldump query
Hi guys,
I have
I am using a program that says I should use source to read in and
execute a file. I tried using the direction in Mysql second edition I
think on page 795 or something thereabout,
source file_name, /. file_name
I do not have the complete syntax, but what I did reesembled something
like the above.
Mac OS 10.2.3. Maybe Panther has an issue with the build?
10.2.3 is Jaguar, not Panther. Did you mean 10.3.x? As I said, I'm
running mysql 4.0.16 on Mac OS 10.2.8, and this works for me. I suppose
an issue with Panther is possible, though I'd be surprised if something
simple like
In the case of root cron jobs then, you need a .my.cnf readable only by
root in root's home. It should include
[client]
password=mysql_root_password
This is incorrect, unless the double quotes are part of the password.
Removing them so that the entry reads:
[client]
What seems to be the problem? Are you getting an error message? If so can
you post the message?
The syntax is \. fileName
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:10 AM
To: [EMAIL PROTECTED]
Subject: Reading and Executing a
It seems that 4294967295, the max value for an unsigned int, is not large
enough. Is there an issue with using bigint or storing the value in char
format?
-Original Message-
From: John A. Sullivan III [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:18 AM
To: [EMAIL PROTECTED]
Hello List.
Does anybody knows how to configure table_priv table of Mysql?
I didn't find something in manual
I have v. 3.23.41 in Linux
Thanx
Nikos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Shane Korosec [EMAIL PROTECTED] wrote:
I have recently installed MySQL my mac running OS X 10.3 and can connect to
MySQL using the command:
/Library/MySQL/bin/mysql
However, once connected, I have tried to create a database and received the
error message:
ERROR 1044: Access denied for
table_privs is going to assign privileges at the individual table level
grant select on database.tablename to user@'192.168.0.10' IDENTIFIED BY
'password'
-Original Message-
From: Nikos Gatsis [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:20 AM
To: [EMAIL PROTECTED]
The problem is that I was getting an error message. I am not at home
right now, and should have posted the message last night. However, my
main question is trying to know based on what the instruction says:
Using mysql - connect as your root or other privileged user
connect to your geeklog
Greetings. Can anyone comment on the stability of MySQL on Win32?
Unfortunately I may have to use IIS for a project and am just wandering if I
can expect the same sort of stability and performance using MySQL (and PHP)
on a Windows Server.
Thanks for any advice!
--
MySQL General Mailing List
\. c:\loadFile.sql
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:41 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Reading and Executing a source...
The problem is that I was getting an error message. I am not at home right
The connection identifier returned by mysql_connect() need not be passed to
calls to MySQL-related functions.
What is the scope of this claim?
In particular, if I open a connection and then call a function I wrote
myself, which then calls a MySQL related function, can I still omit the
connection
Paul:
In my experience, MySQL on Win32 platforms is very stable. Of the 80+
customer systems we have running our applications in conjunction with MySQL,
the vast majority are on Win32.
The DB server needs to be properly tuned for the application and
environment, but that is the case with RDBMS
I just upgraded to Server version 4.0.15-standard, I just tried to do a
query and got a syntax error but the error message is incomplete.
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'where
Was there actually a syntax error? Can you please post the query? The
display for the error message appears to be truncated.
-Original Message-
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 8:44 AM
To: [EMAIL PROTECTED]
Subject: Error message problem
I just
Yes there was a syntax error. I used an and instead of in the
where clause.
However, my concern is that the error message was truncated.
Jeff
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 9:53 AM
To: Jeff McKeon; [EMAIL
Hi,
Let say that I have the following transaction:
1. Read value v1 from table t1.
2. Do some computation using v1.
3. Update value v2 from table t2.
If in the above I don't want any other concurrent transaction to read v2
until I'm done updating it, how should I put an exclusive lock on it?
Hello,
I am following the advice of the manual when bulk loading a large table by turning off
index builds before LOAD DATA INFILE. The load ends normally (73 GB). The mysamchk
build of the indices fails:
myisamchk: warning: Can't change size of indexfile, error: 22
myisamchk: error: 22 for
Swati,
You can also use mysqldump to be part of the mechanism to move the
database(s) from one computer to another. Something like:
Prompt mysqldump --add-drop-table databasename -uuserid -ppassword | mysql
--host=your.new.host.IP databasename -uuserid -ppassword
-Original Message-
Greetings. Can anyone comment on the stability of MySQL on Win32?
Unfortunately I may have to use IIS for a project and am just wandering
if I
can expect the same sort of stability and performance using MySQL (and
PHP)
on a Windows Server.
In two years of light but increasing use of
At 07:45 AM 11/17/2003, you wrote:
Greetings. Can anyone comment on the stability of MySQL on Win32?
Unfortunately I may have to use IIS for a project and am just wandering if I
can expect the same sort of stability and performance using MySQL (and PHP)
on a Windows Server.
Paul,
Someone
Can you elaborate please? Like I said, the sql file I am executing is in
E:\Apache\apache2\htdocs\public_html\weather
I see that you typed \ c\loadfile.sql - Please explain. I really am new
to this.
Thank you
Victor Pendleton [EMAIL PROTECTED] 11/17/03 08:56AM
\. c:\loadFile.sql
I have been developing with Windows2000, Apache, MySQL and PHP (WAMP ?) platform for
about two years now and have had no problems. However, I have been deploying onto a
Linux server so my observations may not be valid for your purposes.
John Griffin
-Original Message-
From: Paul Fine
Hi Victor,
Sorry...I'm not a SQL guy. Can advise me how to i procced with this???
Thanks :)
From: Victor Pendleton [EMAIL PROTECTED]
To: 'patrick kuah' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: mysqldump query
Date: Mon, 17 Nov 2003 07:06:18 -0600
you could put the password in your
Greetings, I would be greatful for any advice on the correct way to do this.
If I have something dynamic, for example customer names where usually there
are 1 or 2 unique customer names but possibly say up to 10, what is the
correct design?
For example I could simply create a table with name_1,
Are you running on a Linux platform?
File = .my.cnf
Location = ~
Contents =
line one: [client]
line two: user=userName
line three: password=userPassword
Security = chmod 600 .my.cnf
-Original Message-
From: patrick kuah [mailto:[EMAIL PROTECTED]
Sent: Monday,
Running Win2K and the latest MySQL 4 release. I have a little more than half
a billion rows in three databases and about 50 tables. For about six hours a
day, MySQL is hammered like there's no tomorrow adding/deleting/updating
millions of rows. No problems at all.
I've been using MySQL for almost
I would like to copy the contents of result set by
single command
e.g.,
select * from db1 where id 3;
result 1
result 2
now how to write this results into another db
without writing to a text file (outtext)...
when both source and destination has the same
structure
thanks
m.karthikeyan
insert into
...
select
...
-Original Message-
From: Dr M Karthikeyan [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 9:51 AM
To: [EMAIL PROTECTED]
Subject: copy the result content from one db to another
I would like to copy the contents of result set by
single command
e.g.,
- Original Message -
From: Paul Fine [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 17, 2003 10:37 AM
Subject: The correct way to deal with name_1, name_2, name_3
Greetings, I would be greatful for any advice on the correct way to do
this.
If I have something
This works just like doing it from table to table, just specify hte db
insert into dbname.tablename select * from db1.tablename where id 3;
HTH
Jeff
Hello,
I want to have a query that returns the names from people that are
having their birthday one of the coming 7 days. I currently have a buggy
query that deals with this, but that query fails when the birthday is
the next month, and we're now in the last week of the month before.
Can
Hello, I tried to compile the latest mysql rpm on fedora.
The compilation is ok , but when I try to install the compiled
MySQL-client rpm the system exits with:
perl(the) is needed by MySQL-client-4.0.16-0
Does someone have an idea?
Thanks
Daniele
--
Thanks.
I do mean Do you mean one column for each name, in which case these would
comprise 10 columns, most of which would have NULL most of the time?
Is this your suggestion in this case:
Table 1
| blahblah | blah | blah | CustID (PK) |
Table 2
| CustID (FK) | Name |
Table 2 Sample Data
|
Ed Leafe wrote:
On Monday, November 17, 2003, at 02:58 AM, Michael Stassen wrote:
cat $HOME/.my.cnf
[client]
password=rootpassword
/usr/local/mysql/bin/mysql --defaults-file=$HOME/.my.cnf
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
Oh. That changes things.
mysql test
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a MySQL database with records in a table that i would like to replace.
The table is
items and the field is description. I would like to replace the existing text
within this filed with some new text.
I did this before and it was successful but I have lost the query to do it :(
Could
On Monday 17 November 2003 18.04, Andrew wrote:
I have a MySQL database with records in a table that i would like to
replace. The table is
items and the field is description. I would like to replace the existing
text within this filed with some new text.
I did this before and it was
On Monday, November 17, 2003, at 11:51 AM, Michael Stassen wrote:
I'm glad this worked for you, but now I'm confused. The manual
clearly indicates the use of quotes around the password. See
http://www.mysql.com/doc/en/Option_files.html. The typical user
option file starts with
[client]
Hi Mike
I really appreciate you getting back to me so quickly :)
Can I just clarify this becuse I have over 4000 records and not all of the
records have anything in items - description but there are about 2500 records
with this exact text-
br /A-Z Business Directory br /br / Please call 0116 27
amazing, and you guys are errr intelligent!!! can't actually help but you can
make an abbreviation for RTFM how fucking sad is that, what a bunch of pathetic
losers.
-Original Message-
From: Rodolphe Toots [mailto:[EMAIL PROTECTED]
Sent: 17 November 2003 18:11
To: [EMAIL PROTECTED]
I encountered a problem where a simple comparison
operation seemed to fail.
Has anyone else seen this? Take a simple table:
a FLOAT(10, 2)
b DOUBLE
With data:
+--+--+
| a| b|
+--+--+
| 1.50 |1 |
| 6.00 |4 |
| 5.60 |4 |
+--+--+
Then do a
Andrew,
Please allow a small amount of grief to come from these lists... People are usually
glad to help, and Mike sent the info that he knew to you. There is a certain amount
of frustration that develops when people repeatedly ask questions of the mailing list
that are clearly documented
- Original Message -
From: Paul Fine [EMAIL PROTECTED]
To: 'Stephen Fromm' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, November 17, 2003 11:49 AM
Subject: RE: The correct way to deal with name_1, name_2, name_3
Thanks.
I do mean Do you mean one column for each name, in which
At 12:05 PM + 11/17/03, Bruno Mustone wrote:
Hi Guys,
Do you know what version user variables were introduced? I can't seem to
get them working in 3.22 and yet they work in 3.23.
They were introduced in 3.23.6.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB,
I understand what the manual is saying and I was asking for confirmation that
what I was doing was indeed the right way forward, instead of going a head and
potentially fucking up 2500 records!
But alas it seems that people are repared to spend more time writing shite about
reading manuals and
I have created tables in mysql using a weblog. I now realize that I need
to reinstall the plugin that I originally installed. Can someone tell me
how to delete specific table from a database?
I use phpmyadmin to manage mysql and I figured checking the check boxes
next to the tables that I want to
Hmmm they seem to work in version 3.23.57.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 17 November 2003 18:38
To: Bruno Mustone; [EMAIL PROTECTED]
Subject: Re: User Variables
At 12:05 PM + 11/17/03, Bruno Mustone wrote:
Hi Guys,
Do you know what version
At 6:39 PM + 11/17/03, Andrew wrote:
I understand what the manual is saying and I was asking for confirmation that
what I was doing was indeed the right way forward, instead of going a head and
potentially fucking up 2500 records!
But alas it seems that people are repared to
spend more time
At 10:28 AM -0500 11/17/03, Ola Ogunneye wrote:
Can you elaborate please? Like I said, the sql file I am executing is in
E:\Apache\apache2\htdocs\public_html\weather
I see that you typed \ c\loadfile.sql - Please explain. I really am new
to this.
No, he typed \., not \, and c:, not c. If you
At 6:45 PM + 11/17/03, Bruno Mustone wrote:
Hmmm they seem to work in version 3.23.57.
Given that they were introduced in 3.23.6 (as stated below), that
is not surprising.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 17 November 2003 18:38
To: Bruno Mustone;
Looks to me like you want to use UPDATE instead. Specify a WHERE clause
that identifies the rows you want to update, and in the SET clause specify
the new value for the description column.
To pre-flight your UPDATE, you can write a SELECT that has the same WHERE
clause. This will show you
Matt,
Yes, database could be cleaned with a query, but I don't even want to think
about the code problem. I was being hyperbolic with the 500,000; it's
actually more like 50,000 lines of code - but still, who wants to change
50,000 lines of code. And yes, it's PHP.
However, as an update, I did
Could someone please tell me what is wrong with this query:
select * from personnel where dept_id not in (select dept_id from
attendance_respond)
I keep getting a 1024 error message. It looks pretty straightforward to me.
I am running 4.0.16 on Redhat Linux 8.
--
MySQL General Mailing List
At 2:28 PM -0500 11/17/03, Peter J. Krawetzky wrote:
Could someone please tell me what is wrong with this query:
select * from personnel where dept_id not in (select dept_id from
attendance_respond)
I keep getting a 1024 error message. It looks pretty straightforward to me.
I am running 4.0.16
Thanks Paul,
Just to be crystal clear, at the mysql prompt, I will typesource
stations.sql \.
E:\Apache\apache2\htdocs\public_html\weather\stations.sql
Looking something like this:
mysqlsource stations.sql \.
E:\Apache\apache2\htdocs\public_html\weather\stations.sql
Or am I not supposed
Hi Olaf,
try something like this:
AND gebdatum between now() and date_add(now(),interval 7 day)
However, I have no idea if this can be done with 3.23.49a.
--
Peter Sap.
- Original Message -
From: Olaf van Zandwijk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 17, 2003
At 2:42 PM -0500 11/17/03, Ola Ogunneye wrote:
Thanks Paul,
Just to be crystal clear, at the mysql prompt, I will typesource
stations.sql \.
E:\Apache\apache2\htdocs\public_html\weather\stations.sql
Looking something like this:
mysqlsource stations.sql \.
Hi Nathan,
you can use a group by, like this:
select all_columns from table group by all_columns
Put this result in a separate table, delete the data from the old table and
put the the merged rows from the separate table into it.
I tried using a DELETE with a subquery and a group-by, but MySql
Hello All,
Upon further review, my question involving the
unexpected comparison operator behavior IS discussed in
the documentation, specifically section A.5.7 Problems
with
Floating-Point Comparison. My bad -- thought I'd
checked everywhere.
Doesnt' look like there's a great solution,
Hi, I am installing a binary version of mysql 4.0.7, but I cannot get the mysql daemon
running. Mysqld ends right after I start it up.
I attached the command I use and the output. I also cut and pasted the output from the
log file.
I am on a Sun Sparc running Debian.
Any help would greatly be
do a ps -ef | grep mysql (or the equivalent for your system) and see if you
have any other mysql daemons running?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 2:40 PM
To: [EMAIL PROTECTED]
Subject: [Mysql] mysqld ended
Hi, I am
On Nov 17, 2003, at 12:40 PM, [EMAIL PROTECTED] wrote:
Hi, I am installing a binary version of mysql 4.0.7, but I cannot get
the mysql daemon running. Mysqld ends right after I start it up.
I attached the command I use and the output. I also cut and pasted the
output from the log file.
[...]
Can someone kindly tell me what I doing wrong and help with this query?
I want to replace / update the text for every record within table items field
ItemDescription. This is what I have so far and its isn't corroect :(
UPDATE items SET ItemDescription='A-Z Business Directory br /br / Please
you need to tell mysql what field to equate to the value in your where clause:
update items set ItemDescription = 'new text'
where ItemDescription = 'old text'
replacing the items with the text you have below
-Original Message-
From: Andrew [mailto:[EMAIL PROTECTED]
Sent:
On Monday 17 November 2003 01:18 pm, Andrew wrote:
Can someone kindly tell me what I doing wrong and help with this query?
I want to replace / update the text for every record within table items
field ItemDescription. This is what I have so far and its isn't corroect :(
UPDATE items SET
Hi,
As I remember : MySQL's programmers use windows tools for developing.
You can use Win32-MySQL without any problem.
But I suggest APACHE for PHP!
best regards
özgür
YÖNSIS ltd,
Istanbul
- Original Message -
From: Paul Fine [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday,
Worked like a dream Dan
Thanks Paul for being patient :)
Thank you
Andrew
-Original Message-
From: Dan Greene [mailto:[EMAIL PROTECTED]
Sent: 17 November 2003 21:27
To: [EMAIL PROTECTED]; Mikael Fridh; MySQL-Lista
Subject: RE: replace query + RTFM?
you need to tell mysql what field to
This one has had me scratching my head all afternoon.
I have a comma delimited text file that I am using to import data from a
legacy system into a MyISAM table. My server is 4.0.16 as is my client.
Both run on Redhat 8.0.
An example line of imput looks like
* Elisenda
[...]
So, the good way to write joins will be as follows, doesn't it?
FASE.SQL_ID_CE=CA.CA_ID_CE AND
FASE.PR_PP_ID_COORD=PP.PP_ID_PP AND
CA.CA_ID_CE=CE.CE_ID_CE AND
FASE.AU_PR_AULA=AU.AU_AULA
Those are the exact same criteria as you had, only in a different order,
isn't it? The
On Mon, Nov 17, 2003 at 10:10:52AM -0500, Andre Charbonneau wrote:
Hi,
Let say that I have the following transaction:
1. Read value v1 from table t1.
2. Do some computation using v1.
3. Update value v2 from table t2.
If in the above I don't want any other concurrent transaction to read
I executed the command:
fuser -n tcp 3306
and it returned:
3306/tcp: 187
I then ran ps -ef to find what program was using this port and I found
it was:
root 187 1 0 Nov13 ?00:00:00 /usr/sbin/inetd
Is it ok to kill this process ? If not, is there a way to
On Nov 17, 2003, at 4:13 PM, Matthew Hagen wrote:
I executed the command:
fuser -n tcp 3306
and it returned:
3306/tcp: 187
I then ran ps -ef to find what program was using this port and I found
it was:
root 187 1 0 Nov13 ?00:00:00 /usr/sbin/inetd
Is it ok to
I see the only message DB Error: unknown error. Even when I run
mysqld.exe with --log and --error-log options, I still cannot get a more
descriptive error message.
I guess the problem is because of the number of joins is too large or the
number of *temporary* rows is too large. But I don't
When I try to start the database with :
mysql -h host -u user -p
I get the response :
mysql: not found
What does this mean? Installation went smoothly as far as I could tell.
Also, when I try to start the database with :
bin/mysqld_safe --user=mysql
It starts the mysqld daemon from the
I keep on getting errors for saving table to an external file. I think
there is something wrong with the syntax. Could someone help me to correct
it ?
mysql mysqldump -r database table1;
Regards
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi, I have a performance issue I've tried resolving and I can't get rid
of it. Basically I have a database called lobby that any queries to it
must be as fast as possible inserts, and selects. It must do about 60
queries a second with no queries taking more then 50ms. I also have
another
mysqldump is a program like mysql not a command within mysql.
Bernard
On Monday 17 November 2003 21:46, Lay Hoon Tan wrote:
I keep on getting errors for saving table to an external file. I think
there is something wrong with the syntax. Could someone help me to correct
it ?
mysql mysqldump
- Original Message -
From: Kelley Prebil [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, November 17, 2003 9:33 PM
Subject: mysql: not found
When I try to start the database with :
mysql -h host -u user -p
I get the response :
mysql: not found
What does this mean?
Hi
I have a .txt file that is loaded into my table. This is done
using LOAD DATA INFILE
One of the columns data is a unix timestamp from the .txt file.
The column is called begin.
I have created the column as a varchar before
and then converted the date using FROM_UNIXTIME(), so it can be
I'm a newbie to MySQL so if this is a common question, forgive me, but I can't find an
answer.
How do I prevent data collision in the following scenario:
User A and User B are examining the same data (say a customer's name and address).
User A modifies something (say the customer's phone
1 - 100 of 104 matches
Mail list logo