Re: drop table is written to bin-log, load table is NOT - why????

Hello Artem, thanks for your answer. For selective replication I would check startup options --replicate-do-* and --replicate-wild-*. I'm using replicate-do-db on the client but the problem is, that the master sends the sql-statements of ALL databases to the repl-client and the replicate-do-db-c

drop table is written to bin-log, load table is NOT - why????

p to date. Help would be appreciated Lutz Maibach EasyCom GmbH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to bring up local replication / socket-error

t;[EMAIL PROTECTED]> Sent: Tuesday, November 09, 2004 3:49 PM Subject: Re: How to bring up local replication / socket-error Hello. See: http://bugs.mysql.com/bug.php?id=3310 "Lutz Maibach" <[EMAIL PROTECTED]> wrote: Hi, I'm trying to set up a replication client on the same se

How to bring up local replication / socket-error

ock but only got a fatal error 1236: "Could not open logfile.." Help would be appreciated Greetz from Germany Lutz Maibach P.S: I only try to get up this strange looking constellation cause I have to replicate a single database from the master to a customers server. The customer ma

mysql 4.1: how to use old-passwords in my.cnf

e script, so I don't wanted to use --old-passwords as a commandline-parameter) but it seems to be useless. [mysqld] old-passwords What do I need to write into my.cnf to get the old clients connecting again? Greetings Lutz Maibach -- MySQL General Mailing List For list archives: http:/

mysqladmin extended-status: useless statistics when running server for a while?

happened after running the server only for 11 days. Greetings from Germany Lutz Maibach -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

relay_log_space_limit-entry kills replication

ode: 0 = Finally we commented the entries out, re-synchronised the databases manually and restarted replication. The ultimate question for us now is "why didn't mysql delete old relay-logs to get space to continue logging, like it is described in the Mysql documentattion"? I

Re: How to minimize Master-Slave Traffic during replication <- Activating slave_compressed_protocol question

mpressed protocol? Greetings Lutz Maibach - Original Message - From: "Sasha Pachev" <[EMAIL PROTECTED]> To: "Lutz Maibach" <[EMAIL PROTECTED]> Cc: "mysql Liste" <[EMAIL PROTECTED]> Sent: Thursday, March 11, 2004 11:32 PM Subject: Re: How

How to minimize Master-Slave Traffic during replication?

sfully and can tell me, where I can see, whether the slave recognized this switch and do I have to set this switch on the server too? Greetings Lutz Maibach -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Inserting One new User = 2 entries in mysql.user when using MySQL 4.0.17?!

o create a new user every time I granted rights to an user, whether it was existing or not. Greetings Lutz - Original Message - From: "Lutz Maibach" <[EMAIL PROTECTED]> To: "mysql Liste" <[EMAIL PROTECTED]> Sent: Monday, January 26, 2004 3:01 PM Subj

Inserting One new User = 2 entries in mysql.user when using MySQL 4.0.17?!

+---+--- --+-+ "User 1" got the right privileges while "User 2" haven't got a single privilege. Anyone knows what's going wrong? Greetings from Germany L

Unexpected shutdown of MySQL4.0.17

wondering why Mysql didn't restart after the unexpected shutdown and if something is wrong in the new acutal safe_mysqld? Greetings Lutz Maibach -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Starting mysqld within SuSE 8.0

. For more infos you should look here -> http://sdb.suse.de/de/sdb/html/start_foo80.html Greetings from Hessen/Germany Lutz Maibach EasyCom GmbH - Before posting, please check: http://www.mysql.com/manual.php

Re: hi

Greetings Lutz Maibach - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsu

Rename Table in Replication failed / command missing in slave log

ng to find out whether the Rename-Statement works right or not I did some tests with renaming a table but all actions were performed on the slaves too. Has someone experienced the same? I'm now a bit unsure whether the replication is working right. Greetings from Germany Lu

Error using 'select...into outfile'

Hi, I'm trying to do the following: select * into outfile '/tmp/data.txt' fields terminated by';' from customer Although the mysql-user has all privileges (except the grant priv) on the database and the file_priv in the user table I get an 'Access denied for user..' when executing the select fr

Aborted connection using myodbc

on packets) 020215 16:48:47 Aborted connection 22968 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got timeout reading communication packets) Does anybody know what to do to stop this aborted connections? It's nearly impossible to send or receive larger

Maximum parallel Users on MySQL

Hi, is there a limit of concurrent connections or threads in MySQL? What do I have to consider when many users (500 - 1000) want to use MySQL at the same time? Greetings from Germany Lutz Maibach EasyCom GmbH

Re: Visual Foxpro 6

lds from the table structure. If you got a tabelle with a million rows (like we do) you can spend much time in drinking coffee and walking around before you get this dialog. So create the views on an empty table and fill them after creating the view. Greetings from

mysql.pm or dbi, that's the question

ed to implement new code with the DBI Drivers". Is this a "must do" or only a "can do"? Will there be a dramatic change in DBI so Mysql.pm wouldn't be able to use it anymore? Questions, so many questions. Anyone out there who got some reassuring answers for me? :-) Greetings Lutz Maibach

Using Mysql.pm with a different port

esn't work. Trying to set the port for the DBI-Connect in Mysql.pm failed too. We can't use DBI instead of mysql.pm cause we're using the mysql.pm- Query subroutine in almost every script (>100). Greetings from Germany Lutz Maibach