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 repli
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.
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
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 i
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 lin
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 `small
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 in
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
http://software.tangent.org/downloa
- 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
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.nam
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 r
- 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 th
- 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
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) cras
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
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 ex
Rhino wrote:
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
Rhino wrote:
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 MyS
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
- 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:
>
> > The other thing that strikes me as
Rhino wrote:
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'v
- 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 havin
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 this:
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: J
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 gen
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
S
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
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 connecti
- 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 Re
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]
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 c
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
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.
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
co
> Subject: Re: Question about [mysql ] 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
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, an
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 ro
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 write
-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.
%
%
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
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 do
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
> -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
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
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 wi
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 General
> 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 COALESCE(NULL,NU
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
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 redistr
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 f
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 m
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...
--
MyS
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 a
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 replicatio
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 PROTECT
-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/ a
> 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, 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 be
Hello,
I did a mysql dump of a database between two servers we have using the
following command:
mysqldump --opt -u --password= | mysql
--host= -C -u
--password=
This command seemed to run ok as it transferred all the structure and data
from the original server to the new server database.
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: http://lists.mysql
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 info
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 for
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 'pr
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
63 matches
Mail list logo
