This is also what I want to know.
Waiting for somebody's help.
On Thu, Jan 17, 2008 at 12:39 AM, Britske <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I have a partitioned table using hash. For the example lets say I have N
> partitions. Selects perform well due to the partitioning. However I
> noticed
Replication is a complicated process.I can't see what you do and what happened
for your computer.
From you description,i think you maybe save some old file in your entironment
and some configer parmater point to it.
So,the best way is sending you actions to me step by step and we will analyse
wh
Hi All,
The issue has been solved, we removed relay-log.index files which was
refering to the old relay-log file. After this the CHANGE MASTER worked and
replication is going on fine.
regards
anandkl
On 5/24/08, Moon's Father <[EMAIL PROTECTED]> wrote:
>
> I think you should check the error wit
Also,
The below method will not add it the default values for date's and also will
create the indexes and if any column is set as auto increment, that also
need to be take care.
So, is there a way to take care of the above, in the create table statement
itself.
regards
anandkl
On 5/26/08, Moon'
Just execute as the following.
1、create table b like a;
2、alter table b add ;
3、insert into b select a.
4、alter table b rename to a;
On Wed, Apr 16, 2008 at 11:08 PM, Arun Kumar PG <[EMAIL PROTECTED]>
wrote:
> given that my table is in myisam, there are some hacky way of doing this
> (ref
Is there anyway of doing what is described below with version 5 or will
I l have to wait for MySQL 6.0
PlanetMySQL Blog: MySQL 6.0 Feature #2: Online Backup
Alexander Nozdrin, Chuck Bell, Lars Thalmann, Peter Gulutzan, Rafal Somla
BACKUP DATABASE copies all data and metadata in on
On May 15, 2008, at 4:30 AM, rustam ershtukaev wrote:
I have been trying to write a trigger in mysql, but can't get it to
work. It's really simple,i just need my trigger to add varchar value
to
a table on insert if postcode = 1000.
Where does postcode come from? Your SELECT statement appea
On May 15, 2008, at 1:38 PM, afan pasalic wrote:
hi,
I have a table with tasks. column "status" could be 1 (means "todo")
and
0 (meas "done").
also,have column "order_no" to sort tasks by priorities.
once in a while order_no is not "in order", e.g 1, 2, 3, 5, 6, 8, 11,
12, 13, 19, 20,... (so
On Fri, May 23, 2008 at 11:20 PM, Velen <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I wanted to know when doing a select query how is it executed :
>
>
> If there is 1000 records with price<10, 3000 records with flag='Y' and the
> table contains 200,000 records.
>
> Select code, description, price, flag
Hi people.
This is my first thread, i hope you can help me.
I'm a newbie and my english is so bad, but, i hope you can understand me.
this is my question:
I've a table TURN with this field
IDTURN (int)
SEASON (string)
SORT (string)
another table GROUP
IDGROUP (int)
IDTURN (int)
a table MATCH
ID
10 matches
Mail list logo
