Whenever you install someting like mysql on Linux RH you should consider
using RPM (Redhat Package Manager)
Go to the www.rpmfind.net and do a search for mysql
- Original Message -
From: "Javier Gonzalo Gloria Medina" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 06, 2
Hi friends,
I own a domain with MySQL support. I have created a database
"lnet_cal" on the web and also table "yarntype", using PHP Myad-
min on the webspace and also granted all access privileges to
user "lnet_root" to the database.
I had uploaded a PHP module on the web which is
Hi. I want to know why diminishes the response time when Inner Join
between two tables is used.
I do not have experience using MySQL
Carlos
_
MSN Fotos: la forma más fácil de compartir e imprimir fotos.
http://photos.msn.es/sup
Hi friends,
I own a domain with MySQL support. I have created a database
\"lnet_cal\" on the web and also table \"yarntype\", using PHP Myad-
min on the webspace and also granted all access privileges to
user \"lnet_root\" to the database.
I had uploaded a PHP module on the web whic
> Hi everybody:
> Well i have all redy work with mysql instalation on
> win xp = (, and for some reasons i migriate to
> linux.
>
> i follow the typical instalation of :
>
> making the user and group for mysql. ok
> configurate the ./config stuff with the
> --prefix=/usr/local/mysql
> then when
Hi everybody:
How would like to answer some newbie questions ?
Well i have all redy work with mysql instalation on
win xp = (, and for some reasons i migriate to linux.
i follow the typical instalation of :
making the user and group for mysql. ok
configurate the ./config stuff with the
--pre
Paul Flint <[EMAIL PROTECTED]> wrote:
> > > Hello,
> > >
> > > I have a bunch of text with Japanese in it that uses shift_jis encoding.
> > > My initial tests show that this encoding has the same problems in MySQL
> > > as it does in Perl: it gives false matches.
Joel Rees <[EMAIL PROTECTED]> w
one way is to create a file in /usr/local/mysql/data OR wherever you
data dir is named "my.cnf" with the following contents
[mysql]
local-infile = 1
On Friday, July 5, 2002, at 02:13 , Bin Zhang wrote:
> Thanks for the pointer. Anyone know how to make phpMyAdmin to work
> around this new "fe
>Description
Following the instructions in section 5.2.8 to create a table using LOAD
DATA INFILE but without its indexes still causes the indexes to be
created at the end of the LOAD DATA INFILE statement
>How-To-Repeat:
The following shell script demonstrates the problem. There are two directory
Thanks for the pointer. Anyone know how to make phpMyAdmin to work
around this new "feature"? Thanks.
Bz
On Fri, 2002-07-05 at 10:14, hcir wrote:
> starting with version 3.23.49, load data local is dis-abled
>
> see this URL for more info
>
> http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html
>>MySql won't report case mismatches as errors.
MySQL can be configured to convert all table names to lower case on storage and
lookup. Add the line:
set-variable = lower_case_table_names=1
to my.ini (or my.cnf)
-Original Message-
From: William R. Mussatto [SMTP:[EMAIL PROTE
Hi.
Export it as CSV file and import it to MySQL, e.g. using LOAD DATA
INFILE.
Greetings,
Benjamin.
On Fri 2002-07-05 at 13:26:26 -0800, [EMAIL PROTECTED] wrote:
> is there a way to import a large excel spreadsheet into mysql? thanks.
>
> chris.
>
--
[EMAIL PROTECTED]
--
Okay, here is a possible solution, you will have to
try it to see if it is successful. It is based on the
fact that a table can be joined to itself.
select b.book_title,ba.publisher_code AS Author,
bb.publisher_code AS Publisher
from books b, basic_data ba, basic_data bb
where b.author
is there a way to import a large excel spreadsheet into mysql? thanks.
chris.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hi guys
I just managed to install mysql... yippy
But, i had to use the '--force option' when executing the
/usr/local/mysql/scripts/mysql_install_db .
I got a message saying that i needed to configure the hostname latter on.
So, now that mysql is isntalled i need to set up the hostname stuff.
I'm a new user with both MySQL and MySQLGU, so this question may be very
simple. When I save query results in MySQLGU, the file shows a MIME file
with a .res extension. I haven't found a program which can open and
directly use the information. Can you help?
Thanks so much.
Gary Simmons
Genera
On 5 Jul 2002, at 18:27, Dillon, John wrote:
> Can I just check: should it be OK to do multiple INNER JOINs like
> this:
>
> SELECT * FROM (((table1 INNER JOIN table2 ON table1.anyfield =
> table2.anyfield) INNER JOIN table3 ON table3.anyfield=table2.anyfield)
> INNER JOIN table4 on table4.anyfi
Is it possible to do two temporary tables for authors and publishers and
then do a join on the title?
-Original Message-
From: Jed Verity [mailto:[EMAIL PROTECTED]]
Sent: 05 July 2002 21:01
To: '[EMAIL PROTECTED]'
Subject: Re: R: Query problem
I see. Sorry I misunderstood you. You're st
starting with version 3.23.49, load data local is dis-abled
see this URL for more info
http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html
> I upgraded my redhat to 7.3, which comes with mysql 3.23.49. Since
> then, I am no longer able to upload data files into mysql databases.
>
> This is what
GRANT SELECT ON DB.TABLE TO serf@'%' IDENTIFIED BY 'readonly';
I did "flush privileges", but still can't acess DB.TABLE with 'serf'
unless I use GRANT statement that includes hostname of client from which
I am executing command. I get this error using "serf@'%'":
* connect() SQLException: ja
I see. Sorry I misunderstood you. You're stuck with a similar problem here,
though. That is, you want to dynamically create columns (fields). Which can
be done, of course, as long as you have the privileges and you're willing to
divide up your query into at least 3. It sounds like you don't have
p
Hello, I need some advice regarding a scrolling list that I've built
from a query. I can generated the scrolling list just fine, but when I
try to put the subroutine within a table (cell), all I get is a hash
reference:
-+-+
Date
I upgraded my redhat to 7.3, which comes with mysql 3.23.49. Since
then, I am no longer able to upload data files into mysql databases.
This is what I got:
The used command is not allowed with this MySQL version
I think the "used command" here is referring to "load data local
infile". Has a
Is it possible to run replication on tables that are updated with user
vars?
Example:
SET @id = 1; does not show up in binlog!!
INSERT INTO table SET id = @id;
Now, on the master it works fine. The slave fails because the SET does
not seem to show up in the binlog, @id is not set, and the
I apologize to everybody, I wasn't very clear submitting my problem - Italian ->
English :-)
I try to give you an example:
table BOOKS
+-+++
| author_code | publisher_code | book_title |
+-+++
| 1 |
Hi Guys,
I am a newbie to MySQL administratation. I just
setup MySQL in my linux machine and want to change the
data directory from /var/lib/mysql to something else.
I put the .my.cnf file in the /etc/ directory and
specified the parameter datadir=/home/mysql but it
gives me an error invalid o
Hello, Gigi,
By "decoded", do you mean that you want the words "Author" and "Publisher"
to appear in your table instead of "1" and "2"? And you can't create or
modify tables? Short of replacing the codes in the columns, it seems to me
that you'd need to have a decode table. Something like:
+
I do have configured MyODBC-3.51/unixodbc-2.2.1 on a Mandrake 8.0
(recently updated) distrib.
I think it should not be a problem to install it on 8.2
Start to install unixODBC:
I managed to build unixODBC without the hard-to-compile GUI (the GUI
requires too much libs for my taste...)
I achiev
Hello list.
I have to interface a database, which I cannot modify because it is maintained
somewher else, where there are two tables:
BOOKS
author_code
publisher_code
book_title
BASIC_DATA
code
description
record_type
In the table BASIC_DATA records are classified on the flag value:
flag=1 ->
Can I just check: should it be OK to do multiple INNER JOINs like this:
SELECT * FROM (((table1 INNER JOIN table2 ON table1.anyfield =
table2.anyfield) INNER JOIN table3 ON table3.anyfield=table2.anyfield) INNER
JOIN table4 on table4.anyfield=table1.anyfield) WHERE...
Regards,
John
sql,query
Forgive me the wrong addressing - I didn't observed
that.
Yes I used same connection all the time. I am a
SQL-newbee and I suspect that the problem is the
installation or configuration.
I use Windows 2000 Pro, MySQL 4.0.1-alpha-max-nt and
MySQL-Front 2.2
The MySQL-server and the client are inst
Does your server support .jsp pages?
Does your version of dreamweaver support editing .jsp pages?
If yes to both questions, you can install a copy of MySql on your
development box and develop there and move the pages up when you are
ready to go live. Make sure both databases have the same stru
Hello list.
I have to interface a database, which I cannot modify because it is maintained
somewher else, where there are two tables:
BOOKS
author_code
publisher_code
book_title
BASIC_DATA
code
description
record_type
In the table BASIC_DATA records are classified on the flag value:
flag=1 ->
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 05 July 2002 17:13
To: Dillon, John
Subject: Re: RE: JOIN specific fields from two tables
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the fil
Hi!
In upcoming 3.23.52 you can put
SET NO_FOREIGN_KEY_CHECKS=1;
at the start of your dump file. Then you can import your tables in any
order. This syntax is not yet in 4.0.2.
4.0.2 will be released probably next week, 3.23.52 a few days later.
Best regards,
Heikki Tuuri
Innobase Oy
---
Inno
Outline what you want to join and your table structures and perhaps someone
can give you an example or two.
- Original Message -
From: "Dillon, John" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 05, 2002 11:49 AM
Subject: JOIN specific fields from two tables
> Can I/h
Hello!
If you are using Unix/Linux you might want to 'nice' the mysqld
processes or raise the priority of your more important services.
Greetings
Ralf
Edwin Wang wrote:
>I want to find a way to limit how much of a system processor (cpu) the
>mysql server will use, so that I don't run the ris
Hello,
If your main concern is spider-bots, why not use a (possibly dynamic!)
robots.txt file?
-Message d'origine-
De : Edwin Wang [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 4 juin 2002 17:53
À : [EMAIL PROTECTED]
Objet : how to limit the cpu usage in MySql
I want to find a way to limit
Hello Ruda,
Friday, July 05, 2002, 4:05:03 PM, you wrote:
Please, send your questions in the maling list, not only me.
RG> Hello Egor,
RG> I get NO result when i run the whole code.
RG> If I run the create-statement once more I was told
RG> that the table already exists and that is not a
RG> sur
Ian,
Friday, July 05, 2002, 4:11:37 PM, you wrote:
IH> Every time we move our database onto new hardware (ie. Pentium 4) we get
IH> errors 127 and 134 within the mysql error logfile. When we then run the
IH> check (i.e. CHECK TABLE tablename EXTENDED) on the databases the status
IH> comes back as
Can I/how do I SELECT specific fields from different tables with a JOIN
query. The documentation only refers to selecting all the fields.
Regards,
John
CONFIDENTIAL: This e-mail, including its contents and attachments, if any, are
confidential. If you are not the named recipient please noti
I want to find a way to limit how much of a system processor (cpu) the
mysql server will use, so that I don't run the risk again of having
googlebot or other web robots interrupt my other server operations in my
computer.
Thank you
Edwin
Ok, well, I thought this was going to help me with my problem, but
unfortunately, it didn't. That's not to say that the answer was
incorrect. Here's what I'm trying to do (with a little background).
I run a stats page for SETI@Home. It's mySQL driven, with perl
generating static html pages. I
Hi all,
I am trying to couple Openoffice.org to MySQL using ODBC. Does anybody
have an odbc driver functioning on a mandrake 8.2 linux machine? If so
please tell me how to do it.
Kind regards,
Bas Mooyman.
-
Before posting
I can't upload my sql query to my remote MySQL database.
I'm using Dreamweaver and need to use a database for a few pages. My
hosting doesn't allow for "remote Sql connections". What do I need to do?
-
Before posting, please
Antigen for Exchange found then.pif infected with Win32.Klez.H
(CA(Vet),Sophos,McAfee4) worm.
The message is currently Purged. The message, "Left panel of the Identify
window.", was
sent from mysql and was discovered in IMC Queues\Inbound
located at ITS/CBA-JKTCilandak/ITSJKTCB03.
-
Solsberry, Glendon wrote:
> Is there a way to select some data from a table where the date field is
> the MIN() of that date column? Aka, if I have 100 rows of data, and the
> MIN() date is 1/1/2000, then I want to select the data that is from
> 1/1/2000. Can this be done without doing a multi-t
How about:
select some_data from the_table order by the_date ASC limit 1
?
-Message d'origine-
De : Solsberry, Glendon [mailto:[EMAIL PROTECTED]]
Envoye : vendredi 5 juillet 2002 16:52
A : [EMAIL PROTECTED]
Objet : MIN/MAX Date Field
Is there a way to select some data from a table whe
Thanks for your reply, but my problem is not solved by your suggestions:
> mysql>> select *,max(cb) from testb left join testa using (ca) group by
> > testb.ca;
> This query selects all the fields from testb (ca, time) AND
> testa (ca, cb) because of the LEFT JOIN you used. You should
> try spec
I am not sure if I understand your issue, but if the
tables have been updated in the local computer is
because you did not connect to the server. With
mysqlimport you can specify the host (-h), the user
name and password.
I think that you should use something like:
mysqlimport -hMYSERVER -pMYUSE
Is there a way to select some data from a table where the date field is
the MIN() of that date column? Aka, if I have 100 rows of data, and the
MIN() date is 1/1/2000, then I want to select the data that is from
1/1/2000. Can this be done without doing a multi-table join, or is that
the only way
Hi..
I have a client that's been writen in GUPTA and compiled to be used as a
cliento to an SQL database that i access using my local Lan and Netbios..
I want to port that client software (i have the source code for the Gupta
Cliente) to be used in a PHP server to allow acces to the database fro
Hi,
=== Question No.1 ===
mysql>> select *,max(cb) from testb left join testa using (ca) group by
> testb.ca;
> +--++--+--+-+
> | ca | time | ca | cb | max(cb) |
> +--++--+--+-+
> |2 | 20020705145347 |
Hello! :)
I'm wondering which table type is better and why for
web project with about 100 000 customers. May be
InnoDB gives better query performance? I'm using now
MyIsam, but is this better idea to move to InnoDB?
Thank you! :)
__
Do You Yahoo
I'm trying to execute a statement which will allow access to a table by
a user from *any* client on the Internet. I enter something like this:
GRANT SELECT ON DB.TABLE TO serf@'%' IDENTIFIED BY 'readonly';
Yet, I'm unable to access DB.TABLE unless I replace '%' with the
hostname of the client
At 06:28 AM 7/5/2002, you wrote:
>Hello! :)
>
>I'm wondering which table type is better and why for
>web project with about 100 000 customers. May be
>InnoDB gives better query performance? I'm using now
>MyIsam, but is this better idea to move to InnoDB?
>
>Thank you! :)
In addition to Steve's c
Hi,
After every modification in mysql.user table you must do:
"FLUSH PRIVILEGES;"
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Me
Hi friends,
I own a domain with MySQL support. I have created a database
"lnet_cal" on the web and also table "yarntype", using PHP Myad-
min on the webspace and also granted all access privileges to
user "lnet_root" to the database.
I had uploaded a PHP module on the web which is
Depends on the client you are using.
If you are using the command line client under unix (and possibly Windows,
I've never tried it) Put your SQL code in a file. Then type
mysql < filename
Assuming you have a .my.cnf setup with your login and password, and you have
permission to create databa
If you are not using auto_increment for referential integrity, you could
dump your table structure,export all cols but your auto increment, drop your
table and re-import your table structure and data. Your idea should also
work if you run an ALTER TABLE and DROP INDEX first, then your UPDATE, th
Every time we move our database onto new hardware (ie. Pentium 4) we get
errors 127 and 134 within the mysql error logfile. When we then run the
check (i.e. CHECK TABLE tablename EXTENDED) on the databases the status
comes back as being OK. Should we believe this, or do we still need to run
the re
Ruda,
Friday, July 05, 2002, 9:41:18 AM, you wrote:
RG> I am new to MySQL and to learn how to use it I am
RG> studying examples from
RG> http://www.mysql.com/doc/e/x/example-Maximum-column-group-row.html
RG> The following code does not work for med:
[skip]
RG> Perhaps I must add some informati
Hi.
Hope I've got the list sorted out right - I'm sure someone will tell me
if not. ;)
Has anyone got any good ideas or examples for doing version control on
changes to fields in MySQL tables? In many tables I'd like all changes
to fields to be recoverable back to any date-time in the past, w
It all depends if you need to use transactions. If you are entering items
from a cart into a database you may want to use transactions to make sure
ALL items get written correctly before you actually commit the changes to
the database. With InnoDB tables you can use transactions so if one or all
i
Every time we move our database onto new hardware (ie. Pentium 4) we get
errors 127 and 134 within the mysql error logfile. When we then run the
check (i.e. CHECK TABLE tablename EXTENDED) on the databases the status
comes back as being OK. Should we believe this, or do we still need to run
the re
Bas,
Thursday, July 04, 2002, 9:43:07 PM, you wrote:
BM> When I start mysqlgui on my mandrake 8.2 machine the program starts, but
BM> I get an error message:
BM> Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2)
BM> I don't know what to do and I cannot acces the help file o
Gianni,
Friday, July 05, 2002, 2:28:00 AM, you wrote:
G> Hello. I'm going to be crazy. But why I can't run myslq 3.23.51? I found this
G> error also in mysql 3.23.49, but no in mysql 3.23.41 that worked well: it
G> runs.
G> The error is clear:
G> root@linux:/usr/local/mysql > bin/safe_mysqld &
Whoa, back the bus up. Did you actually PAY for a support contract?
If so, then you left this very important fact out of you message. If you
did not then you also did not RTFM because it tells you that the product is
FREE, use it at your own risk and don't bother MySQL AB with questions, post
th
Hi.
I run mysql 3.23.51-max-nt on a PIII 800-8 users.I just turned LOG and
LOG-UPDATE on because I have problems with the user-application that
interacts with the database.I don't know what is happening but the
application CRASHES frequently and i just want to see what is happening through the
69 matches
Mail list logo