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

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

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

, 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 server as the master is running. Master is port 3306 and its socket

How to bring up local replication / socket-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 may not have a look at the other databases running

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

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://lists.mysql.com/mysql

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

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

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? Is this a bug and, if so, is it solved in the actual version of mysql 4.0? Greetings Lutz Maibach

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

a mysqld --help to see the standard values for the variables, I see slave_compressed_protocol FALSE. Do I have to start mysqld with an entry like slave_compressed_protocol=ON in my.cnf or something like this to get the master running with a compressed protocol? Greetings Lutz Maibach

How to minimize Master-Slave Traffic during replication?

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?!

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 Subject: Inserting One new User = 2 entries in mysql.user

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

1 got the right privileges while User 2 haven't got a single privilege. Anyone knows what's going wrong? Greetings from Germany Lutz Maibach -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Starting mysqld within SuSE 8.0

://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 (the manual) http://lists.mysql.com/ (the list

Rename Table in Replication failed / command missing in slave log

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 Lutz Maibach

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

Aborted connection using myodbc

nearly impossible to send or receive larger amounts of data when manipulating tables using ODBC. Greetings from Germany Lutz Maibach - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

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

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 cloudy Germany Lutz Maibach EasyCom GmbH