Re: Permission Denied for INSTALL-BINARY

2005-02-09 Thread Olivier Kaloudoff
On Wed, 9 Feb 2005, Mark Sargent wrote: Hi All, using Fedora2 and trying to install from a .tar file. Extracted to this dir, mysql-standard-4.1.9-pc-linux-gnu-i686 where I see the INSTALL-BINARY file. Using this cmd, ./INSTALL-BINARY gives the following error, [EMAIL PROTECTED]

Re: Difference between 'LIKE' and '='

2005-02-09 Thread Gabriel PREDA
| But I have a question: is there any difference between the following? | SELECT lname, fname FROM contacts WHERE lname = 'smith'; | SELECT lname, fname FROM contacts WHERE lname LIKE 'smith'; | Sincerely, | -Josh My gut hunch is that if your LIKE expression is going to contain no

Re: mysqld error

2005-02-09 Thread Gabriel PREDA
I am trying to get mysql working on my Windows ME machine. When trying Server\bin\mysqld unknown option '--enable-named-pipe' MySQL version 4.1.9. Any help greatly appreciated. Dick WinME does not support named pipes... so neither mysqld... so you should remove from my.cnf or my.ini

Re: Query problem

2005-02-09 Thread DanielWalker
On Tuesday 08 February 2005 17:03, Coz Web wrote: This will (as I believe Daniel suggested) keep things relatively simple, avoiding an overly complex query that you cannot maintain in the future. Well, my solution was, as you'll have observed, vastly over-complicated. I think I'd

Re: Problems with decimal numbers

2005-02-09 Thread DanielWalker
On Tuesday 08 February 2005 21:11, Stephane Pinel wrote: Hello, When I try to insert decimal numbers like 12857.59, 13858.58 or 14785.60, they are inserted as 12857.58, 13858.57 and 14785.59 ?! DataType is DECIMAL 10,2 Any idea of a way to avoid this annoying issue ? Thanks. Regards.

Random 1036 Table XXX is read-only

2005-02-09 Thread Sergey
After upgrading mysql server from 4.1.3beta to 4.1.9 (FreeBSD 4.8, mysql is installed from ports) I sometimes have the following problem: when some perl client tries to execute INSERT or UPDATE query via DBD::mysql it from time to time (but NOT always ) gets error 1036 (Table

bcc with mysql

2005-02-09 Thread unni krishnan
hi, I want to connect to mysql using borland c. The version is bcc5.0 and for mysql it is mysql4.0.13 The compilation is ok... but its showing linker error like unresolved external mysql_init referenced from module ... what is the problem??? How to specify the correct library...

backup/synchronize tables/db web-local server

2005-02-09 Thread Paul Godard
Hi I use mysql/php on several client web sites (each client has its own db). For development purpose, I have a local web server with php/mysql. When a web site is still in development, this is the master db, even if a copy has been uploaded on the live web server at my isp. When a site is

RE: SELECT DISTINCT Problem

2005-02-09 Thread Boyd E. Hemphill
People, including me, often expect the wrong thing from SELECT DISTINCT, May suggest you do the following: Create table temp_tb_spots as Select * from tb_spots where aired_station = '??' ; select distinct Date from temp_tb_spots group ; In a different window run Select Date from

Re: backup/synchronize tables/db web-local server

2005-02-09 Thread Coz Web
On Wed, 9 Feb 2005 13:10:16 +0200, Paul Godard [EMAIL PROTECTED] wrote: Hi I use mysql/php on several client web sites (each client has its own db). For development purpose, I have a local web server with php/mysql. When a web site is still in development, this is the master db, even if a

Memory limit?

2005-02-09 Thread Batara Kesuma
Hi, I try to install MySQL 4.1.9 (official RPM from mysql.com). My machine is running linux 2.6.9, and it has 4GB of RAM. The problem is MySQL won't start if I set innodb_buffer_pool_size to = 2GB. Here is my ulimit. [EMAIL PROTECTED] mysql]# ulimit -a core file size (blocks, -c) 0 data

Qcache and read data from master

2005-02-09 Thread Olivier Kaloudoff
Hi, I noticed the following behaviour on mysql 4.1.8 and two servers; to setup replication, I did the required grant on the master, and choose to use LOAD DATA FROM MASTER on the slave. As we monitor the Qcache usage on the master, it happend that Qcache was reset to 0 Queries

Performance of Sockets vs. TCP/IP connections on localhost?

2005-02-09 Thread Lasse Laursen
Hi all! Simple question: What is fastest when doing a connection to a local machine? TCP/IP or connecting via the socket? the application is a ACL helper program under Squid which makes a persistent connection to the database (100 parallel programs runs on the machine each connecting to the

Re: Qcache and read data from master

2005-02-09 Thread Victor Pendleton
I believe it may be because the tables in the Query cache have been modified causing the cached results to become invalid. Olivier Kaloudoff wrote: Hi, I noticed the following behaviour on mysql 4.1.8 and two servers; to setup replication, I did the required grant on the master, and

slow query, how can i imporve it?

2005-02-09 Thread Shailendra Soni
Hi, I have a question regarding speed of the query. In my application i am useing Mysql 4.0.20a-nt. I have 10 tables and each table contains 400 records and also 61 columns. I already created indexs on six column which are important for me. i fired the query on tables through

Re: Performance of Sockets vs. TCP/IP connections on localhost?

2005-02-09 Thread Alec . Cawley
Lasse Laursen [EMAIL PROTECTED] wrote on 09/02/2005 13:24:27: Hi all! Simple question: What is fastest when doing a connection to a local machine? TCP/IP or connecting via the socket? the application is a ACL helper program under Squid which makes a persistent connection to the database

RE: slow query, how can i imporve it?

2005-02-09 Thread Jay Blanchard
[snip] I have a question regarding speed of the query. In my application i am useing Mysql 4.0.20a-nt. I have 10 tables and each table contains 400 records and also 61 columns. I already created indexs on six column which are important for me. i fired the query on tables through

Re: Memory limit?

2005-02-09 Thread Tobias Asplund
On Wed, 9 Feb 2005, Batara Kesuma wrote: Hi, I try to install MySQL 4.1.9 (official RPM from mysql.com). My machine is running linux 2.6.9, and it has 4GB of RAM. The problem is MySQL won't start if I set innodb_buffer_pool_size to = 2GB. Here is my ulimit. Are you trying this on a 32-bit

Re: backup/synchronize tables/db web-local server

2005-02-09 Thread Coz Web
On Wed, 9 Feb 2005 15:48:12 +0200, Paul Godard [EMAIL PROTECTED] wrote: On Wed, 9 Feb 2005 13:10:16 +0200, Paul Godard [EMAIL PROTECTED] wrote: Hi I use mysql/php on several client web sites (each client has its own db). For development purpose, I have a local web server with

Re: Merge vs multiple innodb performance

2005-02-09 Thread SGreen
Marcin Lewandowski [EMAIL PROTECTED] wrote on 02/08/2005 05:29:39 PM: Chuck Herrick napisa(a): 200 - 400 tables is too many. Is it too many for merge, innodb or both? Try having one CUSTOMERS table. You know who is logged in, so you can use that information in a WHERE clause. Yes,

Re: Problems installing MySql...

2005-02-09 Thread SGreen
Steve Grosz [EMAIL PROTECTED] wrote on 02/08/2005 06:04:48 PM: I already have a version of MySql 4.1.17 running on a different server, but am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's software. I'm finding that 4.0.23 isn't as easy to set up as the later versions.

Re: Multiple table join help

2005-02-09 Thread SGreen
E SA [EMAIL PROTECTED] wrote on 02/08/2005 06:40:40 PM: All, I have done some reading and research; however, I seem to be at a loss... And this time, I am not sure how to ask Google... Here is the problem: Table A: id INT valuevarchar (10) Table B: id

Re: slow query, how can i imporve it?

2005-02-09 Thread SGreen
Shailendra Soni [EMAIL PROTECTED] wrote on 02/09/2005 08:28:36 AM: Hi, I have a question regarding speed of the query. In my application i am useing Mysql 4.0.20a-nt. I have 10 tables and each table contains 400 records and also 61 columns. I already created indexs on six column which

Re: backup/synchronize tables/db web-local server

2005-02-09 Thread Coz Web
The mySQL command should read : mysql -u username -p[password] db_name dumpfile Note that you can give the password on the command line but it is best to get into the habit of just providing -p and typing in the password when prompted. BTW, when doing the mysqldump for tables that already

How to log some queries and not others

2005-02-09 Thread George Chelidze
Hello, I have the following problem: I have a table with a blob field and turned on query logging. I'd like to log every query except inserts into table with a blob field because my log files grow very fast and I don't like to see binary data in my log files, while other logs are very

Aes Encryption

2005-02-09 Thread love
Hi, Aes Encryption requires a password (key) to access data, now where do we store this key? with the source code ? or in seperate database ? because any body who has the access to souce code can view the critical info or even if you store passwords in another database then it is not a big

key on the month portion of a date field

2005-02-09 Thread Gabriel B.
Short Version: is there any way to make an index for a date field that appears in the WHERE as a MONTH() argument? I have a table with some hundreds of thousands of rows already, and now i have the need to show upcoming birthdays to some users. the query uses WHERE MONTH(birthday).. the

Re: key on the month portion of a date field

2005-02-09 Thread love
use below: alter table table_name add index (birthday); Love Kumar .. [EMAIL PROTECTED] wrote: Short Version: is there any way to make an index for a date field that appears in the WHERE as a MONTH() argument? I have a table with some hundreds of thousands of rows already, and now i have the need

Re: key on the month portion of a date field

2005-02-09 Thread Gabriel B.
On Wed, 09 Feb 2005 17:24:10 +, love [EMAIL PROTECTED] wrote: alter table table_name add index (birthday); But would that index improve this kind of query? the docs talk about only direct matchs, like birthday now() or birthday between x and y. They're all full date values. -- MySQL

Re: key on the month portion of a date field

2005-02-09 Thread Paul DuBois
At 15:37 -0200 2/9/05, Gabriel B. wrote: On Wed, 09 Feb 2005 17:24:10 +, love [EMAIL PROTECTED] wrote: alter table table_name add index (birthday); But would that index improve this kind of query? the docs talk about only direct matchs, like birthday now() or birthday between x and y.

breaking session start/stop datetime records on time/day bounds

2005-02-09 Thread Dean Karres
Hi, I have a table full of activity records. Each record has a DATETIME field for when the activity started and one for when it ended. I want to post process this table and produce billing records from it. Billing records will have a link back to the activity record that produces them; i.e.

Re: key on the month portion of a date field

2005-02-09 Thread Gary Richardson
On Wed, 9 Feb 2005 15:17:36 -0200, Gabriel B. [EMAIL PROTECTED] wrote: It is not too slow this way since i started the WHERE with lots of checks that cuts down to a medium of 200 rows that actualy gets to this check, but i feel uncorfotable to not use a index. Isn't there a limit of 1 index

Test Message

2005-02-09 Thread David Griffiths
Our mail server has been stopping emails to the list. This is a test message to see if it bounces again. Please ignore (and accept my apology for generating noise). David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: backup/synchronize tables/db web-local server

2005-02-09 Thread Karam Chand
SQLyog Enterprise's Database Sync Tool is the answer for your queries. www.webyog.com Rgds, Karam --- Paul Godard [EMAIL PROTECTED] wrote: Hi I use mysql/php on several client web sites (each client has its own db). For development purpose, I have a local web server with php/mysql.

Re: backup/synchronize tables/db web-local server

2005-02-09 Thread love
It is very easier with mysql replication concipt, this automatic replication from Master server to Slave server and real time. I wonder how you do not know about this. http://dev.mysql.com/doc/mysql/en/replication.html Love kumar .. [EMAIL PROTECTED] wrote: SQLyog Enterprise's Database Sync

Re: breaking session start/stop datetime records on time/day bounds

2005-02-09 Thread SGreen
Dean Karres [EMAIL PROTECTED] wrote on 02/09/2005 12:46:46 PM: Hi, I have a table full of activity records. Each record has a DATETIME field for when the activity started and one for when it ended. I want to post process this table and produce billing records from it. Billing records

Re: key on the month portion of a date field

2005-02-09 Thread Greg Fortune
Remember, a low cardinality index will possibly be ignored by the optimizer and an index on month will never have a cardinality of more than 12. For testing purposes, you might try added a column for month and populating it off your current data. update the_table set

Re: How to log some queries and not others

2005-02-09 Thread DreamWerx
Cron hack? have a console running: tail -f hostname.log | grep tablename filter.log -or- tail -f hostname.log | grep -v insert into blobtablename filter.log then have a cronjob every X minutes running: echohostname.log To truncate the full querylog from getting too big? Not

Re: bcc with mysql

2005-02-09 Thread Marcin Lewandowski
unni krishnan napisa(a): hi, I want to connect to mysql using borland c. The version is bcc5.0 and for mysql it is mysql4.0.13 The compilation is ok... but its showing linker error like unresolved external mysql_init referenced from module ... what is the problem??? How to specify

Re: How to log some queries and not others

2005-02-09 Thread Paul DuBois
At 19:52 +0300 2/9/05, George Chelidze wrote: Hello, I have the following problem: I have a table with a blob field and turned on query logging. I'd like to log every query except inserts into table with a blob field because my log files grow very fast and I don't like to see binary data in my

Re: backup/synchronize tables/db web-local server

2005-02-09 Thread Karam Chand
Well I know about it and I am working on MySQL Replication, the point is that you dont have control over replicatation when your MySQL server is installed by your ISP on shared server, In that case it is simply not possible :) Moreover, the simple setup I have, I prefer this then the

Warning: V3 DSA signature: NOKEY, key ID 5072e1f5

2005-02-09 Thread Chuck Herrick
When I RPM upgrade MySQL on Fedora Core 3 from the installed version 3.23 to version 4.1.9, the rpm command yeilds the following warning: Warning: VMySQL-server-4.1.9-0.i386.rpm: 3 DSA signature: NOKEY, key ID 5072e1f5 What does this mean? Should I ignore this warning? Should I expect

Re: Problems installing MySql...

2005-02-09 Thread SGreen
reconstituted from a munged response (original post) Steve Grosz [EMAIL PROTECTED] wrote on 02/08/2005 06:04:48 PM: I already have a version of MySql 4.1.17 running on a different server, but am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's software. I'm finding that

Re: Copying Database from One Hard Drive to Another

2005-02-09 Thread David Blomstrom
Yikes...I've been replying to myself! I forgot that when I reply to messages from the MySQL newsgroup on this e-mail account, it doesn't include mysql@lists.mysql.com, for some odd reason. At any rate, I wanted to say that I have just ONE file type left - FRM. My MYD and MYI files have both

Re: Copying Database from One Hard Drive to Another

2005-02-09 Thread Victor Pendleton
InnoDB files can not be copied from one machine to another like the MyISAM files. If you did not dump the data or you do not have an archived backup you will more than likely have to recreate the table structures. David Blomstrom wrote: Yikes...I've been replying to myself! I forgot that when

Re: Problems installing MySql...

2005-02-09 Thread SGreen
Steve Grosz [EMAIL PROTECTED] wrote on 02/09/2005 03:43:22 PM: I downloaded the MySql Administrator and simply run that. and dragged the icon to the startup menu so it loads MySql on startup. Not entirely sure how to load MySql as a 'service' on Win2003 Server. The only message I get, and

Slow Replication

2005-02-09 Thread Hannes Rohde
Hi all, We use MySQL as a database backend on a portal site. We have a two database server setup (one master, one slave). The master is a PIV 3,2 GHz., 2 GB Ram and a 80GB Raid-1 system. The slave is a PIV 3.2 GHz., 4 GB Ram and a 80GB Raid-0 system. Both run on MySQL 4.1.9 and only use

RETURNING Keyword?

2005-02-09 Thread Justin Burger
Good Afternoon, In Oracle there is a keyword called RETURNING, where I can do an insert and specify what row to return, this helps with autoincrement fields; How can I achieve this in MySQL? Thanks a bunch!! -- Justin W. Burger -- MySQL General Mailing List For list archives:

Experience with MySQL 5

2005-02-09 Thread C.F. Scheidecker Antunes
Hello, Does anyone has experience with MySQL 5.x? How reliable is it? Is it compatible with JDBC, PHP and other drivers and connectors? Thank you, C.F. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Copying Database from One Hard Drive to Another

2005-02-09 Thread David Blomstrom
Ah, I see. So the tables that are represented by all three files are presumably MyISAM files, right? --- Victor Pendleton [EMAIL PROTECTED] wrote: InnoDB files can not be copied from one machine to another like the MyISAM files. If you did not dump the data or you do not have an

Re: Experience with MySQL 5

2005-02-09 Thread Martin
I've been running it for a while. Admittedly, I don't do anything truly heavy with it -- it is part of my non-critical dev stuff. I've had no issues with it, reliability wise, running it as the backend to a Tomcat 5 install and about to switch it over to a Tomcat 5.5. Basically, on that box,

Replication issue: I/O thread dies immediately after START SLAVE with no logged errors

2005-02-09 Thread Tierney Thurban
Hi all. Sorry if you get this twice -- it was posted to mysql-replication earlier, but it doesn't look like that list is really used. I'm having a problem with my replication setup. This is my first time setting up replication, so this may be a simple problem. I'm using one master and one

Re: Experience with MySQL 5

2005-02-09 Thread Bastian Balthazar Bux
It work with php too (at least with phpMyAdmin) Martin ha scritto: I've been running it for a while. Admittedly, I don't do anything truly heavy with it -- it is part of my non-critical dev stuff. I've had no issues with it, reliability wise, running it as the backend to a Tomcat 5 install and

Header files

2005-02-09 Thread Mohsen Pahlevanzadeh
Dears, I have started Linux-programming with C++. I need to header files's name of MySQL. Please give that's URL. Yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Header files

2005-02-09 Thread Logan, David (SST - Adelaide)
Hi Mohsen, If you install the client libraries from http://www.mysql.com for the version you wish, this will install the header files in the mysql/include directory. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work

Re: Header files

2005-02-09 Thread Mohsen Pahlevanzadeh
dear member, My problem is name of those.When i wish to apply a function,I don't know name of that's header file.I need to a document for it. --Mohsen On Thursday 10 February 2005 02:06, Logan, David (SST - Adelaide) wrote: Hi Mohsen, If you install the client libraries from

Daily Incremental Backups on Mysql

2005-02-09 Thread Jerry Swanson
Is it possible to do daily incremental backups on mysql? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Daily Incremental Backups on Mysql

2005-02-09 Thread Daniel Kasak
Jerry Swanson wrote: Is it possible to do daily incremental backups on mysql? Thanks Yes. mysqldump will give you a starting point, and the binary transaction logs give you your incremental backups - copy these somewhere each day - onto a backup tape or something. Read the documentation for

(newbie) Problems INSERT'ing field type SET

2005-02-09 Thread J Wermont
Hi, I'm new to MySQL and at this point, I'm just trying to insert rows of data into a table. When I insert a row of data that includes a field of type set (corresponding to an HTML set of checkbox answers), only the first item in the list gets inserted into the row. For example, I have a table

Compound Order By

2005-02-09 Thread Robert Pruitt
I'd like to do a dual order by. First, I want to order by City, then I want to order name. That way, the names within the city are alphabetized. I can easily do an order by City into a temp table, then order by name from within the temp table. Is this the best way? Is this the only way? Just

Re: Memory limit?

2005-02-09 Thread Batara Kesuma
Hi Tobias, On Wed, 9 Feb 2005 14:48:16 +0100 (CET) Tobias Asplund [EMAIL PROTECTED] wrote: I try to install MySQL 4.1.9 (official RPM from mysql.com). My machine is running linux 2.6.9, and it has 4GB of RAM. The problem is MySQL won't start if I set innodb_buffer_pool_size to = 2GB. Here

Re: Compound Order By

2005-02-09 Thread ManojSW
Does order by City,name help? - Original Message - From: Robert Pruitt [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, February 10, 2005 10:11 AM Subject: Compound Order By I'd like to do a dual order by. First, I want to order by City, then I want to order name. That

Re: Compound Order By

2005-02-09 Thread Jeremy Cole
Hi, I'd like to do a dual order by. First, I want to order by City, then I want to order name. That way, the names within the city are alphabetized. I can easily do an order by City into a temp table, then order by name from within the temp table. Is this the best way? Is this the only way?

Re: Compound Order By

2005-02-09 Thread Robert Pruitt
Well, I think I'll just stick with the story that I wuz jes' tryin' to keep everbody on their toes It's the only way out I can see. Thank-you. :) Jeremy Cole wrote: Hi, I'd like to do a dual order by. First, I want to order by City, then I want to order name. That way, the names within the

Re: (newbie) Problems INSERT'ing field type SET

2005-02-09 Thread Chris
Your problem seems to be one of spaces. This query tries to set the SET to TWO values, family and money (notice the space before money INSERT into my_table (name, subjects) VALUES (Joyce, family, money) Try it without the space: INSERT into my_table (name, subjects) VALUES (Joyce, family,money)

Re: RETURNING Keyword?

2005-02-09 Thread Wolfram Kraus
Justin Burger wrote: Good Afternoon, In Oracle there is a keyword called RETURNING, where I can do an insert and specify what row to return, this helps with autoincrement fields; How can I achieve this in MySQL? If you only want to know the value of the last inserted autoinc field, use