?
Can I get MySQL to cleanup these files automatically?
Med venlig hilsen/Best regards
Søren Neigaard
System Architect
Mobilethink A/S
Arosgaarden
Åboulevarden 23, 4.sal
DK - 8000 Århus C
Telefon: +45 86207800
Direct: +45 86207810
Fax: +45 86207801
Email: [EMAIL
/write to file '/root/tmp/#sql_1e8_0.MYI' (Errcode: 13)
But why and what can I do?
Med venlig hilsen/Best regards
Søren Neigaard
System Architect
Mobilethink A/S
Arosgaarden
Åboulevarden 23, 4.sal
DK - 8000 Århus C
Telefon: +45 86207800
Direct: +45 86207810
Fax
]
Sent: 9. oktober 2003 17:19
To: Søren Neigaard; [EMAIL PROTECTED]
Subject: Re: What is wrong with this bloody MySQL?
Hi,
i suppose you do the necessary GRANTS on the master (before executing
LOAD
DATA FROM MASTER) as :
- file
- super
- reload
- select (on all tables you want to load)
If not do
that points at 3977292205389786673 (outside data
file) at 3551436
031009 16:39:16 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at
posit
ion 1535724
Med venlig hilsen/Best regards
Søren Neigaard
System Architect
know if I need to supply more info, I have no idea on what to
do next.
Med venlig hilsen/Best regards
Søren Neigaard
System Architect
Mobilethink A/S
Arosgaarden
Åboulevarden 23, 4.sal
DK - 8000 Århus C
Telefon: +45 86207800
Direct: +45 86207810
Fax: +45 86207801
15:34:36 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at
position 1408472
Is there really nothing to do here, what the hell is the problem with MySQL?
Med venlig hilsen/Best regards
Søren Neigaard
System Architect
:28
To: Søren Neigaard; [EMAIL PROTECTED]
Subject: Re: What is wrong with this bloody MySQL?
Hi,
can you indicates your configuration about :
- my.cnf
- all tables type your using in the master (MyISAM, INNODB, BDB)
This may help to see what goes wrong .
Regards
Thierno 6C - MySQL 4.0.15
, but the replication does still not work).
Why and what are these errors, and what can I do?
Med venlig hilsen/Best regards
Søren Neigaard
System Architect
Mobilethink A/S
Arosgaarden
Åboulevarden 23, 4.sal
DK - 8000 Århus C
Telefon: +45 86207800
Direct: +45
No its Redhat, and i have made absolutly no updates :(
-Original Message-
From: Ben Edwards [mailto:[EMAIL PROTECTED]
Sent: 8. oktober 2003 15:23
To: Søren Neigaard
Cc: '[EMAIL PROTECTED]'
Subject: Re: Sudden error when replicationg - please help
you are not using Debian testing by any
I attached the output from show slave status.
/Søren
-Original Message-
From: Dicky 'Mas Saint' [mailto:[EMAIL PROTECTED]
Sent: 8. oktober 2003 15:28
To: [EMAIL PROTECTED]
Subject: Re: Sudden error when replicationg - please help
Pada Wed, 8 Oct 2003 15:13:00 +0200
Søren Neigaard
What happends if the master reboots, does the slave start replicating again
after the reboot?
Med venlig hilsen/Best regards
Søren Neigaard
System Architect
Mobilethink A/S
Arosgaarden
Åboulevarden 23, 4.sal
DK - 8000 Århus C
Telefon: +45 86207800
Direct: +45
special after a reboot?
I have now done a LOAD DATA FROM MASTER; on the machine that was not
rebooted, and now it works again.
Med venlig hilsen/Best regards
Søren Neigaard
System Architect
Mobilethink A/S
Arosgaarden
Åboulevarden 23, 4.sal
DK - 8000 Århus C
Telefon
missing here, i have done the CHANGE MASTER TO??
Med venlig hilsen/Best regards
Søren Neigaard
System Architect
Mobilethink A/S
Arosgaarden
Åboulevarden 23, 4.sal
DK - 8000 Århus C
Telefon: +45 86207800
Direct: +45 86207810
Fax: +45 86207801
Email: [EMAIL PROTECTED]
Web
Well after a restart of the server, it seemed to work??
-Original Message-
From: Søren Neigaard [mailto:[EMAIL PROTECTED]
Sent: 18. september 2003 09:45
To: '[EMAIL PROTECTED]'
Subject: The server is not configured as slave???
I did a:
CHANGE MASTER TO MASTER_HOST='XXX', MASTER_USER
databases on the master, but they do not get replicated to the
slave? Why not?
Med venlig hilsen/Best regards
Søren Neigaard
System Architect
Mobilethink A/S
Arosgaarden
Åboulevarden 23, 4.sal
DK - 8000 Århus C
Telefon: +45 86207800
Direct: +45 86207810
Fax: +45 86207801
|
+-+--+--+-+-+-+-+-+---+-+---+--+---++-+++
--
Med venlig hilsen/Best regards,
Søren Neigaard mailto:[EMAIL PROTECTED]
--
Mind what you have learned. Save you it can
original passwords to such a list - one should
HS always black out things like that...
Point taken :)
--
Med venlig hilsen/Best regards,
Søren Neigaard mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com
|
+-+--+--+-+-+-+-+-+---+-+---+--+---++-+++
--
Med venlig hilsen/Best regards,
Søren Neigaard mailto:[EMAIL PROTECTED]
--
Mind what you have learned. Save you it can
|
+-+--+--+-+-+-+-+-+---+-+---+--+---++-+++
--
Med venlig hilsen/Best regards,
Søren Neigaard mailto:[EMAIL PROTECTED]
--
Mind what you have
doing wrong?
--
Med venlig hilsen/Best regards,
Søren Neigaard mailto:[EMAIL PROTECTED]
--
Everything should be made as simple as possible, but no simpler.
-
Before posting, please check:
http://www.mysql.com/manual.php
I want to try out MySQL-GUI from my workstation, and I want to connect
to my database server, but it says that root has no access rights from
this host. How do I give root this kind of acccess?
--
Med venlig hilsen/Best regards,
Søren Neigaard mailto:[EMAIL PROTECTED]
--
Sometimes I think
21 matches
Mail list logo