Newbie - View several databases as one

Hello, I have an application that stores the information in several MySql databases and I am starting to look at the information and I found a problem. Information is stored everyday in threed different sessions. Each session creates a new database with several tables in it. The problem is that

Re: Master Switch (Or Write by SQL_THREAD only)

Is there a way to allow the SQL_THREAD to write while holding everything else ? iptables -A INPUT -p tcp --dport 3306 -s MASTER_IP -j ACCEPT iptables -A INPUT -p tcp --dport 3306 -j REJECT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:

RE: Weird error with stored function

Hi, It seems that the problem was the following: In mysql_stmt_execute() sp_cache_flush_obsolete() is called to flush the statement cache (or something similar). But the proper sp_cache_routines_and_add_tables() functions won't be called from open_tables(), because thd->lex->query_tables_own_las

mysql_fetch_row problem

Hello all! Im am programming on С++ for mysql. I've got a problem with mysql_fetch_row() function. When I want to make a query foe MySQL server I do this: mysql_real_query() then mysql_store_result() and then mysql_fetch_row() All was well, but today my program has fallen with an error

Re: How to keep myqsl backup server

I need to create an application where i will be requiring a backup server like when one server fails i can switch automatically to the other server hosted somewhere else , now the data needs to be consistent on both the servers, one sol is i keep automated backups on the primary server and restore

Das offizielle MySQL 5 Handbuch

If you don't understand the title of this announcement then you're probably not exactly the target group I'm aiming at, but still I'd like to inform you about a new MySQL Press book that's just hit the shelves of the bookstores: Das offizielle MySQL 5 Handbuch. As you might have guessed, that's the

RE: mysqldumpslow output interpretation

Hi List, Any update on this Thanks Anil Hi List, Below is the output of mysqldumpslow. In the output query execution time is showing -ve value how to interpret the below output i.e how to interpret -ve value for query execution time please advice Count: 1 Time=4294967223.00s

WTO ISCO database

Does anyone has a database dump of the World Trade Organisation’s International Standard Classification of Occupation. -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra

Having Problem With Load Files and AutoNumber id fields

Argh... I am autogenerating a load file after parsing and massaging a text file I get from an AS/400 system. My first field is an id that is on auto_number so I put a tab at the begging of the line for each one of my records... it throws a warning for each line... if instead of putting an autonu

Re: Newbie - View several databases as one

On 11/24/06, Algomez <[EMAIL PROTECTED]> wrote: Hello, I have an application that stores the information in several MySql databases and I am starting to look at the information and I found a problem. Information is stored everyday in threed different sessions. Each session creates a new databas