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: D
lways
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]
_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)
T
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
ication
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
29242301
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
imo
-----
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/[EM
oro) 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
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" <[EMA
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 Windo
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
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
-----
Massim
31014 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
--
s 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
imilar 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 unsubscr
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:
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
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,
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
DB: 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
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
x27; 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/ma
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
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
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
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 MASTE
f 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 ?
> -------------
&
;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 ?
-
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/manua
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 PRO
>
> 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]
>
>
> -
; 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
ODB ?
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]
--
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
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
t;
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
? 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
database
> 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
>
-
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 http://www.mysql.com/manual.php (th
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
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=
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
42 matches
Mail list logo