Hello Sergei,
Tuesday, July 23, 2002, 10:17:06 PM, you wrote:
SG Hi!
SG On Jul 23, Artem V. Ryabov wrote:
Hello mysql,
see this 2 queries:
why they not equal?
why first skip many records?
mysql select left(ftText,20) from Txt_index where match(ftText)
against('+(wùd200206*) +wù12p'
HI,
I do not manage to open a table it puts me Can' t open takes off: '
pkf_as_events_log. MYD '. (Errno: 145) is what anybody has already had
this error on mysql?
Cordially
Florian
-
Before posting, please check:
Hi Scott,
you have to set the PATH variable.
PATH=/usr/local/bin:$PATH
in your profile.
Then the mysql_install_db runs.
-Ursprüngliche Nachricht-
Von: Scott Pippin [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 31. Juli 2002 21:17
An: [EMAIL PROTECTED]
Betreff: Installing MySQL
On Mon, Jul 29, 2002 at 12:15:50PM -0700, [EMAIL PROTECTED] wrote:
After many headaches, rantings, and emails, i have FINALLY figured out how
to get 64 indexes out
of MySQL tables.
[snip]
I think its a sad situation that i could find numerous references to using
64 keys, none
more
- Original Message -
From: Bart Burkhardt [EMAIL PROTECTED]
i get this error in mysql 3.23.51 with snortreport
(http://www.circuitsmaximus.com/download.html)
is this an mysql error or snortreport error ?
problem solved, i had to enable global environment=on in php.ini
so, no mysql
Mysql, SQL, etc.
Hi,
Does anyone have experience of compiling in large file support
for Linux ?
I just want to know what is the scope of the change: do I have to
recompile the kernel and every single library and application ?
thanks,
Martin
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:Thomas Raabe
Organization:
Thomas Raabe E-Mail: [EMAIL PROTECTED]
UNI-Kassel - HRZ-ABT II Tel: 0561-804-2285
Moenchebergstr. 11 - 34125 Kassel
Hi Lists,
I recently downloaded mysql-3.23.51-pc-linux-gnu-i686 from mysql.com for linux
platform.
I did the following.
Created group mysql
Created user mysql
Extracted the zip using gunzip to /usr/local/mysql-VERSION-OS/
cd /usr/local/mysql-VERSION-OS/
/configre --prefix=/usr/loca/mysql
To: [EMAIL PROTECTED]
From: Saravanan C [EMAIL PROTECTED]
Subject: From Saravanan, REC, INDIA
Date: Thu, 1 Aug 2002 13:05:17 GMT
-
Hi Lists,
I recently downloaded mysql-3.23.51-pc-linux-gnu-i686 from mysql.com for
linux
platform.
I did the following.
Created group mysql
I installed mysql version 3.23.51 on redhat 7.2
(but I had the same problem with version 3.23.49a)
I am not able to load data form text file
neather with the load command or with mysqlimport
The error message is
The used command is not allowed with this Mysql
version
I found some mail telling
Hi!
I tested MySQL 3.23.51 under Windows and 3.23.49 under Linux RedHat 7.3 with
such SQL:
select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS')
and recieved different results (of course, I used same config file with
case-sensitive configuration).
Result under Linux looks better,
What O/S are you using ... Win2k, WinXP, etc.?
- Original Message -
From: Shion D. Deysarkar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 31, 2002 11:15 PM
Subject: dos trouble
I'm trying to start up mysql through dos prompt. When I enter a
Blast! I _did_ ask Yast to install the file - for some reason it didnt go
on during the installation.
Ah well, you learn something new every day...
Many thanks for your time in helping me solve this one.
Regards
Andy
On Thu, 1 Aug 2002, Lenz Grimmer wrote:
-BEGIN PGP SIGNED
Colin,
what version of MySQL you are running and on what OS?
The assertion means there is an attempt to reference a pointer which does
not point to the buffer pool. It might be memory corruption or table
corruption.
If you have updated to new disk drives in Linux, best to check if there are
Very sorry for my childish question, I'm just starting to learn about MySQL
Following is my procedure in fixing the problem of installation on Intel PC,
and Linux RH7.3.
1. RPM installation
2. When execute mysql, there is a message ERROR 2002: Can't connect to
local MySQL server through socket
Hi,
I recomend you to use the pre-compiles binary
distribution. You won't have to build it and it worked
for me.
This is the link for the Intel platform:
http://www.mysql.com/downloads/download.php?file=Downloads/MySQL-3.23/mysql-3.23.51-pc-linux-gnu-i686.tar.gz
Bye and Good Luck.
---
well for one i think you need to make sure after doing mysql_install_db ,
you check the ownership of your diretory , is should be owned by
mysql.deamon, after that try and start mysql i think it should work after,
such errors are ususally due to ownership. hope this helps :)
ma 2cents
cheers
A field named change can't be created. Any other name is OK.
CREATE TABLE test (
change char(1) default NULL
)
SQL-query :
CREATE TABLE test ( change char(1) default NULL )
MySQL said:
You have an error in your SQL syntax near 'change
Hi, I am trying to upgrade to 4.02 from 3.23.47 on FreeBSD 4.6. The mysql
database does not want to work for some reason, when I move my old mysql
database over the new one, it does not start up, giving an error about
permissions even though the permissions of that directory are 770
mysql.mysql.
Original-Message-ID: [EMAIL PROTECTED]
Original-Sender: Chai Wutiwiwatchai [EMAIL PROTECTED]
Original-Subject: Please suggest some
Original-Date: Thu, 01 Aug 2002 19:52:59 +0700
A rule of thumb I always follow is to design the DB so that you don't
have to add columns (or modify the structure) unless something unforseen
comes up (like a new feature). In your case, you are expecting to add
variables in the future, so I would deign accordingly.
Use rows instead of
Check the files in the directory.
I bet they are not owned by mysql.
Cliff wrote:
Hi, I am trying to upgrade to 4.02 from 3.23.47 on FreeBSD 4.6. The mysql
database does not want to work for some reason, when I move my old mysql
database over the new one, it does not start up, giving an error
all of the files are chown -R mysql in that directory. Any other ideas?
- Original Message -
From: Gerald Clark [EMAIL PROTECTED]
To: Cliff [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 7:05 AM
Subject: Re: Problems When Upgrading to MySQL 4.02
Check the
Florian,
Thursday, August 01, 2002, 10:44:40 AM, you wrote:
FL I do not manage to open a table it puts me Can' t open takes off: '
FL pkf_as_events_log. MYD '. (Errno: 145) is what anybody has already had
FL this error on mysql?
Your table is corrupted. You shoulf repair it:
you could always try dropping a 'd' on the end of 'change'... as in
making the field 'changed' if it's a flag to see if the data has changed.
Gerald Clark wrote:
It is not a good idea to use reserved words for field names.
If you must, then use back ticks ( below the ~ on my keyboard) .
Hello,
In my web page I have MySQL retrieve information from
a database, and display it in a table. I would like to
make the results of the search selectable, as in, be
able to click on a field in my table and have it
preform a function. Here is the code for my table. I
would like
mysql show grants for nouveau@localhost;
+---
+
| Grants for nouveau@localhost|
+---
+
| GRANT USAGE ON *.* TO
I'm trying to start up mysql through dos prompt.
When I enter a
command
like c:\mysql\bin\mysqld or anything similar (any
command in the bin
directory), it just waits there. I can't Ctrl-C out
of it. I can end
the
process to get out. What's happening?
You just started the server. If you
Hello!
James MacLean wrote:
Hi Folks,
Have only known enough SQL to do what we needed.
Today on mysql-3.23.51 we found out that :
select something from table where index1 = 'value' or index2 = 'value';
Runs considerably slower than:
select something from table where index1 = 'value';
or
Tell me what you do
ADODB - OLEDB driver for ODBC - MyODBC - MySQL
ADODB - MyOLEDB - MySQL
or anything else?
first case: check don't promt on connect
Did you create a data source? (First thing you don't need to do...)
But whatever you do with VB, MS ADODB and MySQL - you will need time.
As a newcomer to MySql, I have struggled through the install and am working
my way through the tutorial.
My environment:
Win2000
MySql version 3.23.51-nt
My.ini:
[mysqld]
# set basedir to installation path, e.g., c:/mysql
basedir=c:/mysql
# set datadir to location of
Hello!
Saravanan C wrote:
To: [EMAIL PROTECTED]
From: Saravanan C [EMAIL PROTECTED]
Subject: From Saravanan, REC, INDIA
Date: Thu, 1 Aug 2002 13:05:17 GMT
-
Hi Lists,
I recently downloaded mysql-3.23.51-pc-linux-gnu-i686 from mysql.com for
linux
platform.
I did the following.
Home or Pro?
I have no experience with WinXP Home, but with WinXP Pro you need to
installed MySQL as a service, then start the service. After that, the
console will start with c:\mysql\bin\mysql
Instructions for installing as a service are in the MySQL Manual.
-Original Message-
From:
On Thu, 1 Aug 2002, Ralf Narozny wrote:
Hello!
James MacLean wrote:
Hi Folks,
Have only known enough SQL to do what we needed.
Today on mysql-3.23.51 we found out that :
select something from table where index1 = 'value' or index2 = 'value';
Runs considerably slower than:
select
When in MySQL in a terminal, if I enter the command source scriptfile.sql,
MySQL correctly executes the source file.
However, if using PHP, I execute the following commands in a PHP file:
?php
// data base is connected...
$query = source scriptfile.sql;
$result = mysql_query($query);
Hello:
I am getting NumberFormatException when getting Timestamp using ResultSet
class.
This occurs only if I run simultaneous threads. This doesn't happen if the
same
select query is not fired several times.
The application is currently using older version of JDBC driver
I was hoping to use the RPM distribution to install MySQL on my Linux machine.
However, I notice that it sets the data directory to /var/lib/mysql ... This is
unacceptable for my purposes... I know I can probably use a link to fix this, but I'd
rather do it the right way... How do I tell
Personally, I think one simple change would work wonders for the list:
adding a [mysql] ident at the beginning of each subject line. An EASY
change that would allow for MUCH easier sorting of the list into a
different folder. From there, you can thread it with (almost) any modern
mailreader..
Chai,
Thursday, August 01, 2002, 3:52:59 PM, you wrote:
CW Very sorry for my childish question, I'm just starting to learn about MySQL
CW Following is my procedure in fixing the problem of installation on Intel PC,
CW and Linux RH7.3.
CW 1. RPM installation
CW 2. When execute mysql, there is a
Caron,
Thursday, August 01, 2002, 5:34:16 PM, you wrote:
C mysql show grants for nouveau@localhost;
C +---
C +
C | Grants for nouveau@localhost|
C
Hello All,
First, Let me start by saying this question has most likely been asked
before, but I did a search in the archive and was unable to come up with
any results. I think this is because I am not quite sure what this is
called. So, I do apologize, but hopefully this can be answered
mysqlsms.sql
Also if you are inside the application
mysqlsource sms.sql
Bye and Good Luck!
--- Scott Pippin [EMAIL PROTECTED] wrote:
I need to run a file called sms.sql from the command
line. Is this
possible and what is the syntax?
Thanks in advance.
As a newcomer to MySql, I have struggled through the install and am working
my way through the tutorial.
My environment:
Win2000
MySql version 3.23.51-nt
My.ini:
[mysqld]
# set basedir to installation path, e.g., c:/mysql
basedir=c:/mysql
# set datadir to location of
James MacLean wrote:
On Thu, 1 Aug 2002, Ralf Narozny wrote:
Hello!
James MacLean wrote:
Hi Folks,
Have only known enough SQL to do what we needed.
Today on mysql-3.23.51 we found out that :
select something from table where index1 = 'value' or index2 = 'value';
Runs considerably
Yes, but when I create a user with any other grants, it generates
automatically this grant usage on *.*:
mysql use Liste_MP3;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql grant select on
Hi all--
I'm running a PHP/Apache/MySQL web app on a server. Specs are:
Slackware Linux v8.0
Kernel 2.4.16
Dual Athlon MP 1.2 GHz processors on a Tyan S2460 Mobo
1 GB registered ecc ram
I'm running MySQL 3.23.51-log, I believe, and it's the binary version for
x86 supplied by MySQL. The
That is because source is a mysql client command, not as sql command.
It gets executed by the client 'mysql'.
The 'mysql' client reads it line by line, and passes the lines to the
server.
The server never sees the scriptfile.sql.
You will have to write a PHP modules that reads the file, and
Hi Brent,
Thanks for the response. Currently, I have the variables listed out
in a table with one variable per row... something similar to the following:
++--+-
| ID | DimensionName|
++--+-
| 1 | units_length |
| 2 | units_temp |
| 3 |
p.s. PLEASE can you put a [mysql] tag on the list???
Please not, it wastes space on the screen.
not a lot of space - and does have the great advantage that we
can then filter out the mysql stuff into a separate mailbox whihc
(on standard UNIX mail) isnt possible without it.
-pcf.
on 8/1/02 11:32 AM, Victoria Reznichenko at [EMAIL PROTECTED]
wrote:
C Is there a way to create a user by giving access to only one database,
C without giving him the permission to mysqlshow --user=[thisuser]
C --password=[thispassword] and retrieve all database names? He should see
C only
I thought you were coming from some other database. I haven't heard
dimension since my FoxPro (on the Mac) days.
Since session data is temporary, you should use temporary tables to
store you session variables. Just use the real table to hold you
default values.
You want to do something like
If running two queries is running faster than perhaps the best way to do
it is select the first query into a temporary table and then insert
select the second to append to the temp table. Then you can select and
sort however you want from the temporary table.
create table tempname SELECT
On Wed, 2002-07-31 at 19:09, Troy Hakala wrote:
I decreased wait_timeout (from 28,800 to 300) to kill off sleeping threads.
This morning, the server stopped accepting connections and gave me this
error:
ERROR 1129: Host 'hostname' is blocked because of many connection errors.
Unblock
The way you store session values, as you said, can be troublesome when new
dimensions are added, or existing ones removed. Also it might be
constrained by some column limit. I'd try something like this,
+--++-+---+
| SESSIONID| UserID | DimensionID |
It's funny how terminology can be so confusing! When I say dimension,
I mean engineering-wise as in the distance from a to b.
Also, my use of session probably wasn't a good word in this
context. Our sessions are actually permanently stored, since
they are associated with a particular
Is anyone else seeing odd problems with heavy use of UNIONs on a MySQL
4.0.x server on FreeBSD?
I seem to be able to induce the problem on FreeBSD but not Linux. I
have a lot more testing to do yet, but if someone else is seeing it
that would really help to narrow the bug down.
Thanks,
Jeremy
On Thu, Aug 01, 2002 at 06:15:16PM +0200, Joseph Bueno wrote:
According to MySQL documentation, indexes are not used with OR:
http://www.mysql.com/doc/M/y/MySQL_indexes.html
You can't speed up your query by adding indexes.
Running 2 separate queries is the best you can do if you want to go
Michael Zelina wrote:
This is an interesting idea... I thought about doing this,
but the variety of data types prohibited me from doing so.
Initially, I was going to make everything VARCHAR(80)... but
that seemed to be horrible for data storage purposes and would
prevent me from being
Not sure if this is the correct list to be sending to but I am having
some very frustrating problems with mysql-3.23.51 on redhat 7.2
My problem is the db starts just fine using bin/safe_mysqld --user=root
although the crt seems to lock when I issue the command. After I hit
ctl+c and get back
Hi,
I've read the performance tuning tips for InnoDB
(http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit
when the log files are full and the buffer pool is checkpointed.
By 'geting bit', I mean for several minutes the db server basically
stops, and our website stops serving
I was wondering about the Enum and Set column types in InnoDB tables.
I was able to create an InnoDB table with an enum column, but i
get errors when trying to insert values into that column.
I'm thinking that InnoDB doesnt support those data types, but the MySQL
interface to InnoDB may have
Description:
The UNION clause displays results 2 times even when not using the
ALL keyword with it. example: (SELECT
I am performing a query along the lines of the following:
SELECT DISTINCT property.Internal_ID
FROM property, owner_names
WHERE property.Internal_ID = owner_names.Internal_ID
AND [ other conditions ]
ORDER BY owner_names.Name
Without the order by clause this is a pretty quick query, but with
On Thu, Aug 01, 2002 at 04:37:05PM -0500, Pete Harlan wrote:
Hi,
I've read the performance tuning tips for InnoDB
(http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit
when the log files are full and the buffer pool is checkpointed.
By 'geting bit', I mean for several
Thanks for your feedback (and your general untiring devotion to the
cause...)
On Thu, Aug 01, 2002 at 04:30:10PM -0700, Jeremy Zawodny wrote:
about what we can do to alleviate this? Instead of having three 150mb
log files, would we be better off with 30 15mb log files?
It shouldn't
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
| I am performing a query along the lines of the following:
|
| SELECT DISTINCT property.Internal_ID
| FROM property, owner_names
| WHERE property.Internal_ID = owner_names.Internal_ID
| AND [ other conditions ]
| ORDER BY
Okay, I thought I'd done this before but maybe not. I can't figure it out
now.
What I want to do is:
SELECT column AS something FROM table WHERE something 5
Basically I'm creating a new column called something and I want to use it to
compare with in the WHERE condition. Is this possible?
Hello everybody!
I just found out that something strange happend when I tried to subscribe to
this list. I was able to send my question but something wrong happend when
trying to subscribe. Therefor I was unable to see if I got any answers to my
question.
I would really appreciate if the people
Hello all,
Has anyone successfully gotten MySQL 4.02 running on Debian? I'm running
into problems if I use alien to convert the RPMs. I could install from
source, but I want to avoid cruftiness and make it easy to upgrade.
Basically, I run into conflicts with the package libmysqlclient10, but
Dear All,
My web host provider says that he cannot allow me to have a MySQL account
on the server. However, he asks me to set up my tables offline and ftp them
across and asses them using Php.
Can this be done?
Thank you.
Kindest regards,
Kenneth Gomez,
Engineering Analyst,
Compumod Sdn
Yes, Install mysql on a local box (same OS as your provider and preferably
the same MySql version), create and populate your tables and then FTP the
files that reside in the mysql data directory. There will be 3 files
associated with each table
.MYD (Data file)
.MYI (Index file)
.frm
On Fri, Aug 02, 2002 at 10:41:12AM +0800, Kenneth Gomez wrote:
Dear All,
My web host provider says that he cannot allow me to have a MySQL account
on the server. However, he asks me to set up my tables offline and ftp them
across and asses them using Php.
Can this be done?
Yes.
--
On Thu, Aug 01, 2002 at 09:50:33PM -0400, Quinten Steenhuis wrote:
Hello all,
Has anyone successfully gotten MySQL 4.02 running on Debian? I'm running
into problems if I use alien to convert the RPMs. I could install from
source, but I want to avoid cruftiness and make it easy to upgrade.
Newbie alert here...! Making my first attempt at changing a variable...
I am trying to add this line:
set-variable= safe_show_database=ON
To the my.cnf file... But when I do that and then attempt to restart MySQL,
it doesn't... Give the can't connect to the mysql.sock error.
This is on
Description:
When we join two or more tables, select distinct and order by on a
column, we get problems.
How-To-Repeat:
mysql select * from test;
+--+--+
| a| b|
+--+--+
|1 |1 |
|2 |2 |
I have done a lot of looking and search through archives of mailing lists
and newsgroups and I guess I haven't looked enough because I still haven't
found what I'm looking for. What I have is an Excel worksheet that had 26
fields and several hundred rows of data. The data types will be are INT,
Hi!
It's just a simple example, because I don't want send latvian-specific
symbols. This problem occurs with latvian-specific symbols only.
Configuration file I cheked some 4-5 times. I'm confused now.
Regards from Latvia!
Andis Grasis
- Original Message -
From: Victoria Reznichenko
77 matches
Mail list logo