Justin French wrote:
Can anyone help me optimise the way I do this?
I have two tables, 'article' and 'user'. Article has a user_id which
related to the user table.
When selecting all articles from the the article table, I'd like to be
able to get the username of the user_id. Currently I'm
If you give more details maybe someone on the list will be able to help.
Astghik Barseghian wrote:
Hello Philippe,
I am trying to use DBMail from MySQL to send and receive messages but I get an SQL
sytax error.
Could you please tell me is there any way to use the mentioned component,
or how can I
Hi,
you might take a look at this thread:
http://lists.mysql.com/mysql/166184
/Johan
Hi,
I'm searching for a function that enables me to calculate the product of
a group of values, like SUM() does. MySQL server version is at least
4.0.14.
For example, a query like
SELECT id, PRODUCT(value) AS
A couple of people have wondered why I'm using Cygwin with MySQL and
seem to think I'm trying to use the Linux version of MySQL on Windows.
I've installed the latest Windows version of MySQL. I'm using Cygwin as
the launcher rather than the Windows command prompt, mostly because
it's easier
repspected sir
my self bunty chunara, i am doing the project (for
database i have used mysql) i have downlaod it from
site but it, does not wok on my computer. i have
install it and when i open the mysql from the dos
promt it say that access deined at local host.
please sir give me proper
Hi,
you might take a look at this thread:
http://lists.mysql.com/mysql/166184
Thanks a lot - perfect. I was searching for a mathematical function too,
but I didn't cope it... this version works great!
Best regards,
Thomas
--
MySQL General Mailing List
For list archives:
Hello,
I did a mysql dump of a database between two servers we have using the
following command:
mysqldump --opt db_name -u username --password=password | mysql
--host=hostname -C db_name -u username
--password=password
This command seemed to run ok as it transferred all the structure and data
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I have a web hosting picture gallery service at
http://web-folio.net/
and am thinking about how to do the next version, which will store the
media files in the filesystem but pretty much every thing else in a
database (like it should
Since I want the ability to mirror, it seems that I'll probably want one
single DB replicated across my hosts so that comments and so on stay up
to date (I still haven't crossed the bridge of how to keep the library
itself in sync thru something like unison or rsync, but I do know that I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.1.4, 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/
Hi all,
do you know how to set innodb_lock_wait_timeout = 0? Why is it
to be 0?
Regards,
TomH
--
PROSOFT EDV-Loesungen GmbH Co. KGphone: +49 941 / 78 88 7 - 121
Ladehofstrasse 28, D-93049 Regensburg cellphone: +49 174 / 41 94 97 0
Geschaeftsfuehrer: Axel-Wilhelm Wegmann [EMAIL
Hi All :
I am still waiting for the response.
Thanks in advance.
Regards
Naveen
- Original Message -
From: Naveen C Joshi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 27, 2004 4:17 PM
Subject: Re: replication config without stopping master server
The replication
I think it is best if MySQL questions are discussed on the mailing list
rather than privately so that everyone can benefit from them.
Originally, I did not understand your question so I replied to get you to
make it clearer. Now that you have clarified your question, I find that I
don't know the
Hi,
I want to have an automatic backup done of my SQL databases, but cant quite
figure out how to use mysqldump to do this properly...
Ideally, I would like the database backed up, then FTP'd to my home server
Can someone lend me a hand with this please!
Thanks!
Sparks...
--
To all:
I'm a bit confused. After reading this mailing list, and licensing
issues on mysql, a question came up to me
Since I'm trying to implement a new database replacing Access
Database for intranet environment at my work, do I still need a license
since I am not exporting
Hi,
Concat() returns Null if any field in the field list
is Null. How can I use it to return a String
regardless, or is there another function to do it?
regards
___ALL-NEW Yahoo! Messenger -
all new
On Tue, 31 Aug 2004 08:23:01 -0400, Scott Hamm [EMAIL PROTECTED] wrote:
Since I'm trying to implement a new database replacing Access
Database for intranet environment at my work, do I still need a license
since I am not exporting my works out of my company.
If you don't
select concat(ifnull(Field1,'NULL'), Filed2) from My Table;
- Original Message -
From: A Z [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 2:25 PM
Subject: Concat
Hi,
Concat() returns Null if any field in the field list
is Null. How can I use it to return
Concat() returns Null if any field in the field list
is Null. How can I use it to return a String
regardless, or is there another function to do it?
COALESCE(value,...)
Returns the first non-NULL value in the list.
mysql SELECT COALESCE(NULL,1);
- 1
mysql SELECT
Hi,
I want to have an automatic backup done of my SQL databases, but cant quite
figure out how to use mysqldump to do this properly...
Ideally, I would like the database backed up, then FTP'd to my home server
Can someone lend me a hand with this please!
Thanks!
Sparks...
--
MySQL
I second Todd's suggestion.
There is no need to run Cygwin in order to have the MySQL servers or
clients or any of its tools operating under Win32 (95, 98, 2000, ME, 2003,
XP, etc). I only ever use Cygwin when I need to run a remote Linux desktop
and as a teaching tool. Everything else I do
Michael,
Michael Stassen wrote:
Mike Blezien wrote:
Hello,
Not sure this is possible to do with SQL or if needs to be done with
in the application programming language we're using(Perl), but I need
to get the a weekdate, IE
SELECT EXTRACT(DAY FROM NOW())
which would return 30
Now what I need to
-Original Message-
From: Sparks [mailto:[EMAIL PROTECTED]
I want to have an automatic backup done of my SQL databases,
but cant quite
figure out how to use mysqldump to do this properly...
I use a script that I run as a nightly cron job. Here's the one I use:
---
#!/bin/sh
Hi all,
Last week I got this message below..
040829 19:38:43 Slave SQL thread: I/O error reading event(errno: -1
cur_log-e
rror: 11)/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.0.18-standard-log' socket: '/tmp/mysql.sock' port: 3306
040829 19:38:43 Error reading relay
Hi there,
I need to install a database on a RedHat system. Although I'm pretty at
ease with Debian, I feel a little unconfortable and cannot find why I
get an Error: errno 13 (Permission Denied) when I try to create a new
database.
Is there some place to look at first? I cannot find any way to
Sparks,
I'm not sure why but when I try to reply to your question, Outlook Express
thinks it is a newsgroup post, not an email, and insists on knowing the
newsgroup name to which I should send my answer. Obviously, that is bogus so I
am responding with a new note.
Anyway, here's my reply
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Martijn, et al --
...and then Martijn Tonies said...
%
% Since I want the ability to mirror, it seems that I'll probably want one
...
% really don't want to keep the files in the DB itself). I'm open to ideas
% of why I wouldn't, though.
%
%
Error 13 Permission Denied means that the mysqld process doesn't have
permission by the filesystem to create whatever files/directories it
needs to in the dir you have listed as datadir. Make sure mysqld is
running as the right user (ps aux | grep mysqld) or chmod -R the
datadir so mysqld can
I never got a reply for this, and I'm still trying to figure out the
best way to handle it. Anyone?
John A. McCaskey
-Original Message-
From: John McCaskey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 25, 2004 2:17 PM
To: [EMAIL PROTECTED]
Subject: INSERT IGNORE like feature for
Hi all,
I have a need to use a kind of user permission system in the database,
but because the database is a hosted solution, I do not have access to
the real user tables and permissions and such.
SO...
What we're talking about is a document management system:
1. Some users can read, write,
Subject: Re: Question about [mysql defunct] processes
Ken Sorensen [EMAIL PROTECTED] wrote:
I am stumped. I have a very busy MySQL db that we've run for
about 3 years with no problems. A couple of months ago we upgraded
the system to RH-3AS with RedHat's distro mysql-server 3.23.58-1.9.
We've run into a problem where binary char column types crash our c++
application when migrating from RedHat 7.3 to RedHat ES. Is there a way to
specify the data type to be returned in the select statement. In the below
example, selecting office_id will crash the app if it's left as a binary
Naveen,
You don't need to shut down the master but you have to stop writing
to the database for taking the snapshot. Follow the description in
the manual:
3. If you are using MyISAM tables, flush all the tables and block
write queries by executing `FLUSH TABLES WITH READ LOCK' command.
Hi,
Make sure that the mysql user have permissions to write into the folder
/var/lib/mysql (or whatever your data folder is) .
HTH
On Tuesday 31 August 2004 18:00, Yannick Warnier wrote:
Hi there,
I need to install a database on a RedHat system. Although I'm pretty at
ease with Debian, I
Perhaps a casting function would help you:
http://dev.mysql.com/doc/mysql/en/Cast_Functions.html
If case-sensitivity isn't an issue, you may want to consider converting
from char(8) binary to just char(8).
Cheers,
--V
walt wrote:
We've run into a problem where binary char column types crash our
Hi,
is it somehow possible to log how much CPU time a thread (or query)
consumed? (this is only for debugging purposes)
Thanks in advanced,
Frank de Bot
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: walt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 12:17 PM
Subject: specify data type in select statement
We've run into a problem where binary char column types crash our c++
application when migrating from RedHat 7.3 to RedHat
I am creating an index on a very large innodb table that is taking a
very long time to complete which I understand is a limitation of
innodb.
The problem is that another application has been issuing queries
against the table and those queries have never timed out. So now I
can't kill the
Hello, first i would like to greet all of you because i am new on this list.
I am working on yellowpages application and am having some problems.
I have different tables for storing info about different companies, their
addresses phone numbers and their field of work (i can't remember exact
word
Create a script that would evoke the mysqldump let crond schedule the
task.
If you're using windows, a batch file will do create a schedule task for
your batch file.
- Original Message -
From: Sparks [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 8:22 PM
Subject:
Hi,
Yesterday, our production MySQL server died with the following error
message. Please let us know if there are any patches for this.
040830 19:52:13 InnoDB: Assertion failure in thread 27156583 in file
mem0pool.c line 493
InnoDB: Failing assertion: 0
InnoDB: We intentionally
Is there already a mysql privileged account logged in? The database will
allow for an administrative account to login, if one is not already active,
in the event of too many connections. It sounds as if you may be running one
or more accounts with this privilege.
-Original Message-
From:
Does anyone know of any guidelines or references that I can refer to
with regard to how long it takes to Optimize tables? I'm running on a
3GHz x86 [single] processor box with SCSI RAID and lots of ram. The
Mysql db files are approx. 35G (uncompressed). The table in question is
described like
- Original Message -
From: Marko Knezevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 12:53 PM
Subject: Multiple JOINs
Hello, first i would like to greet all of you because i am new on this
list.
I am working on yellowpages application and am having some
Rhino wrote:
snip
The other thing that strikes me as a possible problem is the '' operator
in the last join. I mostly use DB2 but it doesn't have this operator so I'm
not completely sure what '' will do in a MySQL join. (I am familiar with
the '' operator in programming languages, like Java, I've
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: Marko Knezevic [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 3:46 PM
Subject: Re: Multiple JOINs
Rhino wrote:
snip
The other thing that strikes me as a possible
Hello all,
In mysql, do we have a way to mysqldump all tables except two in a
database. I know we have the way only dump schema, only data, a specific
table, both data structure and data. But could someone help me about
dumping all tables in a structure except two.
For example, in databse D1,
Rhino wrote:
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
Rhino wrote:
snip
The other thing that strikes me as a possible problem is the ''
operator in the last join. I mostly use DB2 but it doesn't have this
operator so I'm not completely sure what '' will do in a MySQL
At 16:13 -0400 8/31/04, Emi Lu wrote:
Hello all,
In mysql, do we have a way to mysqldump all tables except two in a
database. I know we have the way only dump schema, only data, a
specific table, both data structure and data. But could someone help
me about dumping all tables in a structure
Hi,
I have some questions regarding CHECK TABLE, OPTIMIZE TABLE. When i run
these commands on table1 mysql seems to lock up all other databases, is
it possible to run these things in the background so that other
databases can be accessible.
// Fredrik Carlsson.
--
MySQL General Mailing List
I've tested mysql in my high school lab running from an administrator
and from a student account, both from within the Cygwin terminal, and
at the Windows command prompt. From the administrator account, it runs
fine for hours. From the student account, it promptly (within 15
seconds or so)
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: Marko Knezevic [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 4:17 PM
Subject: Re: Multiple JOINs
Rhino wrote:
- Original Message -
From: Michael Stassen
- Original Message -
From: Emi Lu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 4:13 PM
Subject: mysqldump all tables except 2 in a database
Hello all,
In mysql, do we have a way to mysqldump all tables except two in a
database. I know we have the way only
Did anyone ever follow up on this question? I'm looking for
the answer, too.
Eamon Daly
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 25, 2004 9:16 AM
Subject: Suppression of
Rhino wrote:
Your design seems fine, although you haven't explained how the field
and field_lookup tables join to the others so I am making some
assumptions.
Table field_lookup has two values defined as primary keys: ID_company and
ID_field
Thus, using simple query like:
SELECT company.name,
- Original Message -
From: Marko Knezevic [EMAIL PROTECTED]
To: MySQL list [EMAIL PROTECTED]; Rhino [EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 6:11 PM
Subject: Re: Multiple JOINs
Rhino wrote:
Your design seems fine, although you haven't explained how the field
and
Firstly,
I do appologize for my ignorance in advance. I read the message regarding PRODUCT()
and
thought to myself:A perl interpreter can be run in a C program. Some one must have
written
a userdefined function that can execute perl code. Googling I found
Stored procedures are in the works for MySQL 5.0:
http://dev.mysql.com/doc/mysql/en/TODO_MySQL_5.0.html
The manual is your friend.
Cheers,
--V
Jacob, Raymond A Jr wrote:
Firstly,
I do appologize for my ignorance in advance. I read the message regarding PRODUCT() and
thought to myself:A perl
I have a script on my site that I call smalltables. When run, it
echoes out the names of all of the tables _except_ for the large
ones that I don't back up. I then use this in the mysqldump
command line:
/usr/local/mysql/bin/mysqldump -q --user=UUU --host=localhost
--password=PPP DB_NAME
On Tue, 31 Aug 2004 18:47:57 -0400, Jacob, Raymond A Jr wrote:
http://software.tangent.org/download/myperl-0.8.tar.gz at http://tangent.org.
Looking at the readme file myperl is mysql userdefined function that executes
perl code contained in a table in the select statement. The command line
Le mar 31/08/2004 à 16:21, Dobromir Velev a écrit :
Hi,
Make sure that the mysql user have permissions to write into the folder
/var/lib/mysql (or whatever your data folder is) .
Thanks Eric and Dobromir. This was a problem of permissions on
/var/lib/mysql indeed. Although it did not work
My Bad. I was all into 4.xx and since most of the www.mysql.com references 4.xx I
never thought about
5.0. I appologize for disturbing the list.
thank you,
raymond
-Original Message-
From: V. M. Brasseur [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 31, 2004 18:54
To: Jacob, Raymond A
Hi Michael,
I must say thank you for helping me. Yes you are right
- I made the changes and it works.
I will have to read the manual to further understand
the issue with Primary and Foreign keys.
Thank you.
Maru
--- Michael Stassen [EMAIL PROTECTED]
wrote:
The problem is in table SECTIONS.
Hi Thomas,
Many thanks for valuable suggestion.
My database is InnoDB here and the tables are in .frm, .MYD and .MYI. Is
the same procedure for this database also? My master server database is
being update in every minute and I will prefer to not lock on write. If
there is no other way to
64 matches
Mail list logo
