Hi Jerry,
there's a (commercial) product called SQLyog, with an excellent schema
synchronization tool (at least in the enterprise version) which procudes
ready-made alter table scripts.
Probably other db tools have this functionality too ...
HTH, regards,
Markus
- Original Message
I have 3 tables (schema below) with categories, questions and answers.
Each category can of course have many questions in it. Also, the
answers are multiple choice, so each question can have several
related answers. I am trying to achieve 2 goals.
1) SELECT N questions and the related answers
1) SELECT N questions and the related answers from each category.
See Within-group quotas (Top N per group) at
http://www.artfulsoftware.com/infotree/queries.php.
PB
Kevin Waterson wrote:
I have 3 tables (schema below) with categories, questions and answers.
Each category can of course
The background:
We are doing replication. The file-system containing the SLAVE's
relay-log got filled to capacity. Later on, I noticed replication has
not been working for the last month or more.
My Action:
I deleted the 2 oldest relay-log then attempted to restart SLAVE. Now,
the SLAVE will not
you should probably just resync your slave. If it hasn't run for over a
month then there's not a lot of point in trying to start it up. Even if you
did start the slave (which seems doubtful) you'd have over a month's worth
of commands to make up.
You can tell mysql to not keep relay logs that
Hi,
I have a table containing 75 fields with a primary index and index set on 5
other fields. Everything is working fine so far as the table contains only
about 80,000 records. I expect these records to reach 500,000 by end of
september.
I would like to know:
- if the number of records will
On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote:
you should probably just resync your slave. If it hasn't run for over a
month then there's not a lot of point in trying to start it up. Even if
you
did start the slave (which seems doubtful) you'd have over a month's worth
of commands to make
Re: You can tell mysql to not keep relay logs that have already been
used.
What command does this
-Original Message-
From: David Giragosian [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2008 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: can some please help me -- REPLICATION
On
Here is what I'm getting
mysql change master to master_host = 'naxbmisq01.bmi.com', master_user
= 'repl', master_password = 'repl';
ERROR 1201 (HY000): Could not initialize master info structure; more
error messages can be found in the MySQL error log
mysql reset slave;
Query OK, 0 rows affected
This one time, at band camp, Peter Brawley [EMAIL PROTECTED] wrote:
See Within-group quotas (Top N per group) at
http://www.artfulsoftware.com/infotree/queries.php.
Yes, I have seen that, very clever. How does it relate to my situation?
Simply point to vague references is not helpful.
Kevin
How does it relate to my situation?
Simply point to vague references is not helpful.
Vague? Not in the slightest. General? Indeed, by design.
You'd written Any help in this matter hugely appreciated. If that's
not so, please feel free entirely ignore my suggestion.
PB
-
Kevin Waterson
This one time, at band camp, Peter Brawley [EMAIL PROTECTED] wrote:
Vague? Not in the slightest. General? Indeed, by design.
I have read this before..
It uses a single table, I am using multiple tables. I am not selecting
the TOP 10 or whatever. This example has no relationships where the
It uses a single table, I am using multiple tables. I am not selecting
the TOP 10 or whatever. This example has no relationships where the
schema I presented does.
Eh? We can treat any query as one derived table; it makes no difference
to the principle involved. And the same within-aggregate
On Sun, Aug 10, 2008 at 10:54 AM, Kevin Waterson [EMAIL PROTECTED] wrote:
I have 3 tables (schema below) with categories, questions and answers.
Each category can of course have many questions in it. Also, the
answers are multiple choice, so each question can have several
related answers. I am
14 matches
Mail list logo