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]
| 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
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
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
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.
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
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...
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
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
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
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
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
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
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
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
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
[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
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
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
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,
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.
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
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
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
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
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
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
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
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
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.
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.
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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]
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
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,
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
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
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]
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
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
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]
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
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
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
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
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
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?
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
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)
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
66 matches
Mail list logo