startup problem on mysql 5.0.45
After a shutdown regular on my mysql master, when the mysql process startup apper the error below 070802 16:07:08 [Warning] The syntax for replication startup options is deprecat ed and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead. 070802 16:07:10 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 070802 16:07:11 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 31 1653757185. InnoDB: Doing recovery: scanned up to log sequence number 31 1653757205 InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 0 row operations to undo InnoDB: Trx id counter is 0 864831488 InnoDB: Last MySQL binlog file position 0 624186576, file name .\morisot-bin.000 184 InnoDB: Starting in background the rollback of uncommitted transactions InnoDB: Cleaning up trx with id 0 864830109 070802 16:07:11InnoDB: Assertion failure in thread 3856 in file .\fsp\fsp0fsp.c line 3204 InnoDB: Failing assertion: xdes_get_bit(descr, XDES_FREE_BIT, buf_frame_get_page _no(header) % FSP_EXTENT_SIZE, mtr) == FALSE InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html InnoDB: about forcing recovery. InnoDB: Thread 1472 stopped in file .\os\os0thread.c line 122 InnoDB: Thread 2752 stopped in file .\os\os0sync.c line 532 If I add in my.ini the words innodb_force_recovery =3 mysql start in read only mode, but with the possibility to execute a global dump. But the dump file are correct (there are 4 innodb dbs)? How it is possible to define in which table of the unique dump file there is the error ? Many thanks in advance Massimo Someboby can help to find which is the problem ?
descending index
When this limit will be removed ? from 5.1 manual (13.1.4) An index_col_name specification can end with ASC or DESC. These keywords are allowed for future extensions for specifying ascending or descending index value storage. Currently they are parsed but ignored; index values are always stored in ascending order. Many thanks --- Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED]
remote connection with 4.0.22 on win32
I upgraded my server to 4.0.22 from 4.0.17. The server itselfs runs correctly (it is a slave member of my domain). But if I try to connect from a remote client with mysql administrator, I receive this error: Could not connect to the specified instance Mysql error number 1130 Host name is not allowed to connect tothis MYSQL sever The ping result correct. Which is my configuration error ? (see my.ini below) Thanks Massimo -- # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable=key_buffer=16K set-variable=max_allowed_packet=16M set-variable=thread_stack=64K set-variable=table_cache=4 set-variable=sort_buffer=1024K set-variable=net_buffer_length=2K #PARTE PER REPLICA server-id=33 master-host=SEURAT report-host=SEURAT master-user=root replicate-wild-ignore-table=OMTWRK.WRK_% replicate-wild-ignore-table=omtwrk.wrk_% set-variable=slave-net-timeout=172800 #skip-slave-start # Uncomment the following if you want to log updates #log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir=C:\mysql\ #datadir=C:\AnnaNoBck\DATI\MySQL\data\ datadir=D:\mysql\Data\ log-error=d:\mysql\data\mysql.err # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using Innobase tables innodb_data_file_path=\InnoData\HymnOMT:10M:autoextend #innodb_data_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB #innodb_log_group_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog #innodb_log_arch_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog innodb_data_home_dir=D:\mysql\InnoDB innodb_log_group_home_dir=D:\mysql\InnoDB\InnoLog innodb_log_arch_dir=D:\mysql\InnoDB\InnoLog set-variable=innodb_mirrored_log_groups=1 set-variable=innodb_log_files_in_group=3 set-variable=innodb_log_file_size=5M set-variable=innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable=innodb_buffer_pool_size=16M set-variable=innodb_additional_mem_pool_size=16M set-variable=innodb_file_io_threads=4 set-variable=innodb_lock_wait_timeout=50 default-table-type=innodb [mysqldump] quick set-variable=max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable=key_buffer=8M set-variable=sort_buffer=8M [myisamchk] set-variable=key_buffer=8M set-variable=sort_buffer=8M [mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-max-nt.exe - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
CORRECT WAY TO SQUEEZE INNODB 4.0.17
I my network I have 1 master and 4 slaves. I need to squeeze the innodb on my master; which is the correct way to execute the squeeze action (now the innodb files is around 1gb, while in a new db is around 300 mB) thanks Massimo - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
upgrading from 4.0.20 to 4.1.4 on windows
A little question on my slave upgrade. In the log is see as an error whne my slave is connecting to my master. See below Is all normal ? Meanwhile I run the fix suggested for password . Thanks Massimo --- InnoDB: Resetting space id's in the doublewrite buffer 040902 17:50:08 InnoDB: Started; log sequence number 14 660630550 InnoDB: You are upgrading to an InnoDB version which allows multiple InnoDB: tablespaces. Wait that purge and insert buffer merge run to InnoDB: completion... InnoDB: Full purge and insert buffer merge completed. InnoDB: You have now successfully upgraded to the multiple tablespaces InnoDB: format. You should NOT DOWNGRADE again to an earlier version of InnoDB: InnoDB! But if you absolutely need to downgrade, see section 4.6 of InnoDB: http://www.innodb.com/ibman.php for instructions. 040902 17:50:10 [ERROR] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run 040902 17:50:10 [ERROR] Warning: Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them MySql: ready for connections. Version: '4.1.4-gamma-nt-max' socket: '' port: 3306 Source distribution 040902 17:50:10 [ERROR] Slave SQL thread initialized, starting replication in log 'seurat-bin.155' at position 291988391, relay log '.\dirsta-relay-bin.040' position: 169022558 040902 17:50:10 [ERROR] Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'seurat-bin.155' at position 291988391 040902 18:11:43 [ERROR] MySql: Normal shutdown 040902 18:11:43 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 040902 18:11:43 [ERROR] Slave I/O thread killed while reading event 040902 18:11:43 [ERROR] Slave I/O thread exiting, read up to log 'seurat-bin.155', position 292423012 040902 18:11:43 [ERROR] Error reading relay log event: slave SQL thread was killed 040902 18:11:44 [ERROR] MySql: Forcing close of thread 13 user: 'root' 040902 18:11:44 InnoDB: Starting shutdown... 040902 18:11:46 InnoDB: Shutdown completed; log sequence number 14 660659733 040902 18:11:46 [ERROR] MySql: Shutdown complete 040902 18:11:52 InnoDB: Started; log sequence number 14 660659733 MySql: ready for connections. Version: '4.1.4-gamma-nt-max' socket: '' port: 3306 Source distribution 040902 18:11:52 [ERROR] Slave SQL thread initialized, starting replication in log 'seurat-bin.155' at position 292423012, relay log '.\dirsta-relay-bin.41' position: 434666 040902 18:11:52 [ERROR] Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'seurat-bin.155' at position 292423012 - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
4.0.20 WINDOWS VERSION
When it will be avalaible to download ? regards massimo - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
description of a field on mysql
From which version it will be avalaible the possibility to define a descriptor of a field (column) ? From example if I define a column as CUSTOMER, I need to add a description for which customer is this column, as in microsoft office, sql. tks in advance Massimo - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR ON FOREIGN KEY ON WINDOWS 2000 WITH MYSQL 4.0.18
Somebody can help me ? If you run the above code in a new db named prova, the last line create then error Can't create table '.\prova\#sql-654_2e.frm' (errno: 121) If you run the code on 4.0.17 all it is ok. Tks in advance Massimo CREATE TABLE RevisioniSL(SchedaLavoro CHAR(8) NOT NULL,NRev SMALLINT NOT NULL,DataRevisione DATETIME NULL,DescrizioneRev CHAR(255) NULL,IdaReg DATETIME NULL,IdaVar DATETIME NULL,UserReg CHAR(30) NULL,UserVar CHAR(30) NULL,WStatReg CHAR(30) NULL,WStatVar CHAR(30) NULL, PRIMARY KEY (SchedaLavoro, NRev)) ALTER TABLE RevisioniSL ADD LIFEBELT TIMESTAMP CREATE TABLE schedelavoro(SchedaLavoro CHAR(8) NOT NULL,Articolo CHAR(19) NULL,Operazione CHAR(4) NULL,DataRilascio DATETIME NULL,Lotto CHAR(10) NULL,DataConsOfficina DATETIME NULL,DataAccettazOfficina DATETIME NULL,DataRitiro DATETIME NULL,NoteRitiro TEXT NULL,IDUSL INT NULL,IdaUltAggAS DATETIME NULL,AS400 SMALLINT NULL,IdaReg DATETIME NULL,IdaVar DATETIME NULL,UserReg CHAR(30) NULL,UserVar CHAR(30) NULL,WStatReg CHAR(30) NULL,WStatVar CHAR(30) NULL, PRIMARY KEY (SchedaLavoro)) ALTER TABLE schedelavoro ADD LIFEBELT TIMESTAMP CREATE TABLE TabUbicazioneSL(IDUSL INT NOT NULL AUTO_INCREMENT,UbicazioneSL CHAR(20) NULL,IdaReg DATETIME NULL,IdaVar DATETIME NULL,UserReg CHAR(30) NULL,UserVar CHAR(30) NULL,WStatReg CHAR(30) NULL,WStatVar CHAR(30) NULL, PRIMARY KEY (IDUSL)) ALTER TABLE TabUbicazioneSL ADD LIFEBELT TIMESTAMP CREATE INDEX ArtOper ON schedelavoro (Articolo, Operazione) CREATE INDEX IDUSL ON schedelavoro (IDUSL) CREATE UNIQUE INDEX UbicazioneSL ON TabUbicazioneSL (UbicazioneSL) CREATE INDEX SchedaLavoro ON RevisioniSL (SchedaLavoro) ALTER TABLE RevisioniSL ADD CONSTRAINT FOREIGN KEY (SchedaLavoro) REFERENCES schedelavoro (SchedaLavoro) ON DELETE CASCADE ALTER TABLE schedelavoro ADD CONSTRAINT FOREIGN KEY (IDUSL) REFERENCES TabUbicazioneSL (IDUSL) - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: temporary table in 4.0.17 on Windows W2000 and NT4 from client running xp TIMEOUT PROBLEMS
FOUND ! After many days to search the solution we found it ! The problem is solved in the computer runnig microsoft jet 3.5. You must change to 0 then values in the registry key hkey_local\machine\software\microsoft\jet\3.5\engines\odbc; se the dword ConnectionTimeout. The default is 600 in decimal as the second numbers. If you put 0 the temporary table remain always active. wonderful ! Massimo - Original Message - From: Mikhail Entaltsev [EMAIL PROTECTED] To: Massimo Petrini [EMAIL PROTECTED] Cc: MySQL list [EMAIL PROTECTED] Sent: Friday, January 23, 2004 6:20 PM Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 from client running xp Hi, 1) Try to reproduce the situation with pure myscl client (command-line client). 2) There is no any MySQL parameter that change life time of temporary tables. Only two parameter that defines life time for connection to mysql: - interactive_timeout The number of seconds the server waits for activity on an interactive connection before closing it. An interactive client is defined as a client that uses the CLIENT_INTERACTIVE option to mysql_real_connect(). See also wait_timeout. - wait_timeout The number of seconds the server waits for activity on a not interactive connection before closing it. On thread startup SESSION.WAIT_TIMEOUT is initialized from GLOBAL.WAIT_TIMEOUT or GLOBAL.INTERACTIVE_TIMEOUT depending on the type of client (as defined by the CLIENT_INTERACTIVE connect option). See also interactive_timeout. But by default they are quite big: 28800 seconds. Mikhail. - Original Message - From: Massimo Petrini [EMAIL PROTECTED] To: Mikhail Entaltsev [EMAIL PROTECTED] Sent: Friday, January 23, 2004 5:11 PM Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 from client running xp 1) yes, I am sure because the problem is reproducible also with a sql , without to use the msaccess; if you use mysqlfront you can create the table, insert data, view data. But if you move your point of view on another table you lost the connection. 2) to connect a temporary table in mysql from msaccess, it is necessary to create the table on server not temporary, connect the table from msaccess, drop the table on server; this is necessary only once; after use a sql statement from msaccess, via sql pass through to create the temporary. Now youn can insert data and use as a normal table. When you close the msaccess session the temporary table is dropped immediately; otherwise if you leave the session msaccess opened, but not in use, after some minutes the table is dropped. I think there is a variable to set in my.ini, but I don't understand which is the correct name . So I don't understand. - Original Message - From: Mikhail Entaltsev [EMAIL PROTECTED] To: Massimo Petrini [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 2:16 PM Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 2 questions: 1. Are you sure that client or someone between client and MySQl server doesn't close connection? Because the client have still the result of the query on the screen is not a proof that connection is still active. 2. How do you link your msaccess application with MySQL server? Are you sure that your application or someone between doesn't use connections pool? Mikhail. - Original Message - From: Massimo Petrini [EMAIL PROTECTED] To: Mikhail Entaltsev [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 1:35 PM Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 We have a server running NT4 with mysql 4.017 (with the my.ini as in previuous mail). In the network the client (the single pc ) run msaccess application linked to mysql database. In such case we use a temporary table, created as follow CREATE TEMPORARY TABLE wrk_AlzateIntervalli(Lotto CHAR(10) NOT NULL,Indice CHAR(3) NOT NULL,NMisura SMALLINT NOT NULL,IndiceIntv CHAR(1) NOT NULL,ValMin REAL NULL,ValMax REAL NULL, PRIMARY KEY (Lotto, Indice, NMisura, IndiceIntv)); The statement sql is lunched from the client to the server; it create a temporary table used only from the client creator. Is clear for you ? Thanks - Original Message - From: Mikhail Entaltsev [EMAIL PROTECTED] To: Massimo Petrini [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:12 AM Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 no; because the client have still the result of the query on the screen and on the server the thread is still existent in sleep mode. could you explain in details what is your system configuration? what is the client of MySQL server? - Original Message
Re: temporary table in 4.0.17 on Windows W2000 and NT4
no; because the client have still the result of the query on the screen and on the server the thread is still existent in sleep mode. - Original Message - From: Mikhail Entaltsev [EMAIL PROTECTED] To: Massimo Petrini [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 10:05 AM Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 Hi Massimo, May be after some minutes of inactivity client closes connection to MySQL server? In this case MySQL deletes all temp tables that were created by this client. Best regards, Mikhail. - Original Message - From: Massimo Petrini [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 7:30 AM Subject: temporary table in 4.0.17 on Windows W2000 and NT4 We have a problem to have a long life for the temporary table on innodb mode. We create the table, but after some minutes of inactivity the sistem drops the table. My.ini in as follow. Which is the parameter to correct the problem ? Tks Massimi - # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable=key_buffer=16K set-variable=max_allowed_packet=16M set-variable=thread_stack=64K set-variable=table_cache=4 set-variable=sort_buffer=1024K set-variable=net_buffer_length=2K #PER REPLICA server-id=19 master-host=pissarro report-host=pissarro master-user=root #skip-slave-start replicate-wild-ignore-table=OMTWRK.WRK_% replicate-wild-ignore-table=omtwrk.wrk_% set-variable=slave-net-timeout=172800 # Uncomment the following if you want to log updates #log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir=C:\mysql\ #datadir=C:\AnnaNoBck\DATI\MySQL\data\ datadir=D:\applicaz\mysql\Data\ # log-error=d:\applicaz\mysql\data\mysql.err # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using Innobase tables innodb_data_file_path=\InnoData\HymnOMT:10M:autoextend #innodb_data_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB #innodb_log_group_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog #innodb_log_arch_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog innodb_data_home_dir=D:\applicaz\mysql\InnoDB innodb_log_group_home_dir=D:\applicaz\mysql\InnoDB\InnoLog innodb_log_arch_dir=D:\applicaz\mysql\InnoDB\InnoLog set-variable=innodb_mirrored_log_groups=1 set-variable=innodb_log_files_in_group=3 set-variable=innodb_log_file_size=5M set-variable=innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable=innodb_buffer_pool_size=16M set-variable=innodb_additional_mem_pool_size=10M set-variable=innodb_file_io_threads=4 set-variable=innodb_lock_wait_timeout=50 default-table-type=innodb #solo =4.0.14 permette di mantenere alla definizione di max_binlog_size la dimensione del file di relay #set-variable=max_relay_log_size=0 [mysqldump] quick set-variable=max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable=key_buffer=8M set-variable=sort_buffer=8M [myisamchk] set-variable=key_buffer=8M set-variable=sort_buffer=8M [mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-max-nt.exe QueryInterval=10 - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: temporary table in 4.0.17 on Windows W2000 and NT4
We have a server running NT4 with mysql 4.017 (with the my.ini as in previuous mail). In the network the client (the single pc ) run msaccess application linked to mysql database. In such case we use a temporary table, created as follow CREATE TEMPORARY TABLE wrk_AlzateIntervalli(Lotto CHAR(10) NOT NULL,Indice CHAR(3) NOT NULL,NMisura SMALLINT NOT NULL,IndiceIntv CHAR(1) NOT NULL,ValMin REAL NULL,ValMax REAL NULL, PRIMARY KEY (Lotto, Indice, NMisura, IndiceIntv)); The statement sql is lunched from the client to the server; it create a temporary table used only from the client creator. Is clear for you ? Thanks - Original Message - From: Mikhail Entaltsev [EMAIL PROTECTED] To: Massimo Petrini [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:12 AM Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 no; because the client have still the result of the query on the screen and on the server the thread is still existent in sleep mode. could you explain in details what is your system configuration? what is the client of MySQL server? - Original Message - From: Massimo Petrini [EMAIL PROTECTED] To: Mikhail Entaltsev [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:08 AM Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 no; because the client have still the result of the query on the screen and on the server the thread is still existent in sleep mode. - Original Message - From: Mikhail Entaltsev [EMAIL PROTECTED] To: Massimo Petrini [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 10:05 AM Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 Hi Massimo, May be after some minutes of inactivity client closes connection to MySQL server? In this case MySQL deletes all temp tables that were created by this client. Best regards, Mikhail. - Original Message - From: Massimo Petrini [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 7:30 AM Subject: temporary table in 4.0.17 on Windows W2000 and NT4 We have a problem to have a long life for the temporary table on innodb mode. We create the table, but after some minutes of inactivity the sistem drops the table. My.ini in as follow. Which is the parameter to correct the problem ? Tks Massimi - # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable=key_buffer=16K set-variable=max_allowed_packet=16M set-variable=thread_stack=64K set-variable=table_cache=4 set-variable=sort_buffer=1024K set-variable=net_buffer_length=2K #PER REPLICA server-id=19 master-host=pissarro report-host=pissarro master-user=root #skip-slave-start replicate-wild-ignore-table=OMTWRK.WRK_% replicate-wild-ignore-table=omtwrk.wrk_% set-variable=slave-net-timeout=172800 # Uncomment the following if you want to log updates #log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir=C:\mysql\ #datadir=C:\AnnaNoBck\DATI\MySQL\data\ datadir=D:\applicaz\mysql\Data\ # log-error=d:\applicaz\mysql\data\mysql.err # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using Innobase tables innodb_data_file_path=\InnoData\HymnOMT:10M:autoextend #innodb_data_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB #innodb_log_group_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog #innodb_log_arch_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog innodb_data_home_dir=D:\applicaz\mysql\InnoDB innodb_log_group_home_dir=D:\applicaz\mysql\InnoDB\InnoLog innodb_log_arch_dir=D:\applicaz\mysql\InnoDB\InnoLog set-variable=innodb_mirrored_log_groups=1 set-variable=innodb_log_files_in_group=3 set-variable=innodb_log_file_size=5M set-variable=innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable=innodb_buffer_pool_size=16M set-variable=innodb_additional_mem_pool_size=10M set-variable=innodb_file_io_threads=4 set-variable=innodb_lock_wait_timeout=50 default-table-type=innodb #solo =4.0.14 permette di mantenere alla definizione di max_binlog_size la dimensione del
temporary table in 4.0.17 on Windows W2000 and NT4
We have a problem to have a long life for the temporary table on innodb mode. We create the table, but after some minutes of inactivity the sistem drops the table. My.ini in as follow. Which is the parameter to correct the problem ? Tks Massimi - # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable=key_buffer=16K set-variable=max_allowed_packet=16M set-variable=thread_stack=64K set-variable=table_cache=4 set-variable=sort_buffer=1024K set-variable=net_buffer_length=2K #PER REPLICA server-id=19 master-host=pissarro report-host=pissarro master-user=root #skip-slave-start replicate-wild-ignore-table=OMTWRK.WRK_% replicate-wild-ignore-table=omtwrk.wrk_% set-variable=slave-net-timeout=172800 # Uncomment the following if you want to log updates #log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir=C:\mysql\ #datadir=C:\AnnaNoBck\DATI\MySQL\data\ datadir=D:\applicaz\mysql\Data\ # log-error=d:\applicaz\mysql\data\mysql.err # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using Innobase tables innodb_data_file_path=\InnoData\HymnOMT:10M:autoextend #innodb_data_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB #innodb_log_group_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog #innodb_log_arch_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog innodb_data_home_dir=D:\applicaz\mysql\InnoDB innodb_log_group_home_dir=D:\applicaz\mysql\InnoDB\InnoLog innodb_log_arch_dir=D:\applicaz\mysql\InnoDB\InnoLog set-variable=innodb_mirrored_log_groups=1 set-variable=innodb_log_files_in_group=3 set-variable=innodb_log_file_size=5M set-variable=innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable=innodb_buffer_pool_size=16M set-variable=innodb_additional_mem_pool_size=10M set-variable=innodb_file_io_threads=4 set-variable=innodb_lock_wait_timeout=50 default-table-type=innodb #solo =4.0.14 permette di mantenere alla definizione di max_binlog_size la dimensione del file di relay #set-variable=max_relay_log_size=0 [mysqldump] quick set-variable=max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable=key_buffer=8M set-variable=sort_buffer=8M [myisamchk] set-variable=key_buffer=8M set-variable=sort_buffer=8M [mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-max-nt.exe QueryInterval=10 - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
master and slave
I am using 1 master (4.0.13 named PISSARRO ) and 3 slaves (4.0.15); of course the my.ini are different in the master and slaves. Today for an error (I thinked to be on my slave) I executed in sequence these commands: change master to master_host='pissarro',master_user='root',master_password='',master_log_file ='pissarro-bin.313',MASTER_LOG_POS=4 SLAVE START and then thread slave start as you can see below ! but this command were on my MASTER ! 031013 22:33:15 InnoDB: Started MySql: ready for connections. Version: '4.0.13-max-nt-log' socket: '' port: 3306 031014 11:17:32 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'pissarro-bin.352' at position 4 031014 11:17:45 Slave I/O thread exiting, read up to log 'pissarro-bin.352', position 98405708 031014 11:17:45 Slave SQL thread exiting, replication stopped in log 'pissarro-bin.352' at position 3 Immediately I see the error and execute a slave stop But it seem is possible to start a slave command on a master to update itself ! There is way to avoid this error ? tks in advance - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LOG ON SLAVE WITH 4.0.15 (windows platform)
In my network there are one master 4.0.13 and 3 slaves with 4.0.15. STarting the slaves's update to 4.0.15 from 4.0.13 during the night when on the master there are not update I read on slaves's logs as follow: 30918 3:41:06 Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 030918 3:41:06 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'pissarro-bin.330' position 34265744 030918 4:41:07 Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 030918 4:42:07 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'pissarro-bin.330' position 34265744 Every hour the slaves writel about a problem to remain connect with the master. This situation are only from 4.0.15 . There is a way to avoid similar trace in the logs ? tks - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LOG ON SLAVE WITH 4.0.15 (windows platform)
In my network there are one master 4.0.13 and 3 slaves with 4.0.15. STarting the slaves's update to 4.0.15 from 4.0.13 during the night when on the master there are not update I read on slaves's logs as follow: 30918 3:41:06 Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 030918 3:41:06 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'pissarro-bin.330' position 34265744 030918 4:41:07 Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 030918 4:42:07 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'pissarro-bin.330' position 34265744 Every hour the slaves writel about a problem to remain connect with the master. This situation are only from 4.0.15 . There is a way to avoid similar trace in the logs ? tks - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Replication Problem (XP+mysql4.0.14)
nobody have answer ? For me it is very urgent to kwow when the .15 version will be avalaible . Tks - Original Message - From: Massimo Petrini [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: I.P. [EMAIL PROTECTED] Sent: Friday, August 22, 2003 1:16 PM Subject: Re: Replication Problem (XP+mysql4.0.14) I have your same problem in my network where the master i 3.23.52 and then slave are 4.0.14; before, in all 4.0.13, it was ok, without this bug. It will be solved in 4.0.15 ? Best regards Massimo - Original Message - From: I.P. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 22, 2003 11:56 AM Subject: Replication Problem (XP+mysql4.0.14) Hi, it's my story. I have two 4.0.14 mysql server on one machine with win XP Professional polish version. First acts as master: on port 3300 Second acts as slave: on port 3301 below my configuration: ### FOR MASTER # # This will be passed to all mysql clients [client] #password=my_password port=3300 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] basedir = c:/mysql4/ datadir = c:/mysql4/data/ port=3300 language=polish default-character-set=latin2 log-bin server-id=1 log-warnings set-variable = key_buffer=16K set-variable = max_allowed_packet=1M set-variable = thread_stack=64K set-variable = table_cache=4 set-variable = sort_buffer=64K set-variable = net_buffer_length=2K query_cache_size = 1024K # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:50M innodb_data_home_dir = d:\\innodb\\mysql4\\master\\ibdata innodb_log_group_home_dir = d:\\innodb\\mysql4\\master\\iblogs innodb_log_arch_dir = d:\\innodb\\mysql4\\master\\iblogs set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M [myisamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M [mysqlhotcopy] interactive-timeout ### ###FOR SLAVE # # This will be passed to all mysql clients [client] #password=my_password port=3301 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] basedir = c:/mysql4_slave/ datadir = c:/mysql4_slave/data/ port=3301 language=polish default-character-set=latin2 server-id=2 # log-bin # log-slave-updates master-host=127.0.0.1 master-user=irek master-password=XX master-port=3300 master-connect-retry=30 # log-update=log_updates.log log-warnings set-variable = key_buffer=16K set-variable = max_allowed_packet=1M set-variable = thread_stack=64K set-variable = table_cache=4 set-variable = sort_buffer=64K set-variable = net_buffer_length=2K query_cache_size = 1024K # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:50M innodb_data_home_dir = d:\\innodb\\mysql4\\slave\\ibdata innodb_log_group_home_dir = d:\\innodb\\mysql4\\slave\\iblogs innodb_log_arch_dir = d:\\innodb\\mysql4\\slave\\iblogs set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M [myisamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M ## END configuration So i have noticed this things. I start replication with master and slave: 1) Master is running ... --- Slave is running ... and at console can i see: 030804 22:55:36 InnoDB: Started 030804 22:55:36 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3300', r eplication started in log 'FIRST' at position 4 030804 22:55:36 Slave SQL thread initialized, starting replication in log 'FIRS T' at position 0, relay log '.\hq-relay-bin.001' position: 4 mysqld-max-nt
REPLICATION PROBLEM ON 4.0.14 (see prevoius e-mail)
When the 4.0.15 version will be avalaible ? The problem fo replication make impossible to install the .14 version and I came back to .13 release. Best regards Massimo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication Problem (XP+mysql4.0.14)
I have your same problem in my network where the master i 3.23.52 and then slave are 4.0.14; before, in all 4.0.13, it was ok, without this bug. It will be solved in 4.0.15 ? Best regards Massimo - Original Message - From: I.P. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 22, 2003 11:56 AM Subject: Replication Problem (XP+mysql4.0.14) Hi, it's my story. I have two 4.0.14 mysql server on one machine with win XP Professional polish version. First acts as master: on port 3300 Second acts as slave: on port 3301 below my configuration: ### FOR MASTER # # This will be passed to all mysql clients [client] #password=my_password port=3300 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] basedir = c:/mysql4/ datadir = c:/mysql4/data/ port=3300 language=polish default-character-set=latin2 log-bin server-id=1 log-warnings set-variable = key_buffer=16K set-variable = max_allowed_packet=1M set-variable = thread_stack=64K set-variable = table_cache=4 set-variable = sort_buffer=64K set-variable = net_buffer_length=2K query_cache_size = 1024K # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:50M innodb_data_home_dir = d:\\innodb\\mysql4\\master\\ibdata innodb_log_group_home_dir = d:\\innodb\\mysql4\\master\\iblogs innodb_log_arch_dir = d:\\innodb\\mysql4\\master\\iblogs set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M [myisamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M [mysqlhotcopy] interactive-timeout ### ###FOR SLAVE # # This will be passed to all mysql clients [client] #password=my_password port=3301 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] basedir = c:/mysql4_slave/ datadir = c:/mysql4_slave/data/ port=3301 language=polish default-character-set=latin2 server-id=2 # log-bin # log-slave-updates master-host=127.0.0.1 master-user=irek master-password=XX master-port=3300 master-connect-retry=30 # log-update=log_updates.log log-warnings set-variable = key_buffer=16K set-variable = max_allowed_packet=1M set-variable = thread_stack=64K set-variable = table_cache=4 set-variable = sort_buffer=64K set-variable = net_buffer_length=2K query_cache_size = 1024K # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:50M innodb_data_home_dir = d:\\innodb\\mysql4\\slave\\ibdata innodb_log_group_home_dir = d:\\innodb\\mysql4\\slave\\iblogs innodb_log_arch_dir = d:\\innodb\\mysql4\\slave\\iblogs set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M [myisamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M ## END configuration So i have noticed this things. I start replication with master and slave: 1) Master is running ... --- Slave is running ... and at console can i see: 030804 22:55:36 InnoDB: Started 030804 22:55:36 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3300', r eplication started in log 'FIRST' at position 4 030804 22:55:36 Slave SQL thread initialized, starting replication in log 'FIRS T' at position 0, relay log '.\hq-relay-bin.001' position: 4 mysqld-max-nt: ready for connections. Version: '4.0.14-max-nt' socket: '' port: 3301 --- That is ok. 3) checked master data dir: hq-bin.001 hq-bin.index 4) checked slave data dir: hq-relay-bin.001 hq-relay-bin.index master.info relay-log.info 5) I stopped slave - shutdown nicely. 6) I stopped and started master 3 times. 7) I checked master data dir and i can see: hq-bin.001 hq-bin.002 hq-bin.003 hq-bin.004
problem to run setup under windows xp sp1
I need to upgrade my current mysql installation . But now there is a problem to run the setup.exe of installshield 5.x under windows xp sp1 or sp2. The program hung after few seconds. In the memory remain active woexec, ntvdm and setup, but the process is freezed. It is possibile to convert the current setup mode of mysql4.014 in other install system, as for in mysqlcc092 ? Otherwise is no possible to install MYSQL under the current version of windows xp. Tks in advance. - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PROBLEM ON SHUTDOWN
I'm using under WINDOWS NT4 sp6 the 4.0.13 version as a slave from a 3.52 master. During the night to I use a bacth file (starting on 22.30 )to stop the mysql and copy all then file of mysql. But till the 3.52 version (on my slave) using the same scripts no problem. Now when the computer execute the command net stop mysql give me a error message with dr watson. In the error log file I only note this: 030627 8:21:16 InnoDB: Started MySql: ready for connections. Version: '4.0.13-max-nt' socket: '' port: 3306 030627 8:21:16 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'pissarro-bin.256' at position 71226483 030627 22:29:11 Slave: received 0 length packet from server, apparent master shutdown: 030627 22:29:11 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'pissarro-bin.256' position 182119370 030627 22:29:13 Slave I/O thread: error reconnecting to master '[EMAIL PROTECTED]:3306': Error: 'Can't connect to MySQL server on 'pissarro' (10061)' errno: 2003 retry-time: 60 retries: 86400 030627 22:30:02 MySql: Normal shutdown 030627 22:30:13 Slave I/O thread exiting, read up to log 'pissarro-bin.256', position 182119370 030627 22:31:12 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 5 2125693138 InnoDB: Doing recovery: scanned up to log sequence number 5 2125693138 InnoDB: In a MySQL replication slave the last master binlog file InnoDB: position 0 182119394, file name pissarro-bin.256 030627 22:31:13 InnoDB: Flushing modified pages from the buffer pool... 030627 22:31:13 InnoDB: Started MySql: ready for connections. Version: '4.0.13-max-nt' socket: '' port: 3306 030627 22:31:13 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'pissarro-bin.256' at position 182119370 Have you some ideas about it ? Tks in advance - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqldump
It is possibile to make an export dump, excluding some tables ? In other word to make a little dump, but with the features of mysqldump (my db has around 100 table and I want to export only around 96) Tks in advance - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql.err file
In the 4.0.10 version I found a new computername.err file instead the old lod named mysql.err . This feature is a new standard or there is a way to continue to named it to mysql.err ? Regards - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LOG ERROR in windows with 4.0.10 version
The assertion in the manual referred to windows I think is not correct. In my XP version I found the log file as in Unix ie \mysql\data\hostname.err instead \mysql\data\mysql.err as in previous version. Note in my.ini file there is nothing about log-error option . Which is the correct interpretation ? Beginning with MySQL 4.0.10 you can specify where mysqld stores the error log file with the option --log-error[=filename]. If no file name is given mysqld will use mysql-data-dir/'hostname'.err on Unix and `\mysql\data\mysql.err' on windows - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
CLUSTER MYSQL
It is possibile to install MYSQL on a microsoft cluster ? I read for a special version of microsoft SQL version; anybody have installed MYSQL in this environment ? TKS - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem to stop mysql under windows xp
Since 4.03 version under windows XP with SP1 (today I am using 4.0.7 max-nt) , on a slave host, when I stopped the service Mysql, via MYSQLADMIN the semaphore became yellow instead red. The only solution is shutdown the pc. Also when I run the command slave stop the process hang and not became in stop (you cannot have the prompt command). Do you know this problem ? Tks in advance - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PURGE MASTER LOGS
In my network there are 1 master and 3 slaves all with 3.52 on WIN NT. All slaves are linked correctly to the same bin-log file PISSARRO-BIN.047. With the command SHOW MASTER LOGS I see 3 files PISSARRO-BIN.045 PISSARRO-BIN.046 PISSARRO-BIN.047 If I use the command purge logs file to pissarro-bin.046 appear the error A purgeable log is in use, will not purge. But I am sure there is no slave connected to this file. Which is my error ? - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] sql,query - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PURGE MASTER LOGS
I found the problem ! The command is case sensitive also on WINDOWS . I wrote the command as upcase and all is ok. - Original Message - From: Massimo Petrini [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 29, 2002 12:33 PM Subject: PURGE MASTER LOGS In my network there are 1 master and 3 slaves all with 3.52 on WIN NT. All slaves are linked correctly to the same bin-log file PISSARRO-BIN.047. With the command SHOW MASTER LOGS I see 3 files PISSARRO-BIN.045 PISSARRO-BIN.046 PISSARRO-BIN.047 If I use the command purge logs file to pissarro-bin.046 appear the error A purgeable log is in use, will not purge. But I am sure there is no slave connected to this file. Which is my error ? - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] sql,query - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL REPLICA ERROR
Good morning to all My problem is about the replica. I have 4 servers all running on NT4 sp6a; 1 master and 3 slave. From yesterday in the MASTER server I see a system user where the state is WAITING TO RECONNECT AFTER A FAILED READ and in the mysql.err file I see: MySql: ready for connections 021128 7:53:38 InnoDB: Started 021128 7:53:38 Slave: connected to master 'test@PISSARRO:3306', replication started in log 'FIRST' at position 4 021128 7:53:38 Error reading packet from server: Access denied for user: '@PISSARRO' (Using password: NO) (server_errno=1045) 021128 7:53:38 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 But in the master there is also a slave process ? I add the test user with all privilege on my db and appear : 021128 8:13:39 Slave: reconnected to master 'test@PISSARRO:3306',replication resumed in log 'FIRST' at position 33 021128 8:13:39 Slave: received 0 length packet from server, apparent master shutdown: but the master is on and the SHOW MASTER INFO give me the correct information Somebody can help me ? - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replica of temporary table
Which is the correct way to exclude from master replica all the temporary tables present in Mysql's DB ? Otherwise It is possible to use the command replicate-ignore-table =wrk*to exclude all the table whre the name starting with wrk name ? Tks - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SLAVE STOP
In the 4.0.5 version the problem is still alive. Have some notice about this problem will be solved ? Tks in advance. Massimo - Original Message - From: miguel solórzano [EMAIL PROTECTED] To: Massimo Petrini [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: Heikki Tuuri [EMAIL PROTECTED] Sent: Tuesday, November 12, 2002 4:59 AM Subject: Re: SLAVE STOP At 08:02 11/11/2002 +0100, Massimo Petrini wrote: Hi, Thanks for your bug the report. I was be able to repeat the same behavior running two services on the same Win2k machine. However testing I found that using the port=3307 for the master: mysql show variables like p%; +--+-+ | Variable_name| Value | +--+-+ | pid_file | c:\mysql\data\light.pid | | port | 3307| | protocol_version | 10 | +--+-+ 3 rows in set (0.00 sec) and the default port=3306 on the slave side mysql show variables like p%; +--+---+ | Variable_name| Value | +--+---+ | pid_file | c:\mysqlopt\light.pid | | port | 3306 | | protocol_version | 10| +--+---+ 3 rows in set (0.00 sec) I was be able to perform the command: mysql slave stop; Query OK, 0 rows affected (0.00 sec) Of course, that the reason why will be analyzed and fixed. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SLAVE STOP
Good morning to all On mysql 4,0,4 running under W2K SP3, when I run the command SLAVE STOP; the command it is not execute and it remain pending (the prompt of mysql doesn't return); instead all is normal under 3.53. Which is the problem ? tks regards - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SLAVE STOP
On mysql 4,0,4 running under W2K SP3, when I run the command SLAVE STOP; the command it is not execute and it remain pending (the prompt of mysql doesn't return); instead all is normal under 3.53. Which is the problem ? tks regards - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
remote administration - replication questions
Sorry for the below questions: perhaps are obviously ! 1) Which is the correct tool to administrate a remote mysql db in my network ? 2) In my network I have: server A = MASTER server B,C as slaves running always server D running sometimes used to develop. Every night server A stop service, make a local copy of DATADIR in other place, restart and make a mysqldump opt; which is the method to verify is all slaves had updated own db, from remote in order to delete the obsolete log-file on master ? Because every day I produce arount 200 Mb of log files. - But if I cancel some log-file, when I restart the server D ? It is possibile to move log-file to use after for server-D using then CHANGE MASTER TO MASTER_HOST Other Question: - WINMYSQLADMIN a) there is a way to change the path for this program to read the mysql.err in the correct way ? Because today I have mysql.err in the datadir position wich isi different from the original ? b) it is possible to use WINMYSQLADMIN to connect a remote MYSQL ? - 3.23.53 It is confirmed the 17/10/2002 as the release date ? - LOAD DATA FROM MASTER: in which future version it will be implemented for INNODB ? Tks in advance Massimo - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
4.04 VERSION on windows98
This version is avalaible also for WINDOWS 98 ? Because from 3.23.52 (and 4.03) the version are wrong for W98. The program MYSQLQ.exe hang without error message. Tks - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODBC SERVER
There is a way to install the ODBC driver as a service in a NT environment ? In this way if I change the mysql server there is only a place to change the parameter ! Otherwise if you need to change the mysql server you need to go on each pc in the network to change the odbc parameter, like database or IP address Tks - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error on self join
I need to run the following query: SELECT WRK_ImplDisp_1.Livello, WRK_ImplDisp_1.Origine, WRK_ImplDisp.Padre, WRK_ImplDisp_1.Figlio, WRK_ImplDisp.QUnit*WRK_ImplDisp_1.QUnit AS Espr1, WRK_ImplDisp_1.DaAggregare, -1 AS Espr2 FROM WRK_ImplDisp INNER JOIN WRK_ImplDisp AS WRK_ImplDisp_1 ON WRK_ImplDisp.Figlio = WRK_ImplDisp_1.Padre WHERE (((WRK_ImplDisp_1.Origine)='SA1539T' And ((WRK_ImplDisp_1.Origine)=[WRK_ImplDisp].[Origine] Or (WRK_ImplDisp_1.Origine) Is Null)) AND ((WRK_ImplDisp.DaAggregare)=True) AND ((WRK_ImplDisp.Livello)=2)); but I receive an ODBC error : can't reopen table : wrk_ImplDisp1 error #1137 The table is temporary; the table is created with : CREATE TEMPORARY TABLE WRK_ImplDisp(IDIMPL INT(11) NOT NULL auto_increment,Origine CHAR(19) NOT NULL,Livello smallint NOT NULL, Padre char(19) NOT NULL,Figlio char(19) NOT NULL,QUnit REAL NOT NULL,DaAggregare tinyint NULL,FlagCompat smallint NULL,Nord int NULL, PRIMARY KEY (IDIMPL), KEY Origine (Origine), KEY Padre (Padre), KEY Figlio (Figlio), KEY OrigineLivello (Origine,Livello), KEY DaAggregare (DaAggregare),KEY FlagCompact (FlagCompat)); MySQL 3,23,52 -max ODBC 3.51 How I can solve this problem ? Today a query like this is running under MSAccess97 ; the only difference is about the temporary, which is impossible on MSAccess. Tks in advance Massimo Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error on self join
I need to run the following query: SELECT WRK_ImplDisp_1.Livello, WRK_ImplDisp_1.Origine, WRK_ImplDisp.Padre, WRK_ImplDisp_1.Figlio, WRK_ImplDisp.QUnit*WRK_ImplDisp_1.QUnit AS Espr1, WRK_ImplDisp_1.DaAggregare, -1 AS Espr2 FROM WRK_ImplDisp INNER JOIN WRK_ImplDisp AS WRK_ImplDisp_1 ON WRK_ImplDisp.Figlio = WRK_ImplDisp_1.Padre WHERE (((WRK_ImplDisp_1.Origine)='SA1539T' And ((WRK_ImplDisp_1.Origine)=[WRK_ImplDisp].[Origine] Or (WRK_ImplDisp_1.Origine) Is Null)) AND ((WRK_ImplDisp.DaAggregare)=True) AND ((WRK_ImplDisp.Livello)=2)); but I receive an ODBC error : can't reopen table : wrk_ImplDisp1 error #1137 The table is temporary; the table is created with : CREATE TEMPORARY TABLE WRK_ImplDisp(IDIMPL INT(11) NOT NULL auto_increment,Origine CHAR(19) NOT NULL,Livello smallint NOT NULL, Padre char(19) NOT NULL,Figlio char(19) NOT NULL,QUnit REAL NOT NULL,DaAggregare tinyint NULL,FlagCompat smallint NULL,Nord int NULL, PRIMARY KEY (IDIMPL), KEY Origine (Origine), KEY Padre (Padre), KEY Figlio (Figlio), KEY OrigineLivello (Origine,Livello), KEY DaAggregare (DaAggregare),KEY FlagCompact (FlagCompat)); MySQL 3,23,52 -max ODBC 3.51 How I can solve this problem ? Today a query like this is running under MSAccess97 ; the only difference is about the temporary, which is impossible on MSAccess. Tks in advance Massimo Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
new command in 3.23.52 - innodb database schema dump
As in your instruction on 4 jul 2002 23:51:13 I added the SET NO_FOREIGN_KEY_CHECKS=1; after having installed 3.23.52 for WIN on my win2k system in the first line of my shema dump (obtained with MYSQLDUMP -opt); But wheh I lanch the command mysql database file.dump I received the following error: ERROR 1064 at line 1: You have an error in your SQL syntax near 'NO_FOREIGN_KEY_CHECKS=1' at line 1line 1 Which is my error ? Regards Massimo Petrini - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
new command in 3.23.52 - innodb database schema dump
As in your instruction on 4 jul 2002 23:51:13 I added the SET NO_FOREIGN_KEY_CHECKS=1; after having installed 3.23.52 for WIN on my win2k system in the first line of my shema dump (obtained with MYSQLDUMP -opt); But wheh I lanch the command mysql database file.dump I received the following error: ERROR 1064 at line 1: You have an error in your SQL syntax near 'NO_FOREIGN_KEY_CHECKS=1' at line 1line 1 Which is my error ? Regards Massimo Petrini - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backup
Also in may NT machine appear the same error. Which is the problem ? - Original Message - From: Ilyas Keser [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 1:58 PM Subject: backup Hi list... What is the best way to backup a Mysql database? I read in the documentation that mysqlhotcopy is the best and quickest way to do this. But I can not start mysqlhotcopy... Error Message is: Can't locate DBI.pm in @INC (@INC contains: /System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin /Library/Perl /Library/Perl /Network/Library/Perl/darwin /Network/Library/Perl /Network/Library/Perl .) at ./mysqlhotcopy line 8. BEGIN failed--compilation aborted at ./mysqlhotcopy line 8. What is DBI.pm? Thanks - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Innodb tables
I am not able to run the Mysql server on a NT server and the data in another NT server on the network. See my my.in innodb_data_file_path=\InnoData\HymnOMT:10M:autoextend innodb_data_home_dir=d:\applicaz\mysql\InnoDB innodb_log_group_home_dir=d:\applicaz\mysql\InnoDB\InnoLog innodb_log_arch_dir=d:\applicaz\mysql\InnoDB\InnoLog If I change the disk d: with a network drive the Mysql server doesn't start. Of corse the NT server see the other network disk where I need to put the data. Is it a limit of Mysql to reside data and server in the same machine ? regards - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
innodb problem
I am a new user of mysql I installed 3.23.51 on my nt this is my my.ini files. [mysqld] innodb_data_home_dir = innodb_data_file_path = ibdata1:30M:autoextend default-table-type=innodb [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-max-nt.exe When I use the winmysqladmin it report in HAVE_INNODB disables; When I create a table mysql create if always with myisam format. Which is my error ? Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php