Binary logfiles eating all my disk space

? 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

What causes this error, and how do i fix it?

reate/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: +

Information request

Hi all I would like to try and implement the MySQL socket protocol (or what ever you would call it), so that I can do all kinds of communication with a MySQL server, like normal SQL, MySQL environment variables, performance status, tables helth checks, and what ever is possible. The reson I need

UPDATE - What is wrong with this bloody MySQL?

64; Skipped 031009 16:39:15 Found block with too small length at 3495220; Skipped 031009 16:39:15 Found link that points at 3977292205389786673 (outside data file) at 3551436 031009 16:39:16 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replica

RE: What is wrong with this bloody MySQL?

] 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

RE: What is wrong with this bloody MySQL?

: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

What is wrong with this bloody MySQL?

15:34:33 Run recovery again without -q 031009 15:34:33 Note: Retrying repair of: './otamanager/profile' with keycache 031009 15:34:36 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.006' at position 1408472

Serious problem with replication

the problem machine. I have tried dropping the database, rebooting the machine, and creating a new database, no success. Please let me 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 ...

RE: Sudden error when replicationg - please help

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 +

RE: Sudden error when replicationg - please help

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 test

Sudden error when replicationg - please help

osition 357019 I have tried to do a "REPAIR TABLE otafrontenduser,profile EXTENDED;" but no success (its says ok, 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 ...

Does replication continue if master reboots?

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

Replication fails after reboot of master

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 - 80

Slave not replicating database

ssword/log-file/position. There are two 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 8620780

Fixed: The server is not configured as slave???

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='XX

The server is not configured as slave???

ile or with CHANGE MASTER TO What am i 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: +

Re[2]: Am I asking the wrong question?

uot;reload" it with some command? HS> ps: i would not send 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] -

Am I asking the wrong question?

| N| N | N | N | | N | N | +-+--+--+-+-+-+-+-+---+-+---+--+---++-----+++ -- Med venlig hilsen/Best regards,

Access error when trying to connect from Java

|| N | N | N | N | N | +-+--+--+-+-+-+-+-+---+-+---+--+---++-+----++ -- Med venlig hilsen/Best

Access error when trying to connect from Java

| N | N | N | N | +-+--+--+-+-+-+-+-+---+-+---+--+---++-++----+ -- Med venlig hilsen/Best regards, Søren Neigaard mailto:[EMAIL PROTE

Giving root access from another host?

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

SHOW GRANTS not returning anything?

your SQL syntax near '' at line 1 What am I doing wrong? -- Med venlig hilsen/Best regards, Søren Neigaard mailto:[EMAIL PROTECTED] -- "Everything should be made as simple as possible, but no simpler." ---