Hi,
I have a question regarding mysql master-slave replication's
Relay_Master_Log_File. I hope someone can answer me.
I have mysql setup to purge old logs that arent being used by master, and
also the max log size is set as 500MB. I see that new logs are created with
next number in order.
What
On Tue, Apr 8, 2008 at 7:44 AM, Chanchal James [EMAIL PROTECTED] wrote:
What could happen when this numbering reaches the limit, say,
mysql-bin.99. Will it break replication in anyway or will it just get
reset, and the slave starts to pick up replication from the new log(which
I
presume
I searched for a few combination of words, and didnt reach anywhere. Thats
how I ended up posting here.
From this thread it looks like it never gets reset and keeps increasing the
numbering; I would still wish if it reset someday without affecting the
replication!
Thanks for the link, Rob.
On
I need to put a read-only copy of a single table on a database on another
server so remote customers can have read access to it. I built a new MySQL
server and placed in my DMZ. I can use SSH forwarding to access it from
outside. Now I need to get a copy of the table from my internal MySQL server
This is something I do with replication.
You can replicate a list of tables, see the 'replicate_do_table' config
option.
Then you can euse the 'read_only' option. Replication still works but
nothing else. But it would give you more options by using GRANT instead
of 'read-only':
CREATE
I need to put a read-only copy of a single table on a database another
server so remote customers can have read access to it.
I use SQLYob Job Agent to synchronise two MySQL databases. See
http://www.webyog.com/en/ for more information.
I use SSH to so port forwarding from one box to the
size to about 2 GB. My question is: When mysql adds
indexes to the keycache, does it add each index individually or does
it dump the entire .MYI file to the keycache. If it is the latter, I
should move the fulltext index to another table.
Thanks in advance,
Christian
--
J. Christian Hesketh M.Sc
fulltext indexing on. The total size of the
smallint indexes is only about 30 MB, but the fulltext index brings
the total index size to about 2 GB. My question is: When mysql adds
indexes to the keycache, does it add each index individually or does
it dump the entire .MYI file to the keycache
index size to about 2 GB. My question is: When mysql adds
indexes to the keycache, does it add each index individually or does
it dump the entire .MYI file to the keycache. If it is the latter, I
should move the fulltext index to another table.
Thanks in advance,
Christian
--
J
Carlos Savoretti schrieb:
Hi all!
Well, question is how could I to retrieve information about
types supported.
IMHO, no
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tue, Mar 18, 2008 at 9:58 AM, Carlos Savoretti
[EMAIL PROTECTED] wrote:
Hi all!
Well, question is how could I to retrieve information about
types supported . In PostgreSQL the query would be:
--
SELECT pg_type.oid
Hi all!
Well, question is how could I to retrieve information about
types supported . In PostgreSQL the query would be:
--
SELECT pg_type.oid, typname, usename, obj_description(pg_type.oid)
FROM pg_type, pg_user
WHERE typowner
Try using myisamchk -r option for repairing the table.
On Wed, Mar 12, 2008 at 2:53 PM, pengyao [EMAIL PROTECTED] wrote:
hi,i have a question,such as:
mysql select * from test;
ERROR 1194 (HY000): Table 'test' is marked as crashed and should be
repaired .
i think the test table
i am a newbie in this mysql path...
what are the diferences between mysql 5.0, 5.1 and 6.0
I work mostly with Ms-SQL 2003.
any sugestion? any answer? any help would be nice!
thx
Roberto Zarate Mendoza
lima-peru
511 9238-4883
On Thu, 13 Mar 2008, Roberto Zarate [EMAIL PROTECTED] wrote:
i am a newbie in this mysql path...
what are the diferences between mysql 5.0, 5.1 and 6.0
I work mostly with Ms-SQL 2003.
any sugestion? any answer? any help would be nice!
I did a Google search for mysql and the top hit was
hi,i have a question,such as:
mysql select * from test;
ERROR 1194 (HY000): Table 'test' is marked as crashed and should be repaired .
i think the test table was breakdown, so
mysqlcheck table test;
check | error| Table upgrade required. Please do REPAIR TABLE `test` to
fix
pengyao wrote:
mysqlcheck table test;
check | error| Table upgrade required. Please do REPAIR TABLE `test`
to fix it! mysqlrepair table test;
| test | repair | Warning | Incorrect string value:
| '\xBB\xA8\xBC\xE4\xC1\xBD...' for column 'test' at row 13 |
mysqlcheck table test;
check
Hi Mihai, all !
Mihai Tanasescu wrote:
Hello all,
I have a quite silly question I guess but it's been bugging me up recently.
A client has just acquired a SAN for his servers.
Between these servers he also has 2 mysql ones.
What would happen if I were to define a single shared disk
Joerg Bruehe wrote:
Hi Mihai, all !
Mihai Tanasescu wrote:
Hello all,
I have a quite silly question I guess but it's been bugging me up
recently.
A client has just acquired a SAN for his servers.
Between these servers he also has 2 mysql ones.
What would happen if I were to define
Hello all,
I have a quite silly question I guess but it's been bugging me up recently.
A client has just acquired a SAN for his servers.
Between these servers he also has 2 mysql ones.
What would happen if I were to define a single shared disk on the SAN
and I place both Mysqls to work
Folks,
Thanks for the 'help'. Oy.
I figured it out from some help on the Lasso discussion list.
All I had to do was properly address ALL the tables I wanted to touch.
So this:
UPDATE tbe_gallery
SET tbe_gsa.gsa_paperprice = tbe_gallery.gallery_gsaprice_paper
WHERE tbe_gallery.gallery_id =
Hi Everyone,
I am attempting to write a PHP application that reads info from a
MySQL database, and I'm wondering if I can set up a column in one
table that gets it's info from a field in another table automatically?
Ie:
Table1:
field1
field2
field3
Table2:
field4
field5
field6 = field1
Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
[EMAIL PROTECTED]
Tip for future questions:
Figure out the simplest way to present the question and include the
SQL to create the relevant tables.
Next explain what you want, any non working sql you have, and lastly
.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
[EMAIL PROTECTED]
Tip for future questions:
Figure out the simplest way to present the question and include the
SQL to create the relevant tables.
Next explain what you want, any non working sql you have
called tbe_galery.gallery_id.
So my question is how do use the corresponding match fields to update
the necessary fields so that... be_gsa.gsa_paperprice =
tbe_gallery.gallery_gsaprice_paper
Is my statement above anywhere close to what it should be
Miles.
--
MySQL General
www.raoset.com
[EMAIL PROTECTED]
Tip for future questions:
Figure out the simplest way to present the question and include the
SQL to create the relevant tables.
Next explain what you want, any non working sql you have, and lastly
give an example result of correct output.
Hi Rob, I
way to present the question and include the
SQL to create the relevant tables.
Next explain what you want, any non working sql you have, and lastly
give an example result of correct output.
Hi Rob, I will do this in the future, thank you.
And to that end:
CREATE TABLE `current` (
`customerName
, MI, 49424-9337
www.raoset.com
[EMAIL PROTECTED]
Tip for future questions:
Figure out the simplest way to present the question and include the
SQL to create the relevant tables.
Next explain what you want, any non working sql you have, and lastly
give an example result
Jason Pruim wrote:
I am attempting to write a PHP application that reads info from a
MySQL database, and I'm wondering if I can set up a column in one
table that gets it's info from a field in another table automatically?
Ie:
Table1:
field1
field2
field3
Table2:
field4
field5
If he is not sure what a join or primary key is then I do not think a
correct solution for anything he is working on would involve a
trigger. In October '07 Baron Schwartz said the following:
I'm not an expert on them, but as a side note: I personally don't use
triggers in MySQL. I consider them
tbe_galery.gallery_id.
So my question is how do use the corresponding match fields to update
the necessary fields so that... be_gsa.gsa_paperprice =
tbe_gallery.gallery_gsaprice_paper
Is my statement above anywhere close to what it should be
Miles.
--
MySQL General Mailing List
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've been looking for a way to fake replication from mysql to a local
BDB database. I'm not finding anything. Anybody ever come across this?
It seems like it wouldn't be too terribly difficult to read from the
relay-log and keep track of where you
table users
iduser_iduser_name
1 M11 Shirley
2 M12 Bruce
3 M13 Fred
4 M14 Albert
5 M15 Elizabeth
6 T11 Helen
7 T12 Tracy
8 T13 Charles
9 T14 Jack
10 T15 Ann
table
2008/2/18 King C. Kwok [EMAIL PROTECTED]:
table users
iduser_iduser_name
1 M11 Shirley
2 M12 Bruce
3 M13 Fred
4 M14 Albert
5 M15 Elizabeth
6 T11 Helen
7 T12 Tracy
8 T13 Charles
Hi Rob,
That is just what I need. I can't use 'join' very well yet.
Thank you very much.
--
King Kwok
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, and then setting up a trigger so that when a sub type is
created, that it automatically updates the type field in the BASE to signify
what 'type' it is.
My question is: how can I restrict the BASE-type field from being updated
directly, and only permit it to be updated through the trigger when a
sub
The documentation says it requires SUPER.
I am aware that it is not the greatest idea to give this priv to users, but
I would really like them to be able to do stop logging for some seesions
Olaf
On 2/3/08 10:03 PM, Moon's Father [EMAIL PROTECTED] wrote:
will it be file or super?
On Jan
will it be file or super?
On Jan 31, 2008 10:29 PM, Olaf Stein [EMAIL PROTECTED]
wrote:
Hi All,
I would like for my regular database users to be able to turn logging off
for certain sessions. This would work by allowing them to set SQL_LOG_OFF
and SQL_LOG_BIN. This requires the user to have
Hi All,
I would like for my regular database users to be able to turn logging off
for certain sessions. This would work by allowing them to set SQL_LOG_OFF
and SQL_LOG_BIN. This requires the user to have the SUPER privilege.
Is there any reason why regular users should not have this privilege?
Hi !
zhihuali wrote:
Hi netters,
Suppose I have a table X:
NameSalary
Tom1000
Jack 3000
Mike 1000
Mike 3500
Tom 4000
I want to do the following thing:
First, order by Salary;
Second, starting from the highest salary down, group
On Jan 30, 2008 5:25 PM, Jerry Schwartz [EMAIL PROTECTED] wrote:
The problem starts when I try to fetch the memos. I want one email address,
two or more customer_ids (so I can tell them apart), and all of the memos
for each customer_id (preferably using GROUP_CONCAT(). In other words, this
is
I have a question regarding the innodb_file_per_table configuration
option. We currently do not have this enabled, so our ibdata1 file is huge.
Is it recommended that we have this configured to store the tables in
their own files? What are the performance implications of doing
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: GROUP question
On Jan 30, 2008 5:25 PM, Jerry Schwartz [EMAIL PROTECTED]
wrote:
The problem starts when I try to fetch the memos. I want one email
address,
two or more customer_ids (so I can tell them apart), and all of the
memos
On Jan 31, 2008 1:30 PM, Jerry Schwartz [EMAIL PROTECTED] wrote:
That's rather what I feared. I'm trying to avoid code, mostly because this
should be a one-off run.
If it's a one-shot deal and you don't mind it taking a little time, I
think something like this would work:
SELECT
I have two tables that (simplified) look like this:
customers
=
customer_id [integer, autoincrement]
email [varchar]
memos
=
memo_id [integer, autoincrement]
customer_id [integer]
memo_text [varchar]
There are some duplicate email addresses in the customers table. A
customer might
Hi,
On Jan 28, 2008 3:29 PM, Dean Karres [EMAIL PROTECTED] wrote:
Hi,
I know that someone is going to say, go ask the perl module guys and
I will but they are likely to say, go ask the MySQL guys. I'll be
asking in both groups.
I am installing a script on a brand new RedHat, Fedora Core 7
Hi,
I know that someone is going to say, go ask the perl module guys and
I will but they are likely to say, go ask the MySQL guys. I'll be
asking in both groups.
I am installing a script on a brand new RedHat, Fedora Core 7 (x86_64)
box that is running MySQL 5.0.45 (rpm install). I also have a
-
From: Dean Karres [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, January 28, 2008 10:29 PM
Subject: MySQL, perl, last_insert_id() question
Hi,
I know that someone is going to say, go ask the perl module guys and
I will but they are likely to say, go ask the MySQL guys. I'll be
asking
Hi netters,
Suppose I have a table X:
NameSalary
Tom1000
Jack 3000
Mike 1000
Mike 3500
Tom 4000
I want to do the following thing:
First, order by Salary;
Second, starting from the highest salary down, group by Name. So the resulting
Hello,
I feel stupid here... How do I respond to a specific post?
I posted last night, I got a response... now I want to post a response to the
response.
Don't see a way to do that...
Thanks,
Lee
**
Start the year off right. Easy ways to stay in shape.
MCSE (NT) CNA A+
Network EngineerSafe Data, Inc.
(910) 285-7200 [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 23, 2008 10:19 AM
To: mysql@lists.mysql.com
Subject: Newbie question, how do I respond to post
When you establish a connection, it's a connection to a server, not a
specific DB. You can set a default db so that you don't always have
to specify the db name you are working with. So to answer your
question, no, a new connection is not established.
Brent
On Jan 19, 2008, at 10:19 AM
are working with. So to answer your
question, no, a new connection is not established.
Brent
On Jan 19, 2008, at 10:19 AM, Alex K wrote:
Hi Guys,
What does the statement select * from otherdb.table do if I haven't
explicitly connected to otherdb previously? I would assume it connects
Hi Guys,
What does the statement select * from otherdb.table do if I haven't
explicitly connected to otherdb previously? I would assume it connects
to otherdb and does the select on table but does it create a new
connection each time? Is it as efficient as explicitly connecting to
otherdb and
Hi Guys,
Let's suppose I have the following table:
create table companies
(
id int(11) not null auto_increment primary key,
# user's login and password
email varchar(100),
passwordvarchar(100),
# basic information
company_name
[EMAIL PROTECTED]
Subject: basic style shema question
To: mysql@lists.mysql.com
Date: Friday, January 18, 2008, 11:14 PM
Hi Guys,
Let's suppose I have the following table:
create table companies
(
id int(11) not null auto_increment primary
key,
# user's login
generally tend towards
normalization, not denormalization.
The question is: what do you want to do with the schema?
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
K [EMAIL PROTECTED]
Subject: basic style shema question
To: mysql@lists.mysql.com
Date: Friday, January 18, 2008, 11:14 PM
Hi Guys,
Let's suppose I have the following table:
create table companies
(
id int(11) not null auto_increment primary
key,
# user's login
did you check time in master and slave servers?
saravanan
--- On Sat, 1/19/08, Paul Berry [EMAIL PROTECTED] wrote:
From: Paul Berry [EMAIL PROTECTED]
Subject: another slave loading question
To: MySql mysql@lists.mysql.com
Date: Saturday, January 19, 2008, 7:56 AM
i have this State when I
check time in master and slave servers?
saravanan
--- On Sat, 1/19/08, Paul Berry [EMAIL PROTECTED] wrote:
From: Paul Berry [EMAIL PROTECTED]
Subject: another slave loading question
To: MySql mysql@lists.mysql.com
Date: Saturday, January 19, 2008, 7:56 AM
i have this State when I start
are better suited to
different types of workloads.
- Are you worried about integrity of your data? How many foreign
key constraints will you want?
These all tie in together, and generally beg the question of *your*
usage patterns. If this is a project of any import, I can almost
guarantee that what
i have this State when I start a slave: Has read all relay log; waiting for
the slave I/O thread to update it
mysql show processlist;
++-+---+---+-+--+---+--+
| Id | User
normalization, not denormalization.
The question is: what do you want to do with the schema?
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http
] wrote:
From: Paul Berry [EMAIL PROTECTED]
Subject: Re: another slave loading question
To: [EMAIL PROTECTED], MySql mysql@lists.mysql.com
Date: Saturday, January 19, 2008, 8:16 AM
hi thanks for the quick answer ! these 2 servers are in
different timezones
- do i need to set the slave server
Subject: automation question
Everyone,
So, I have been thinking recently about automation. This morning I
listened to a talk by one of the three dbas at Youtube (from the
MySQL
Users Conference last year). Think about that. They mentioned
100,000,000 pageviews in one day
Everyone,
So, I have been thinking recently about automation. This morning I
listened to a talk by one of the three dbas at Youtube (from the MySQL
Users Conference last year). Think about that. They mentioned
100,000,000 pageviews in one day (the data was from 2006). And THREE
dbas. Of
and Sender does not endorse distribution to any party other than intended
recipient. Sender does not necessarily endorse content contained within this
transmission. Date: Thu, 3 Jan 2008 13:06:07 -0500 From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com Subject: automation question Everyone, So
, 3 Jan 2008 13:06:07 -0500
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: automation question
Everyone,
So, I have been thinking recently about automation. This morning I
listened to a talk by one of the three dbas at Youtube (from the MySQL
Users Conference last year). Think
. Sender does not necessarily endorse content contained
within this transmission.
Date: Thu, 3 Jan 2008 13:06:07 -0500
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: automation question
Everyone,
So, I have been thinking recently about automation. This morning I
listened to a talk
| name3
message2 | name3
message3 | name3
Of course I have simplified everything down to the minimum :)
Thanks in advance,
Richard
As I have had no answer I presume that what I want to do is not possible
or my question is not well explained. Anyhow I've rethought
not endorse distribution to any party other than intended
recipient. Sender does not necessarily endorse content contained within this
transmission. Date: Sun, 30 Dec 2007 13:54:32 +0100 From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com Subject: Re: Help with query, (question simplified
as last
Sorry about my last email which was long and not clear.
This is what I want to do
Join two tables on code table1 = code table3 where messageid = for
example 28
table 1 contains :
message from messageid
--
message1 |
hi.
using mysql 5.0.27 and playing with triggers.
a simple db:
create table foo{
aa varchar (10),
bb int auto_increment,
cc varchar (10),
} innondb
i'm trying to figure out how to create a trigger, such that if the user does
an insert into foo (cc) value (www);
the table will concat the www
-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 7:59 PM
To: 'mysql list'
Subject: trigger question..
hi.
using mysql 5.0.27 and playing with triggers.
a simple db:
create table foo{
aa varchar (10),
bb int auto_increment,
cc varchar (10),
} innondb
i'm trying
being created...
any more pointers/thoughts/...
thanks
-Original Message-
From: joe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 7:33 PM
To: 'bruce'; 'mysql list'
Subject: RE: trigger question..
create table foo
(aa varchar(20),
id integer,
cc varchar(20
Hi Bruce,
delimiter |
create trigger mfgtst after insert on masterHostTBL
for each row begin
set @tmp = 55;
insert into masterTestResultStartTBL
set hostID = NEW.id,
testResultVal = 88;
/*
set @q = masterTestResultStartValTBL.serverStartVal;
hi...
i have the following test sql/schema. i'm trying to create a trigger that
would allow an item in tbl2 to be updated, based upon values from the tbl
that's being inserted into, and the value in a 2nd tbl.element.
the sql/schema:
/*
test schema for stratalight file project
#
# b douglas
#
I hope a simple question,
Can a MySQL Client (5.0.14) connect to a MySQL Server (5.1.22) (or more
specifically I have a static build of PHP using the libmsqlclient.la from
MySQL version 5.0.14 as a client attempting to connect to a MySQL server
running version 5.1.22rc.)?
My thanks
Subject: MySQL server connection question.
I hope a simple question,
Can a MySQL Client (5.0.14) connect to a MySQL Server (5.1.22) (or more
specifically I have a static build of PHP using the libmsqlclient.la from
MySQL version 5.0.14 as a client attempting to connect to a MySQL server
.
- Original Message
From: B. Keith Murphy [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, November 16, 2007 10:29:17 AM
Subject: innodb rollback question
I have something to throw out. I just got done importing 140 million
rows from a myisam table to a innodb table. While it worked I had
At 02:05 PM 11/16/2007, you wrote:
How do you import the data?
Load data from file is faster thought
so better to export myisam - file and then you do load data from file
make sure you set autocommit=0 to make it faster
Ady,
Sure but won't the entire Load Data will still be wrapped in a
I have something to throw out. I just got done importing 140 million
rows from a myisam table to a innodb table. While it worked I had a
thought about 3/4ths of the way through. What if the transaction had
been canceled about 130 million rows in? It would have taken weeks to
roll back.
: B. Keith Murphy [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, November 16, 2007 10:29:17 AM
Subject: innodb rollback question
I have something to throw out. I just got done importing 140 million
rows from a myisam table to a innodb table. While it worked I had a
thought about 3
How do you import the data?
Load data from file is faster thought
so better to export myisam - file and then you do load data from file
make sure you set autocommit=0 to make it faster
On Nov 17, 2007 12:29 AM, B. Keith Murphy [EMAIL PROTECTED] wrote:
I have something to throw out. I just
I wrote this Nagios (http://nagios.org/ - a monitoring tool) specific Perl
plugin a few years ago, but you can easily use it for your needs. The
version I have online does not support mysql 5.0+ but that is easily
remedied..
info;
http://www.byveka.com/files/README.check_replic
Hi...
If I have a master/slave setup, I can do a mysqlshow slave status\G and
get information on the overall status of the slave. Is there a way to break
out this information without having to parse the output? In other words, are
there other cmds that might provide the different pieces of
bruce wrote:
Hi...
If I have a master/slave setup, I can do a mysqlshow slave status\G and
get information on the overall status of the slave. Is there a way to break
out this information without having to parse the output? In other words, are
there other cmds that might provide the different
From: Dan Rogart [mailto:[EMAIL PROTECTED]
On 11/14/07 4:01 PM, Mike Johnson
[EMAIL PROTECTED] wrote:
Correction to a couple of replies I've seen -- a slave
server can have more than one master, but not to the same
database. That is, Slave reads Database1 and Database3
from
Hi...
I'm considering the following issue:
need to copy in db1 tbl_1 - tbl_2
and in db2 cat - dog
so i need to perform copies of both tbls in the two databases. and i need
them to both succeed, or to both be rolled back. the copies are in two
separate databases.
any thoughts on this...
Hi...
I'm trying to get me head around a possible situation involving
locks/triggers.
Suppose I have two tables:
FooTBL
CatTBL
in FooTBL, I have a trigger that operates such that whenever a new row is
added to FooTBL, it's immeadiately copied to CatTBL.
I'm trying to understand what happens
to the Master Server/DB...
However, in looking through various docs, I can only see how to setup a
single Slave connection in the my.cnf file. I can't see how to setup
multiple Slave connections in the Slave Server, to allow it to handle
multiple Masters...
So, my basic question is how/what do I need
tied back to the Master Server/DB...
However, in looking through various docs, I can only see how to setup a
single Slave connection in the my.cnf file. I can't see how to setup
multiple Slave connections in the Slave Server, to allow it to handle
multiple Masters...
So, my basic question is how
multiple Masters...
So, my basic question is how/what do I need to do? Can I have multiple
my.cnf files.. Should everything be placed in a single my.cnf file?
Any thoughts/pointers/comments would be helpful!!
thanks
Typically, each slave is configured to follow only a single master..
mutli
Correction to a couple of replies I've seen -- a slave server can have
more than one master, but not to the same database. That is, Slave reads
Database1 and Database3 from Master1 and also reads Database2 from
Master2.
You may actually be able to get down to the table level, but I'd have to
On 11/14/07 4:01 PM, Mike Johnson [EMAIL PROTECTED] wrote:
Correction to a couple of replies I've seen -- a slave server can have
more than one master, but not to the same database. That is, Slave reads
Database1 and Database3 from Master1 and also reads Database2 from
Master2.
You may
the slave DBs, and
my.conf information on the same box. Given that I can easily have multiple
DBs on a mySQL app, my question appears to come down to how to handle the
my.cnf information. I don't see how I can handle multiple my.cnf files that
are separate, so is there a way to have all
on a mySQL app, my question appears to come down to how to handle the
my.cnf information. I don't see how I can handle multiple my.cnf files that
are separate, so is there a way to have all the information for the various
slave DBs in the same my.cnf file.
Or would I essentially have to have multiple
DROP FUNCTION IF EXISTS secs_to_hrs;
DELIMITER |
create function secs_to_hrs (secs varchar(10))
returns varchar(13)
DETERMINISTIC
BEGIN
return CONCAT_WS(' h ',lpad(secs/60 div 60,3,' ') ,
CONCAT(lpad(round(secs/60 mod 60),2,' '),' mins') );
END;
|
DELIMITER ;
What if I wanted to not display
I have a database table paycheck like this.
empno, date, gross, fed_with
1234 2007-09-01 1153.85 108.26
1323 2007-09-01 461.54 83.08
1289 2007-09-01 1153.85 94.41
1234 2007-09-15 1153.85 108.26
1323 2007-09-15 491.94 87.18
1289 2007-09-15 1153.8594.41
I can easily do
Hi Richard,
Richard Reina wrote:
I have a database table paycheck like this.
empno, date, gross, fed_with
1234 2007-09-01 1153.85 108.26
1323 2007-09-01 461.54 83.08
1289 2007-09-01 1153.85 94.41
1234 2007-09-15 1153.85 108.26
1323 2007-09-15 491.94 87.18
1289
701 - 800 of 6660 matches
Mail list logo