On 28 Oct 2004, at 12:48, Anil Doppalapudi wrote:
mysqldump running very slow. what might be the reason
[...]
I don't have specific knowledge of your database, so our answers will
be quite vague, but :
Try running with --opt. This produces a less readable outfile, but
produces one much more
On 29 Oct 2004, at 00:37, Mulley, Nikhil wrote:
How do I dump the data from console to the text file from the output
generated by SELECT statement ?
If it's a small answer that you're just trying to save to a file for
note-keeping purposes, you could run
mysql -e 'select * from thing where
Hi.
[mysqld]
..
log-error=file
log=file
See:
http://dev.mysql.com/doc/mysql/en/Server_options.html
http://dev.mysql.com/doc/mysql/en/Option_files.html
Victor Medina [EMAIL PROTECTED] wrote:
Hi!!!
How can i specify the location of the log
Hi.
Online docs contains the latest and more complete information.
Mark Day [EMAIL PROTECTED] wrote:
Hello, I was wondering if people consider the on line docs at the mysql
web site to be equivalent to their books
regarding the database administration. Does the book go into more
Hi.
Do you use official binaries compiled by MySQL AB?
Also see:
http://dev.mysql.com/doc/mysql/en/Linux.html
Espesially:
http://dev.mysql.com/doc/mysql/en/Linux-OS.html
Check that you have required versions of libraries and you run official binaries.
Aaron [EMAIL
Hi.
Following documentation, we can see:
ENUM and SET columns provide an efficient way to define columns
that can contain only a given set of values.
http://dev.mysql.com/doc/mysql/en/constraint_enum.html
But carefully read
http://dev.mysql.com/doc/mysql/en/SET.html
before
Hi.
See:
http://dev.mysql.com/doc/mysql/en/MySQL_indexes.html
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
It is ok that MySQL doesn't use indexes when selecting indexed columns that are
compared using the = operator.
You can read how indexes works.
Laszlo Thoth [EMAIL
Hi.
There are too many things to consider: the size of the table, the load average
of the server, the MySQL configuration, etc. If you could provide us with
much more details - we could check it out and make a guess what's the
bottleneck. Still, anyway you will probably need to optimize your
Hi.
What subversion of MySQL have you compiled?
From 4.0.xx and 4.1.xx branches?
MQ [EMAIL PROTECTED] wrote:
Hello,
I was able to compile mysql 4.0 and 4.1 (static) successfully with
intel compiler 8.0 on an IA32 system running redhat enterprise linux
3.0. However when I tried
Hi,
MySql 4.0.14
How can I force the following query to use a reference
in table1.
select * from table1 a left join table2 b on (a.field1
= b.field1) order by b.field2 limit 1
both a.field1 and b.field1 have indexes. Explaining
the command indicates that, MySql uses an index
(possible_keys)
Hi
apologies if this is a dumb question but can you do subqueries in mysql?
select count(*) as RES from ACL_USER_GROUP_ROLE as UGR where UGR.USER_ID
=2 and UGR.ROLE_ID = (select ROLE_ID from ACL_ROLE where ROLE_NAME =
'projectmanager' )
this query fails, but the individual queries work fine
Nathan Coast wrote:
Hi
apologies if this is a dumb question but can you do subqueries in mysql?
select count(*) as RES from ACL_USER_GROUP_ROLE as UGR where UGR.USER_ID
=2 and UGR.ROLE_ID = (select ROLE_ID from ACL_ROLE where ROLE_NAME =
'projectmanager' )
this query fails, but the
Hi Nathan,
Subqueries are only available in MySQL as of version 4.1.
On Fri, 29 Oct 2004, Nathan Coast wrote:
Hi
apologies if this is a dumb question but can you do subqueries in mysql?
select count(*) as RES from ACL_USER_GROUP_ROLE as UGR where UGR.USER_ID
=2 and UGR.ROLE_ID = (select
Hi.
I think, the better way for you is to use the official binaries.
M Taylor [EMAIL PROTECTED] wrote:
Hi all,
I had no problem with compiling 4.1.2-alpha (or 4.0.x)
and it has been working fine. But for both
4.1.5-gamma and 4.1.7, when I get to make test, all
the tests fail.
In article [EMAIL PROTECTED],
Rhino [EMAIL PROTECTED] writes:
The chief advantage of 'SET', as far as I can tell from the manual, is
that
it lets you control the specific values which can be in a column without
having to write application lookups to verify that the value you are
supplying is
THANXS!!! =)
On Thu, 2004-10-28 at 13:37, Gleb Paharenko wrote:
Hi.
[mysqld]
..
log-error=file
log=file
See:
http://dev.mysql.com/doc/mysql/en/Server_options.html
http://dev.mysql.com/doc/mysql/en/Option_files.html
Victor Medina [EMAIL
- Original Message -
From: Emily Lena Jones [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, October 28, 2004 7:46 PM
Subject: Re: many-to-many query
Quoting Rhino [EMAIL PROTECTED]:
I wasn't sure if you understood the concept of association tables
Cecep Rosuludin wrote:
Dear Gleb,
[EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chown -R root /var/lib/mysql
[EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chown -R mysql /var/lib/mysql
[EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chgrp -R root /var/lib/mysql
[EMAIL
Hi Cecep,
On Fri, 29 Oct 2004, Cecep Rosuludin wrote:
Gleb Paharenko [EMAIL PROTECTED] wrote:
See INSTALL-BINARY in the distribution directory and follow
instructions in it exactly.
Don't forget about mysql_install_db!
You appear to have missed this part out below. Don't know if this is
Are you sure?
/usr/local/mysql is a symbolic link to another direcory (
/usr/local/mysql(version).
I think the installer overwrite the symbolic link so if you open a
terminal and type:
ls -l /usr/local
Santino
At 16:20 -0700 28-10-2004, Steven Roussey wrote:
Installing MySQL 4.1.7 (upgrading
I think it may be because of your mixed left and right joins. There are
several bugs listed that show that the optimizer mishandles certain
combinations of left and right joins.
May I suggest that you re-arrange your query to include only LEFT and
INNER joins (at least until the bugs are
- Original Message -
From: Harald Fuchs [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 29, 2004 7:37 AM
Subject: Re: Fw: column choices for certain data
In article [EMAIL PROTECTED],
Rhino [EMAIL PROTECTED] writes:
The chief advantage of 'SET', as far as I can tell
Thanks, that was it exactly.
bob
At 02:25 PM 10/28/2004, Michael Stassen wrote:
Something like
SELECT uid,
AVG(number_grade) AS average_grade,
SUM(IF(letter_grade = 'A', 1, 0)) AS A_count,
SUM(IF(letter_grade = 'B+', 1, 0)) AS B+_count,
SUM(IF(letter_grade =
Is it possible to take incremental backups in mysql.if yes please provide me
links or info on it
Thanks
Anil
DBA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 19:29 +0530 10/29/04, Anil Doppalapudi wrote:
Is it possible to take incremental backups in mysql.if yes please provide me
links or info on it
Your binary logs are your incremental backups.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General
How many characters can Longblob hold?
What is the size of longblob?
Why I don't need to specify the size (i.e varchar(200) )?
On Wed, 27 Oct 2004 20:09:37 +0300, Gleb Paharenko
[EMAIL PROTECTED] wrote:
Hi.
Use LONGBLOB.
Jerry Swanson [EMAIL PROTECTED] wrote:
What type I
Jerry Swanson wrote:
How many characters can Longblob hold?
What is the size of longblob?
Why I don't need to specify the size (i.e varchar(200) )?
http://dev.mysql.com/doc/mysql/en/String_type_overview.html
Regards
Friedhelm
--
MySQL General Mailing List
For list archives:
I use the following to extract the version number. But it throws an error on
newer version 5.xx. It works on version 4.0 and below.
SELECT SUBSTRING(VERSION(),1,LOCATE(-,VERSION())-1) AS VERSION
On version 5.0.1-alpha-nt-log I get an error...
Illegal mix of collations
Hi.
Please read the notes about MySQL on Linux:
http://dev.mysql.com/doc/mysql/en/Linux.html
Do you use the official binary distribution?
[EMAIL PROTECTED] wrote:
Hi!
I searched near and far but could not find the slightest hint
about what is causing my MySQL problems. I
Hi,
I am using MySQL 5.0.1 (snapshot) and PHP 5.0.2 with mysqli interface
(latest snapshot) under Linux (SUSE 9.1).
I would like to call a SP using PHP 5, and I want to get back the SELECT
results.
This is my SP:
CREATE PROCEDURE `test`()
BEGIN
SELECT * FROM t1;
END
From the comments in
- Original Message -
From: Fredrick Bartlett [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 29, 2004 12:08 PM
Subject: Extract MySQL Version
I use the following to extract the version number. But it throws an error
on
newer version 5.xx. It works on version 4.0 and
I use the following to extract the version number. But it throws an
error
on
newer version 5.xx. It works on version 4.0 and below.
SELECT SUBSTRING(VERSION(),1,LOCATE(-,VERSION())-1) AS VERSION
On version 5.0.1-alpha-nt-log I get an error...
Illegal mix of collations
I installed mySQL v4.1.7 on windows xp
I changed my.ini file two times with different character set.
First :default-character-set=utf8
and in my application : codepage=utf8
Second : default-character-set=greek
and in my application : codepage=greek
(I live in Greece)
Running my application I see
Hi,
MySQL 4.0.22, a new version of the popular Open Source/Free Software
Database Management System has been released. It is now available in
source and binary form for a number of platforms from our download pages
at http://dev.mysql.com/downloads/ and mirror sites.
Note that not all mirror
On Thu, Oct 28, 2004 at 11:50:12AM +0200, Jigal van Hemert wrote:
...
Fortunately there is function COALESCE() that will return the first argument
that is not NULL. In case of NULL values you can use a default value for an
expression: COALESCE( `col`*2, 14) will produce 14 if `col` is NULL.
Hi,
How can i increase the size of the log file and log buffer size?
i tried to change it on my.cnf file but it return this error message:
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880
bytes
InnoDB: than specified in the .cnf file 0 67108864 bytes!
041028 0:10:49
I am just now getting the hang of searching through 2 tables, and
getting the corresponding information using a pri foreign key
(ID1=ID1) kinda thing. How is this done with more than 2 tables?
I had asked on a different forum, but I got some funky select statement
using a left inner join,
Hi,
I a facing a situation where I have two database server in two different
places that has exactly the same database. The thing is if the database
is modified in either one of the places, both database has to be updated
lively.
Can someone tell me who done this already? Please help.
I am
Matt Wagner wrote:
Hi,
MySQL 4.0.22, a new version of the popular Open Source/Free Software
Database Management System has been released. It is now available in
source and binary form for a number of platforms from our download
pages at http://dev.mysql.com/downloads/ and mirror sites.
Any
39 matches
Mail list logo