Thanks for correcting me in the disk stats Singer, A typo error of SSD
instead of SAS 15k rpm.
Compression may not increase the memory requirements :
To minimize I/O and to reduce the need to uncompress a page, at times the
buffer pool contains both the compressed and uncompressed form of a
. But there is a question.
Is there a better way to do this? Is there something automated that
will compare THIS binlog to THAT server and tell me where the data
was no longer being inserted ? I'm looking to see how others deal
with a complete restart of a running system like this.
** It turns out
Am 26.07.2011 16:18, schrieb Todd Lyons:
1. I did a full copy of the running master database server using
xtrabackup to a backup server via nfs. It took 2 hours, of which the
last 15 minutes did a write lock of the entire server as it copied
over the *.frm files and the few myisam tables.
On Tue, Jul 26, 2011 at 8:18 AM, Reindl Harald h.rei...@thelounge.net wrote:
1. I did a full copy of the running master database server using
xtrabackup to a backup server via nfs. It took 2 hours, of which the
last 15 minutes did a write lock of the entire server as it copied
over the *.frm
Am 26.07.2011 19:13, schrieb Todd Lyons:
On Tue, Jul 26, 2011 at 8:18 AM, Reindl Harald h.rei...@thelounge.net wrote:
1. I did a full copy of the running master database server using
xtrabackup to a backup server via nfs. It took 2 hours, of which the
last 15 minutes did a write lock of
:
From: Rik Wasmus rik.was...@grib.nl
Subject: Re: dumb question?
To: mysql@lists.mysql.com
Date: Wednesday, July 6, 2011, 10:27 PM
On Wed, 2011-07-06 at 07:15 -0700, XL
Cordemans wrote:
(error code) 1064
(error message) HY000 [Actual][MySQL] You have an
error in your SQL syntax; check
configuration, so no alterations are necessary
This mode is set in my.cnf (under Windows my.ini), found in one of a
variety of standard places, in the variable sql-mode, say
sql-mode=ANSI,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
. The mode in question is ANSI. There is always
Hi,
I started with lasso 3.x FMP, jumped to lasso 8.5 with SQLlite (and loved
it), now need to work with MySQL and Laso 8.6 (on Mac mini with Snow Leopard
server 10.6.7 ). I am not a programmer but quite familiar with the traditional
encoding when using lasso. Now the question:
I created
On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote:
(error code) 1064
(error message) HY000 [Actual][MySQL] You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right
syntax to use near 'DMPPRuser) VALUES ('MYNAME')' at line 1
On Wed, 2011-07-06 at 16:27 +0200, Rik Wasmus wrote:
On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote:
(error code) 1064
(error message) HY000 [Actual][MySQL] You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax
VALUES('VALUES ARE ALWAYS SURROUNDED BY TICK MARKS
UNLESS ANSI_QUOTES ARE ENABLED');
Bedankt,
Martin
Subject: Re: dumb question?
From: rik.was...@grib.nl
To: mysql@lists.mysql.com
Date: Wed, 6 Jul 2011 16:39:16 +0200
On Wed, 2011-07-06 at 16:27 +0200, Rik Wasmus wrote:
On Wed, 2011-07
On Wed, 2011-07-06 at 11:03 -0400, Martin Gainty wrote:
Rik and Crew
Please keep your replies to the list only, I don't need to double on
e-mail...
String values are always ticked VALUES('MYNAME') unless ANSI_QUOTES are
enabled
Column names are never surrounded by ticks or double quotes
I have the following 3 tables.. If I have a contact with just notes (no
tasks), then I can simply do
delete from contacts where id = ;
but if the contact has a task, then I get the following error, ERROR
1451 (23000): Cannot delete or update a parent row: a foreign key
constraint fails
Hi,
I'm sure this must've been done before, so if someone can point me at a
discussion or assist me in some other way I'd appreciate it.
If I'm browsing a paged list of invoices say in numerical order and I
then want to reposition the list on a certain client, I can do a second
query to the
i'm just looking for rough ideas here...
i've got a table that has 31 fields. most of them need to be there
(entry time, exit time, entry lat, etc). however, i've got 4 fields
that i query this db with that should generally be unique... well,
really 3 fields that should be unique, because the
Subject: Re: Question about Backup
Forget mysqldump because TABLE LOCKS for so hughe databases
I would setup a replication-slave because you can stop
the salave and make a filesystem-backup of the whole db-folder
while the production server is online, we do this with our
dbmail-server since
that the database is one table of 5.000 gigabyte, and not
5.000 tables of one gigabyte; and that the backup needs to be consistent :-p
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
To: mysql@lists.mysql.com
Sent: Monday, 21 March, 2011 12:44:08 PM
Subject: Re: Question about
Message -
From: Reindl Harald h.rei...@thelounge.net
To: mysql@lists.mysql.com
Sent: Monday, 21 March, 2011 12:44:08 PM
Subject: Re: Question about Backup
Forget mysqldump because TABLE LOCKS for so hughe databases
I would setup a replication-slave because you can stop
the salave and make
Hi
I need set up a backup strategy for a mysql database in a ubuntu server,
the database will grow up to a 5TB.
What would be the best option ?? Maybe a script that uses mysqldump?? There
is a better way to do this?
Thanks in advance to all
Pedro.
Forget mysqldump because TABLE LOCKS for so hughe databases
I would setup a replication-slave because you can stop
the salave and make a filesystem-backup of the whole db-folder
while the production server is online, we do this with our
dbmail-server since 2009
Am 21.03.2011 12:23, schrieb Pedro
Hi,
The statement like 'I need to back up a 5T database' is not a backup strategy.
It is intention. There are some specifics that have to be determined to work
out a strategy. Going from there, the backup solution can be chosen. The
examples of questions one typically asks when
That would be the last question :-) Suppose we worked out strategy, lined up
the solutions along with their costs and then compare them with our budget.
That would be easy to find the one we can afford, and we will know what we
could dream about :-).
On Mar 21, 2011, at 11:28 AM, Singer
Hey guys,
Am a newbie here and need a little help.
Part of the database consists of two tables events and categories which
look like this
+---+-+
| eventID | eventName |
+---+-+
| 1
Just curious as it is not mentioned. Can Category ID also have multiple
event id ?
--
Cheers
Dhaval Jaiswal
On 01/03/2011 5:53 PM, Wagyu Beef wrote:
Hey guys,
Am a newbie here and need a little help.
Part of the database consists of two tables events and categories which
look like this
Oh yeah, forgot to mention that. Yes, one event will have multiple
categories. And one category can be applicable to multiple events.
On Tue, Mar 1, 2011 at 8:33 PM, Dhaval Jaiswal
jaiswal.dha...@enzenglobal.com wrote:
Just curious as it is not mentioned. Can Category ID also have multiple
Or you can interrupt the query instead, although I've seen it not to
work on occasions: KILL QUERY id;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
2011/03/01 20:23 +0800, Wagyu Beef
Part of the database consists of two tables events and categories which
look like this
+---+-+
| eventID | eventName |
+---+-+
| 1 | Event A
- Original Message -
From: Hervey Liu herve...@buffalo.edu
CREATE TABLE logins (
success
enum('Y','N[banned]','N[password]','N[panic]','N[activation]','N[authorization]')
DEFAULT 'Y' NOT NULL,
when datetime DEFAULT '-00-00 00:00:00' NOT NULL,
This is going
hello
i am a noob in general
i just want to double check
can someone perhaps send me a screen shot of how the following data will
look in a mysql table
;
CREATE TABLE logins (
success
enum('Y','N[banned]','N[password]','N[panic]','N[activation]','N[authorization]')
DEFAULT 'Y' NOT NULL,
Hi,
This is far more complicated than that. The buffer pool caches innodb
pages. Not only data and indexes are stored on innodb pages. For example
the undo log or the insert buffer are stored in innodb pages, therefore
they are cached by the buffer pool. The simple answer is: in the buffer
Does innodb buffer pool cache indexes and data in sub sets or in entirety?
I've heard people mention the buffer pool allocation is dependent on
the size of your tables and indexes.
Kyong
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I maintain a little open source project that deals with IDS alert
data. I want to add IP reputation to my event queries and I am stuck
on how I should implement it.
The user will have the option of bringing in lists from different
providers and the limit will not be fixed. These lists will be a
Hi all;
I wonder if there is any tool to Performance Tuning querys. In other know if
there is any way to kill connections that take x hours dead (for example 1
hour)
--
Mit forever
My Blog http://www.redcloverbi.wordpress.com
My Faborite
from the mysql console: show processlist
this will show you ids of all active connections, even the dead ones
then, again form the console kill processid
On Thu, Feb 17, 2011 at 3:52 PM, Rafael Valenzuela rav...@gmail.com wrote:
Hi all;
I wonder if there is any tool to Performance Tuning
Hi Michael:
Yeah , i think that i do a shell script.something like that.
require 'mysql'
mysql = Mysql.new(ip, user, pass)
processlist = mysql.query(show full processlist)
killed = 0
processlist.each { | process |
mysql.query(KILL #{process[0].to_i})
}
puts
Rafael,
You realize that script will kill perfectly well-behaved queries in
mid-flight? If you have so many dead connections that it is interfering
with operation, you have another problem elsewhere..
- md
On Thu, Feb 17, 2011 at 4:16 PM, Rafael Valenzuela rav...@gmail.com wrote:
Hi
I am working with mysql since many yaers and i have never
found e reason to kill braindead connections - what
benefit do you think to have from such actions instead
looking why there are hanging ones?
kill a connection of postfix and some user gets
temorary lookup error, php-scripts are closing
So, a problem popped up today that has caused us no end of hair-pulling, and
it brought to mind a similar issue that I found very, well, wrong.
If you have a table defined:
CREATE TABLE `tester_table` (
`acnt`varchar(20) NOT NULL DEFAULT '',
`method` varchar(10) NOT
Are you using the strict SQL mode? Check your my.cnf file.
Peter
Date: Fri, 4 Feb 2011 14:08:01 -0800
From: awall...@ihouseweb.com
To: mysql@lists.mysql.com
Subject: Question about database value checking
So, a problem popped up today that has caused us no end of hair-pulling
Thanks Peter, exactly what I was hoping for!
andy
On 2/4/11 3:11 PM, Peter He wrote:
Are you using the strict SQL mode? Check your my.cnf file.
Peter
Date: Fri, 4 Feb 2011 14:08:01 -0800
From: awall...@ihouseweb.com
To: mysql@lists.mysql.com
Subject: Question about database value checking
On 20 January 2011 19:20, Dotan Cohen dotanco...@gmail.com wrote:
On Thu, Jan 20, 2011 at 19:21, Richard Quadling rquadl...@gmail.com wrote:
That is terrific, at least the first half. The second half, with the
Venn diagrams, is awkward!
When you get heavily nested data, the adjacent list
Actually, I'm the customer! But assuming that a customer exists, that
implies compensation, and therefore fair bait.
Then that's different altogether. you get to decide what information
is displayed, and what information is 'sensed', and on what platform.
Yes, but before I get to that stage
If you are doing this often, you could leave spaces in the left and right
values so that you could minimize the number of rows that need to be
updated. The article makes every leaf use x and x+1 for left and right which
forces another update to add a child. If instead you used x and x+20 you'd
Yes, and an edge list model may perform better in other respects too:
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
Thanks. I am currently reading Trees and Hierarchies in SQL for
Smarties by Joe Celko,
On Fri, Jan 21, 2011 at 12:29, Richard Quadling rquadl...@gmail.com wrote:
Changing data in a database is the role of the database engine. It is
much more efficient to have the cost on the insert than it is on the
select.
Agreed. On insert I could even delegate the operation to another
thread
On Fri, Jan 21, 2011 at 4:44 AM, Dotan Cohen dotanco...@gmail.com wrote:
Then I would have to check what values are available when inserting,
and possibly normalise every so often. I'll think about that, and when
I have enough data in the database I'll set up a test system to play
with the
On 2011-1-16 20:22, Jørn Dahl-Stamnes wrote:
Hello,
I got a table that store information about which photo-albums that a client is
viewing. I want to get the N last visited albums and use the query:
mysql select album_id, updated_at, created_at from album_stats order by
updated_at desc limit
I am designing an application that make heavy usage of one-to-many
tags for items. That is, each item can have multiple tags, and there
are tens of tags (likely to grow to hundreds). Most operation on the
database are expected to be searches for the items that have a
particular tag. That is, users
I'd exclude (1) because new tags require restructuring the table, (2)
and (3) because they break a cardinal rule of design and will be a mess
to query, leaving ...
4) Standard many-many bridge table:
mysql CREATE TABLE items_tags (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
itemID int,
: www.the-infoshop.com
-Original Message-
From: Dotan Cohen [mailto:dotanco...@gmail.com]
Sent: Thursday, January 20, 2011 9:32 AM
To: mysql.; php-general.
Subject: Organisational question: surely someone has implemented many Boolean
values (tags) and a solution exist
I am designing
On 20 January 2011 14:32, Dotan Cohen dotanco...@gmail.com wrote:
I am designing an application that make heavy usage of one-to-many
tags for items. That is, each item can have multiple tags, and there
are tens of tags (likely to grow to hundreds). Most operation on the
database are expected
On Thu, Jan 20, 2011 at 17:00, Richard Quadling rquadl...@gmail.com wrote:
I'd have my items table, my tags table and a join table for the two.
My join table is really simple. UniqueID, ItemID, TagID.
Yes, that is the first approach that I mentioned. It looks to be a
good compromise.
I'd
On Thu, Jan 20, 2011 at 18:20, Dotan Cohen dotanco...@gmail.com wrote:
On Thu, Jan 20, 2011 at 17:00, Richard Quadling rquadl...@gmail.com wrote:
I'd have my items table, my tags table and a join table for the two.
My join table is really simple. UniqueID, ItemID, TagID.
Yes, that is the
On Thu, Jan 20, 2011 at 17:22, Jerry Schwartz je...@gii.co.jp wrote:
I think the canonical way would be to have one table for your items, one table
for your tags, and one table for your tag assignments.
Thank you, I do agree that this is the best way. Other posters seem to
agree as well!
On Thu, Jan 20, 2011 at 17:22, Peter Brawley
peter.braw...@earthlink.net wrote:
I'd exclude (1) because new tags require restructuring the table, (2)
and (3) because they break a cardinal rule of design and will be a mess
to query, leaving ...
4) Standard many-many bridge table:
mysql
On 20 January 2011 16:20, Dotan Cohen dotanco...@gmail.com wrote:
On Thu, Jan 20, 2011 at 17:00, Richard Quadling rquadl...@gmail.com wrote:
I'd have my items table, my tags table and a join table for the two.
My join table is really simple. UniqueID, ItemID, TagID.
Yes, that is the first
I cannot agree more with the others about using a join table. While it's
tempting to go with your first solution due to fear of performance issues,
you can usually address performance issues with a technical solution.
Addressing problems that arise from a constraining design choice is much
more
Pseudo = Design Algorithm
Design Algorithm = Actual Code
Actual Code = Alterable db tables
Alterable db tables = manipulated data through the app interface with data
--
The lawyer in me says argue...even if you're wrong. The scientist in
me... says shut up, listen, and then argue. But the lawyer
On Thu, Jan 20, 2011 at 19:21, Richard Quadling rquadl...@gmail.com wrote:
That is terrific, at least the first half. The second half, with the
Venn diagrams, is awkward!
When you get heavily nested data, the adjacent set model (where you
have a parentid for every uniqueid), you very quickly
On Thu, Jan 20, 2011 at 20:50, David Hutto smokefl...@gmail.com wrote:
Pseudo = Design Algorithm
Design Algorithm = Actual Code
Actual Code = Alterable db tables
Alterable db tables = manipulated data through the app interface with data
--
The lawyer in me says argue...even if you're wrong.
Is this a troll? Am I about to be baited?
Baited to deploy what is designed to the consumer's specification?
Surely. From what is wanted to what is needed. Troll on that.
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
The lawyer in me says argue...even if you're
On Thu, Jan 20, 2011 at 21:24, David Hutto smokefl...@gmail.com wrote:
Is this a troll? Am I about to be baited?
Baited to deploy what is designed to the consumer's specification?
Surely. From what is wanted to what is needed. Troll on that.
Actually, I'm the customer! But assuming that a
On Thu, Jan 20, 2011 at 2:26 PM, Dotan Cohen dotanco...@gmail.com wrote:
On Thu, Jan 20, 2011 at 21:24, David Hutto smokefl...@gmail.com wrote:
Is this a troll? Am I about to be baited?
Baited to deploy what is designed to the consumer's specification?
Surely. From what is wanted to what is
-Original Message-
From: Dotan Cohen [mailto:dotanco...@gmail.com]
Sent: Thursday, January 20, 2011 11:25 AM
To: Jerry Schwartz
Cc: mysql.; php-general.
Subject: Re: Organisational question: surely someone has implemented many
Boolean values (tags) and a solution exist
As for setting up
On Thu, Jan 20, 2011 at 2:40 PM, Jerry Schwartz je...@gii.co.jp wrote:
-Original Message-
From: Dotan Cohen [mailto:dotanco...@gmail.com]
Sent: Thursday, January 20, 2011 11:25 AM
To: Jerry Schwartz
Cc: mysql.; php-general.
Subject: Re: Organisational question: surely someone has
On Thu, Jan 20, 2011 at 21:40, Jerry Schwartz je...@gii.co.jp wrote:
Thanks. I prefer the parent tag field, though, I feel that it is
more flexible.
[JS] I disagree. The method I proposed can be extended to any depth, and any
leaf or branch can be retrieved with a single query.
I suppose for
On Thu, Jan 20, 2011 at 7:00 AM, Richard Quadling rquadl...@gmail.comwrote:
I'd recommend using a nested set approach for the tags
(http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
gives a good explanation on the issues and methodology of nested
sets).
Thanks for the
On Thu, Jan 20, 2011 at 22:05, David Harkness davi...@highgearmedia.com wrote:
Thanks for the link. That article proposes an interesting way to organize
the categories. Have you implemented this in the wild? Clearly the design
would work as it's pretty simple, and I like that it removes the
On Thu, Jan 20, 2011 at 12:21 PM, Dotan Cohen dotanco...@gmail.com wrote:
I understood that. My concern is exactly with adding new nodes. There
is no incrementor (++i) in SQL, so knowingly coding a solution that
will require incrementing two fields in half the database rows seems
[JS] I disagree. The method I proposed can be extended to any depth, and
any
leaf or branch can be retrieved with a single query.
I suppose for retrievals this structure has advantages, but unless
MySQL has a ++ operator (or better yet, one that adds or subtracts 2
from an int) then it looks
My concern is exactly with adding new nodes. There
is no incrementor (++i) in SQL, so knowingly coding a solution that
will require incrementing two fields in half the database rows seems
irresponsible.
Yes, and an edge list model may perform better in other respects too:
On 1/16/11 5:22 AM, Jørn Dahl-Stamnes wrote:
mysql select album_id, updated_at, created_at from album_stats group by
album_id order by updated_at desc limit 8;
I believe that your problem is that the group by happens before the
order by. Since you're grouping, the updated_at column is not
On Monday 17 January 2011 09:53, Steve Meyers wrote:
On 1/16/11 5:22 AM, Jørn Dahl-Stamnes wrote:
mysql select album_id, updated_at, created_at from album_stats group by
album_id order by updated_at desc limit 8;
I believe that your problem is that the group by happens before the
order
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
He meant the execution order, please use the agregation function as
suggested.
On 11-01-17 05:03, Jørn Dahl-Stamnes wrote:
On Monday 17 January 2011 09:53, Steve Meyers wrote:
On 1/16/11 5:22 AM, Jørn Dahl-Stamnes wrote:
mysql select album_id,
Hello,
I got a table that store information about which photo-albums that a client is
viewing. I want to get the N last visited albums and use the query:
mysql select album_id, updated_at, created_at from album_stats order by
updated_at desc limit 8;
--
Richard Reina
Rush Logistics, Inc.
Watch our 3 minute movie:
http://www.rushlogistics.com/movie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
My issue is actually in Excel. I'm hoping someone could help me...
I need to total the values in column B for Emily. Is there a way other
than =SUM (B1+B2+B4+B7)?
--
Emily | 1
-
Emily | 5
-
Greg | 2
-
Bob | 7
-
Emily | 4
Have you tried:
select UserName, Sum(ColB) from Table group by UserName;
or
select UserName, Sum(ColB) from Table group by UserName where
UserName=Emily;
Mike
At 11:43 AM 1/12/2011, Nicholas Moreno wrote:
My issue is actually in Excel. I'm hoping someone could help me...
I need to
really really a little noisy.
这下犯众怒了吧,招人烦了~ 囧
Best regards,
Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
2010/12/29 杨涛涛 david.y...@actionsky.com:
Ok, I'll not post any more! Just reading!
David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My
you can take advantage
of the latest features and fixes, but unless you're going back really
far - like MySQL 3.23 - any modern client version should have no
negative impact. Even in that case it may not, but that's a better
question for either the php-db@ list or the MySQL General list (both
CC'd
Ok, I'll not post any more! Just reading!
David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My Second Blog:http://yueliangdao0608.blog.51cto.com
My Msn: yueliangdao0...@gmail.com
在 2010年12月23日 下午8:14,Johan De Meersman vegiv...@tuxera.be写道:
Glad to hear I'm not
This guy has been saying nothing meaningful on this list, but
advertise his blog everywhere.
Just be shame. He should be kicked out from the list.
Jorg.
2010/12/23 杨涛涛 david.y...@actionsky.com:
This way is very well, but it has to do lots of human work.
David Yeung, In China, Beijing.
My
Glad to hear I'm not the only one annoyed :-) I've plonked him in the
meantime.
2010/12/23 Jorg W Young jorgwyoung...@gmail.com jorgwyoung%2...@gmail.com
This guy has been saying nothing meaningful on this list, but
advertise his blog everywhere.
Just be shame. He should be kicked out from
-
From: Machiel Richards [mailto:machi...@rdc.co.za]
Sent: Wednesday, November 24, 2010 7:20 AM
To: mysql mailing list
Subject: Another replication question
Hi All
I am back once again with another replication question (maybe this
can also be handled by MMM but not sure) this time
Hi All
I am back once again with another replication question (maybe this
can also be handled by MMM but not sure) this time for a different
client.
We are trying to find out how to setup 3 different masters to
replicate to a single slave server (without the need to have 3 different
:
Hi All
I am back once again with another replication question (maybe this
can also be handled by MMM but not sure) this time for a different
client.
We are trying to find out how to setup 3 different masters to
replicate to a single slave server (without the need to have 3 different
at 1:20 PM, Machiel Richards machi...@rdc.co.za
wrote:
Hi All
I am back once again with another replication question (maybe this
can also be handled by MMM but not sure) this time for a different
client.
We are trying to find out how to setup 3 different masters to
replicate
On Wed, Nov 24, 2010 at 2:50 PM, John Daisley daisleyj...@googlemail.comwrote:
Are you sure mmm couldn't handle this?
That, I don't know, but MySQL's internal replication mechanisms definitely
don't support multimaster slaves. If mmm does it, it'll likely be akin to
the offline log shipping I
: Machiel Richards [mailto:machi...@rdc.co.za]
Sent: Wednesday, November 24, 2010 7:20 AM
To: mysql mailing list
Subject: Another replication question
Hi All
I am back once again with another replication question (maybe this
can also be handled by MMM but not sure) this time for a different
client
: Rolando Edwards [mailto:redwa...@logicworks.net]
Sent: Wednesday, November 24, 2010 6:53 AM
To: Machiel Richards; mysql mailing list
Subject: RE: Another replication question
MySQL, by design, cannot do that.
A DB Server can be Master to Multiple Slaves
Think of the CHANGE MASTER TO command.
Its
From the OP:
I have a copy of the INNODB files for these two tables - is there a way
to extract the table contents from these files short of a full import?
I have to agree, that's quite ambiguous. Andy, is it a copy of the innoDB
datafiles, or a database dump that you have ?
In the latter
If you just need specific records, you can use -w option of mysql to
extract only the specifc records.
Then you can run the dump file into another db.
regards
anandkl
On Fri, Nov 12, 2010 at 2:35 PM, Johan De Meersman vegiv...@tuxera.bewrote:
From the OP:
I have a copy of the INNODB files
Thanks, guys. I have copies of the innodb files. The boss went whole hog on
using zfs for everything, so backups of files are readily available. Looks
like I'll be having the db reconstituted...
thanks again
On 11/12/10 1:05 AM, Johan De Meersman wrote:
From the OP:
I have a copy of the
Cc: Gavin Towey; Andy Wallace; mysql list
Subject: Re: question about restoring...
On Tue, Nov 9, 2010 at 11:39 PM, Jerry Schwartz je...@gii.co.jp wrote:
Then I guess it's a matter of preference. I'd rather edit a text file than
build a new instance of MySQL.
The way I parse that, you're
So, I got a request this morning to recover some specific records for
a client. I just want a handful of records from a couple of tables here.
I have a copy of the INNODB files for these two tables - is there a way
to extract the table contents from these files short of a full import?
thanks,
No, you should import the data into another instance of mysql to extract the
records.
Regards,
Gavin Towey
-Original Message-
From: Andy Wallace [mailto:awall...@ihouseweb.com]
Sent: Tuesday, November 09, 2010 10:34 AM
To: mysql list
Subject: question about restoring...
So, I got
Not if he has the raw innodb files.
-Original Message-
From: Jerry Schwartz [mailto:je...@gii.co.jp]
Sent: Tuesday, November 09, 2010 11:05 AM
To: Gavin Towey; 'Andy Wallace'; 'mysql list'
Subject: RE: question about restoring...
That's overkill.
You should be able to import the data
Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com
-Original Message-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Tuesday, November 09, 2010 3:22 PM
To: Jerry Schwartz; 'Andy Wallace'; 'mysql list'
Subject: RE: question
On Tue, Nov 9, 2010 at 11:39 PM, Jerry Schwartz je...@gii.co.jp wrote:
Then I guess it's a matter of preference. I'd rather edit a text file than
build a new instance of MySQL.
The way I parse that, you're saying that there is a way to reattach ibd
files to another database ?
--
Bier met
Hi,
I've the following query
SELECT COUNT(players_id) AS players_count
FROM players
WHERE teams_id 0
GROUP BY teams_id
ORDER BY players_count DESC
However, I've another field called original_teams_id and want to include the
COUNT with players_count, when original_teams_id = teams_id
Cheers
201 - 300 of 6660 matches
Mail list logo