HeidiSQL crashes MySQL-Service?

Hello,

please excuse my bad english.

Since 1-3 days, (before update to 5.0beta3042, too): When I start HeidiSQL with connection to one of our four MySQL-Servers the loading fails with this log:


###################################################
SHOW TABLE STATUS FROM `pze`|
/* SQL Error (2013): Lost connection to MySQL server during query */
/* Connection to 192.168.115.2 closed at 2010-02-03 18:13:25 */
/* Connecting to 192.168.115.2 via TCP/IP, username root, using password: Yes ... */
/* SQL Error (2003): Can't connect to MySQL server on '192.168.115.2' (10061) */
/* Connecting to 192.168.115.2 via TCP/IP, username root, using password: Yes ... */
...
###################################################

and the MySQL-Service at the server stops!
When I restarted the Service I can work on with HeidiSQL, but not on db 'pze'.

When I am using MySQLFront 3.2 there is no such behavior.

Here is the structure of db 'pze' (built with export of MySQLFront) (there is no trigger in 'pze', but views).

May you fix it ? Or may help me?

Thank you very much!
Felix



# MySQL-Front 3.2 (Build 8.3)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;

/*!40101 SET NAMES latin1 */;
/*!40103 SET TIME_ZONE='SYSTEM' */;

# Host: localhost Database: pze
# ------------------------------------------------------
# Server version 5.0.24-community-nt

#
# Table structure for table tblbr
#

DROP TABLE IF EXISTS `tblbr`;
CREATE TABLE `tblbr` (
`id` int(11) NOT NULL auto_increment,
`Personal_ID` int(11) NOT NULL default '0' COMMENT 'Personalnummer',
`BC` int(3) NOT NULL default '0' COMMENT 'Buchungscode 888=Start 999=Ende',
`Datum` int(11) NOT NULL default '0' COMMENT 'Datum',
`Timestamp` int(11) NOT NULL default '0' COMMENT 'Timestamp (Minuten des Tages)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci COMMENT='Betriebsratstätigkeit';


#
# Table structure for table tblbuchung
#

DROP TABLE IF EXISTS `tblbuchung`;
CREATE TABLE `tblbuchung` (
`ID` int(10) NOT NULL auto_increment COMMENT '1 Schlüssel',
`Personal_ID` int(10) default NULL COMMENT '2 ID aus tblPersonal',
`BC` int(10) default NULL COMMENT '3 Buchungscode: 200 Ko, 201 Ge, 91 RSt, 92 REn, 51 PSt, 52PE',
`datum` int(10) default NULL COMMENT '4Tag, für den die Buchung gilt als Zahl (31.12.1899 = 0, Windows Zeitachse)',
`Timestamp` smallint(5) default NULL COMMENT '5 Zeitstempel, in Minuten',
`Bemerkung` longtext collate latin1_german1_ci,
`Terminal` varchar(50) collate latin1_german1_ci default NULL COMMENT 'UserName (Terminal)',
`timestamp2` timestamp NULL default NULL,
`BDEneuID` int(11) default NULL,
UNIQUE KEY `ID` (`ID`),
UNIQUE KEY `PrimaryKey` (`ID`),
KEY `BC` (`BC`),
KEY `Personal_ID` (`Personal_ID`),
KEY `Timestamp` (`datum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci ROW_FORMAT=DYNAMIC COMMENT='Kommen/GehenBuchung';


#
# Table structure for table tblbuchungdelete
#

DROP TABLE IF EXISTS `tblbuchungdelete`;
CREATE TABLE `tblbuchungdelete` (
`ID` int(10) NOT NULL auto_increment COMMENT '1 Schlüssel',
`Personal_ID` int(10) default NULL COMMENT '2 ID aus tblPersonal',
`BC` int(10) default NULL COMMENT '3 Buchungscode: 200 Ko, 201 Ge, 91 RSt, 92 REn, 51 PSt, 52PE',
`datum` int(10) default NULL COMMENT '4Tag, für den die Buchung gilt als Zahl (31.12.1899 = 0, Windows Zeitachse)',
`Timestamp` smallint(5) default NULL COMMENT '5 Zeitstempel, in Minuten',
`Bemerkung` longtext collate latin1_german1_ci,
`Terminal` varchar(50) collate latin1_german1_ci default NULL COMMENT 'UserName (Terminal)',
`timestamp2` timestamp NULL default NULL,
`Zeitpunkt` timestamp NULL default NULL,
`Nutzer` varchar(50) collate latin1_german1_ci default NULL,
UNIQUE KEY `ID` (`ID`),
UNIQUE KEY `PrimaryKey` (`ID`),
KEY `BC` (`BC`),
KEY `Personal_ID` (`Personal_ID`),
KEY `Timestamp` (`datum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci ROW_FORMAT=COMPACT COMMENT='Kommen/GehenBuchung';


#
# Table structure for table tblmonatssaldo
#

DROP TABLE IF EXISTS `tblmonatssaldo`;
CREATE TABLE `tblmonatssaldo` (
`id` int(11) NOT NULL auto_increment,
`Personal_ID` int(11) NOT NULL default '0' COMMENT 'Personalnummer',
`Monat` date NOT NULL COMMENT 'Erster des jew. Monat',
`Saldo` int(11) default NULL COMMENT 'Monatssaldo in Minuten',
`Urlaub` int(11) default NULL COMMENT 'Urlaubssaldo in TAGEN',
`SaldoChange` int(11) default '0' COMMENT 'Änderung des Saldos in Min',
`UrlaubChange` int(11) default '0' COMMENT 'Änderung des Urlaubs in TAGEN',
`Bemerkung` varchar(300) collate latin1_german1_ci default NULL COMMENT 'Bermerkung',
`User_Created` char(20) collate latin1_german1_ci default NULL,
`Date_Created` timestamp NULL default NULL,
`User_LastModified` char(20) collate latin1_german1_ci default NULL,
`Date_LastModified` timestamp NULL default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci COMMENT='Anfangssalden der Monate';


#
# Table structure for table tblpause
#

DROP TABLE IF EXISTS `tblpause`;
CREATE TABLE `tblpause` (
`id` int(11) NOT NULL auto_increment,
`Personal_ID` int(10) NOT NULL default '0' COMMENT 'Personalnummer',
`Datum` date NOT NULL COMMENT 'Datum',
`Timestamp` int(4) NOT NULL default '0' COMMENT 'Uhrzeit in Minuten des Tages',
`BC` int(2) NOT NULL default '0' COMMENT '1=START; 2=ENDE; 91:RauchStart; 92:Rauchende',
`bemerkung` longtext collate latin1_german1_ci,
`User_Created` varchar(20) collate latin1_german1_ci NOT NULL,
`Date_Created` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci COMMENT='START UND ENDE VON PAUSEN';


#
# Table structure for table tblpze
#

DROP TABLE IF EXISTS `tblpze`;
CREATE TABLE `tblpze` (
`ID` int(10) NOT NULL auto_increment COMMENT '1 Primärschlüssel',
`Personal_ID` int(10) default NULL COMMENT '2 ID aus Personal.mdb:tblpersonal',
`datum` date default NULL COMMENT '3 Tagesdatum',
`schichtplan_ID` int(10) default NULL COMMENT '4 schichtplan, Optional, wenn leer, wird Stammschichtplan verwendet',
`kst` smallint(5) default NULL COMMENT '5 Kostenstelle, Optional, wenn leer, wird Stammkostenstelle verwendet',
`überstunden` tinyint(1) NOT NULL COMMENT '7 Anpassung Geyer, Zeiger, True --> Überstunden berechnen, False --> Überstunden ignorieren',
`closed` tinyint(1) NOT NULL COMMENT '8 Zeiger für abgeschlossene Datensätze (dürfen nicht verändert werden)',
`bemerkung` varchar(50) collate latin1_german1_ci default NULL COMMENT '9',
`datum_long` int(11) default NULL,
`User_Created` varchar(20) collate latin1_german1_ci default NULL COMMENT '10',
`Date_Created` timestamp NULL default NULL COMMENT '11',
`User_LastModified` varchar(20) collate latin1_german1_ci default NULL COMMENT '12',
`Date_LastModified` timestamp NULL default NULL COMMENT '13',
`PLUSSexport_am` date default NULL COMMENT 'Datum des Plussexports',
PRIMARY KEY (`ID`),
KEY `datum` (`datum`),
KEY `Personal_ID` (`Personal_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci ROW_FORMAT=DYNAMIC;


#
# Table structure for table tblpzeplanung
#

DROP TABLE IF EXISTS `tblpzeplanung`;
CREATE TABLE `tblpzeplanung` (
`id` int(11) NOT NULL auto_increment,
`Start` date default NULL,
`Ende` date default NULL,
`Personal_ID` int(11) default NULL,
`Schichtplan_ID` int(11) default NULL,
`OriginalStart` date default NULL,
`OriginalEnde` date default NULL,
`date_created` timestamp NULL default NULL,
`user_created` varchar(40) character set latin1 collate latin1_german1_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='fuer den urlaubsplaner';


#
# Table structure for table tblschichtplan
#

DROP TABLE IF EXISTS `tblschichtplan`;
CREATE TABLE `tblschichtplan` (
`ID` int(10) NOT NULL auto_increment COMMENT '0 Primärschlüssel',
`schichtplan` varchar(10) collate latin1_german1_ci default NULL COMMENT '1 Name des Schichtplans, intern, abhängig vom Lohn + Gehaltsystems',
`ktxt` varchar(50) collate latin1_german1_ci default NULL COMMENT '3 Name des Schichtplans extern für Frontend',
`farbe` int(10) default NULL COMMENT '6 Farbe für Ansichten im Frontend',
`start_1` int(10) default NULL COMMENT '7 Startzeitpunkt der Arbeitszeit (in Minuten ab 0:00)',
`ende_1` int(10) default NULL COMMENT '8 Endzeitpunkt der Arbeitszeit (in Minuten ab 0:00)',
`start_2` int(10) default NULL COMMENT '9 Startzeitpunkt der Arbeitszeit (in Minuten ab 0:00)',
`ende_2` int(10) default NULL COMMENT '10 Endzeitpunkt der Arbeitszeit (in Minuten ab 0:00)',
`start_3` int(10) default NULL COMMENT '11 Startzeitpunkt der Arbeitszeit (in Minuten ab 0:00)',
`ende_3` int(10) default NULL COMMENT '12 Endzeitpunkt der Arbeitszeit (in Minuten ab 0:00)',
`konto` varchar(10) collate latin1_german1_ci default NULL COMMENT '13 Kontobezeichnung, auf das die Zeit gebucht wird',
`zuschlag` smallint(6) default NULL COMMENT '990 ist Spätzuschlag, 991 ist nur nachtschicht, 992 beides',
`Pause_auszahlen` int(1) NOT NULL default '0' COMMENT '0= nein; 1=ja',
`ZeitZuschlag` decimal(5,2) default NULL COMMENT 'Zeitzuschlag prozentual',
`User_Created` varchar(20) collate latin1_german1_ci default NULL COMMENT '18',
`Date_Created` timestamp NULL default NULL COMMENT '19',
`User_LastModified` varchar(20) collate latin1_german1_ci default NULL COMMENT '20',
`Date_LastModified` timestamp NULL default NULL COMMENT '21',
`fruehspaetnacht` int(11) default NULL,
`Aktiv` int(1) default '1' COMMENT '0=nein; 1=ja',
PRIMARY KEY (`ID`),
KEY `schichtplan` (`schichtplan`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci ROW_FORMAT=DYNAMIC;


#
# Table structure for table tblstatistik
#

DROP TABLE IF EXISTS `tblstatistik`;
CREATE TABLE `tblstatistik` (
`id` int(11) NOT NULL auto_increment,
`Personal_ID` int(11) NOT NULL default '0',
`Datum` date NOT NULL,
`Zeitmodell` int(11) default NULL,
`Zeitkonto` varchar(11) collate latin1_german1_ci default NULL,
`Kommen1` int(11) default NULL,
`Kommen2` int(11) default NULL,
`Kommen3` int(11) default NULL,
`Gehen1` int(11) default NULL,
`Gehen2` int(11) default NULL,
`Gehen3` int(11) default NULL,
`Anwesenheitszeit` int(11) default NULL,
`Sollzeit` int(11) default NULL,
`Spaetzeit` int(11) default NULL,
`Nachtzeit1` int(11) default NULL,
`Nachtzeit2` int(11) default NULL,
`Samstagzeit` int(11) default NULL,
`Urlaubszeit` int(11) default NULL,
`Feiertagszeit` int(11) default NULL,
`Gleitzeit` int(11) default NULL,
`KrankMLFZ` int(11) default NULL,
`KrankOLFZ` int(11) default NULL,
`Sonstiges` int(11) default NULL,
`TagesSaldo` int(11) default NULL,
`StammKST` int(11) default NULL,
`EinsatzKST` int(11) default NULL,
`ProdGrad` int(11) default NULL,
`LAN` int(11) default NULL,
`LANFIRMA_ID` int(11) default NULL,
`Stundensatz` decimal(10,2) default NULL,
`User_Created` varchar(50) collate latin1_german1_ci default NULL,
`Date_Created` datetime default NULL,
`Pausenzeit` int(11) default '0',
`PauseAusbezahlt` int(1) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `Personal_ID` (`Personal_ID`,`Datum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;


#
# Table structure for table tblunterweisungsabteilung
#

DROP TABLE IF EXISTS `tblunterweisungsabteilung`;
CREATE TABLE `tblunterweisungsabteilung` (
`Unterweisungs_Id` int(11) NOT NULL default '0' COMMENT 'aus tblunterweisungsstamm',
`Abteilungs_id` int(11) NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci COMMENT='ordnet unterweisungen abteilungen zu';


#
# Table structure for table tblunterweisungsmatrix
#

DROP TABLE IF EXISTS `tblunterweisungsmatrix`;
CREATE TABLE `tblunterweisungsmatrix` (
`Personal_Id` int(11) NOT NULL default '0',
`Unterweisungs_Id` int(11) NOT NULL default '0',
`gueltig_ab` timestamp NOT NULL default '0000-00-00 00:00:00',
`CreatedByPV` int(11) NOT NULL default '0' COMMENT '0 = System',
`Turnus` int(11) default NULL,
`TurnusZE` int(11) default NULL,
`faellig` date default NULL,
`letzteUnterweisung` date default NULL,
`PV` int(11) default NULL,
`vorschlag` date default NULL,
`UserCreated` varchar(300) collate latin1_german1_ci default NULL,
`DateCreated` timestamp NULL default NULL,
`PVNachrichtVorschl` timestamp NULL default NULL,
`PVNachrichtFaellig` timestamp NULL default NULL,
`Art` char(40) collate latin1_german1_ci default NULL,
`Bemerkung` varchar(100) collate latin1_german1_ci default NULL,
`Unterweiser` varchar(100) collate latin1_german1_ci default NULL,
`touched` date default NULL,
PRIMARY KEY (`Personal_Id`,`Unterweisungs_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;


#
# Table structure for table tblunterweisungsprotokoll
#

DROP TABLE IF EXISTS `tblunterweisungsprotokoll`;
CREATE TABLE `tblunterweisungsprotokoll` (
`id` int(11) NOT NULL auto_increment,
`personal_id` int(11) NOT NULL default '0',
`datum` date NOT NULL,
`unterweisungs_id` int(11) NOT NULL default '0',
`unterweiser` varchar(30) collate latin1_german1_ci default NULL,
`UserCreated` varchar(100) collate latin1_german1_ci default NULL,
`PV` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;


#
# Table structure for table tblunterweisungsstamm
#

DROP TABLE IF EXISTS `tblunterweisungsstamm`;
CREATE TABLE `tblunterweisungsstamm` (
`id` int(11) NOT NULL auto_increment,
`Bezeichnung` varchar(100) collate latin1_german1_ci NOT NULL,
`turnus_in_monaten` int(11) default '0' COMMENT '0=einmalig, sonst monatlich',
`datei_betriebsanweisung` varchar(250) collate latin1_german1_ci default NULL,
`datei_unterweisungsnachweis` varchar(250) collate latin1_german1_ci default NULL,
`zwang_fuer_abteilungen` varchar(250) collate latin1_german1_ci default 'abteilungsnummer kommagetrennt',
`PV` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;


#
# Table structure for table tblunterwmhistorie
#

DROP TABLE IF EXISTS `tblunterwmhistorie`;
CREATE TABLE `tblunterwmhistorie` (
`Personal_Id` int(11) NOT NULL default '0',
`Unterweisungs_Id` int(11) NOT NULL default '0',
`gueltig_ab` date NOT NULL default '0000-00-00',
`CreatedByPV` int(11) NOT NULL default '0' COMMENT '0 = System',
`Turnus` int(11) default NULL,
`TurnusZE` int(11) default NULL,
`faellig` date default NULL,
`letzteUnterweisung` date default NULL,
`PV` int(11) default '0',
`vorschlag` date default NULL,
`UserCreated` varchar(300) collate latin1_german1_ci default NULL,
`DateCreated` timestamp NULL default NULL,
`CreatedByUser` varchar(100) collate latin1_german1_ci default NULL,
`art` char(40) collate latin1_german1_ci default NULL,
`Bemerkung` varchar(100) collate latin1_german1_ci default NULL,
`Unterweiser` varchar(100) collate latin1_german1_ci default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;


#
# View structure for view viewt1
#

DROP VIEW IF EXISTS `viewt1`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `viewt1` AS select `m`.`Unterweisungs_Id` AS `UwId`,`u`.`Bezeichnung` AS `Unterweisung`,`m`.`Personal_Id` AS `Pnr`,`p`.`Nachname` AS `Nachname`,`p`.`Vorname` AS `Vorname`,`m`.`gueltig_ab` AS `Datum`,`m`.`PV` AS `PV`,`m`.`faellig` AS `faellig`,`m`.`letzteUnterweisung` AS `letzte Unterweisung`,`m`.`Unterweiser` AS `letzter Unterweiser`,`m`.`Turnus` AS `Turnus`,`m`.`DateCreated` AS `geändert am`,`m`.`CreatedByPV` AS `CreatedByPV`,`m`.`Art` AS `Art der Änderung`,`p`.`Abteilungs_ID` AS `Abteilung`,`abt`.`Abteilung` AS `Kostenstelle`,`m`.`UserCreated` AS `geändert durch`,`m`.`Bemerkung` AS `Bemerkung` from (((`tblunterweisungsmatrix` `m` join `personal`.`tblpersonal` `p`) join `tblunterweisungsstamm` `u`) join `personal`.`tblabteilung` `abt`) where ((`p`.`ID` = `m`.`Personal_Id`) and (`u`.`id` = `m`.`Unterweisungs_Id`) and (`abt`.`ID` = `p`.`Abteilungs_ID`));

#
# View structure for view viewunterwmatrix
#

DROP VIEW IF EXISTS `viewunterwmatrix`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `viewunterwmatrix` AS select `t1`.`UwId` AS `UwId`,`t1`.`Unterweisung` AS `Unterweisung`,`t1`.`Pnr` AS `Pnr`,`t1`.`Nachname` AS `Nachname`,`t1`.`Vorname` AS `Vorname`,`t1`.`Datum` AS `Datum`,`t1`.`PV` AS `PV`,`t1`.`faellig` AS `faellig`,concat(`p2`.`Nachname`,_latin1', ',left(`p2`.`Vorname`,1)) AS `Verantwortlicher`,`t1`.`letzte Unterweisung` AS `letzte Unterweisung`,`t1`.`letzter Unterweiser` AS `letzter Unterweiser`,`t1`.`Turnus` AS `Turnus`,`t1`.`geändert am` AS `geändert am`,`t1`.`CreatedByPV` AS `CreatedByPV`,`t1`.`Art der Änderung` AS `Art der Änderung`,`t1`.`Abteilung` AS `Kst-Nr`,`t1`.`Kostenstelle` AS `Kostenstelle`,`t1`.`geändert durch` AS `geändert durch`,`t1`.`Bemerkung` AS `Bemerkung` from (`viewt1` `T1` left join `personal`.`tblpersonal` `p2` on((`p2`.`ID` = `t1`.`PV`))) order by `t1`.`Unterweisung`,`t1`.`Nachname`,`t1`.`Vorname`,`t1`.`geändert durch`;

#
# View structure for view viewunterwmatrixalle
#

DROP VIEW IF EXISTS `viewunterwmatrixalle`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `viewunterwmatrixalle` AS select `u`.`id` AS `UwId`,`u`.`Bezeichnung` AS `Unterweisung`,`p`.`ID` AS `Pnr`,`p`.`Nachname` AS `Nachname`,`p`.`Vorname` AS `Vorname`,NULL AS `Datum`,NULL AS `PV`,NULL AS `fällig`,NULL AS `Verantwortlicher`,NULL AS `letzte Unterweisung`,NULL AS `letzter Unterweiser`,NULL AS `Turnus`,NULL AS `geändert am`,NULL AS `CreatedByPV`,NULL AS `Art der Änderung`,`p`.`Abteilungs_ID` AS `Kst-Nr`,`abt`.`Abteilung` AS `Kostenstelle`,NULL AS `geändert durch`,NULL AS `Bemerkung` from ((`personal`.`tblpersonal` `p` join `tblunterweisungsstamm` `u`) join `personal`.`tblabteilung` `abt`) where ((`p`.`PZEStatus` <> 9) and ((`p`.`Austrittsdatum` >= now()) or isnull(`p`.`Austrittsdatum`)) and (`p`.`Eintrittsdatum` < now()) and (`abt`.`ID` = `p`.`Abteilungs_ID`) and not((`u`.`id`,`p`.`ID`) in (select `viewunterwmatrix`.`UwId` AS `uwid`,`viewunterwmatrix`.`Pnr` AS `pnr` from `viewunterwmatrix`))) union select `viewunterwmatrix`.`UwId` AS `UwId`,`viewunterwmatrix`.`Unterweisung` AS `Unterweisung`,`viewunterwmatrix`.`Pnr` AS `Pnr`,`viewunterwmatrix`.`Nachname` AS `Nachname`,`viewunterwmatrix`.`Vorname` AS `Vorname`,`viewunterwmatrix`.`Datum` AS `Datum`,`viewunterwmatrix`.`PV` AS `PV`,`viewunterwmatrix`.`faellig` AS `faellig`,`viewunterwmatrix`.`Verantwortlicher` AS `Verantwortlicher`,`viewunterwmatrix`.`letzte Unterweisung` AS `letzte Unterweisung`,`viewunterwmatrix`.`letzter Unterweiser` AS `letzter Unterweiser`,`viewunterwmatrix`.`Turnus` AS `Turnus`,`viewunterwmatrix`.`geändert am` AS `geändert am`,`viewunterwmatrix`.`CreatedByPV` AS `CreatedByPV`,`viewunterwmatrix`.`Art der Änderung` AS `Art der Änderung`,`viewunterwmatrix`.`Kst-Nr` AS `Kst-Nr`,`viewunterwmatrix`.`Kostenstelle` AS `Kostenstelle`,`viewunterwmatrix`.`geändert durch` AS `geändert durch`,`viewunterwmatrix`.`Bemerkung` AS `Bemerkung` from `viewunterwmatrix`;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

Your dump of "viewt1" seems to refer to a table I don't have: "personal.tblpersonal"

Anyway, could you please post the result of

SHOW TABLE STATUS FROM `pze`

(using MF or mysql command line, if Heidi doesn't work)

Hello,

here's the result:

"Name";"Engine";"Version";"Row_format";"Rows";"Avg_row_length";"Data_length";"Max_data_length";"Index_length";"Data_free";"Auto_increment";"Create_time";"Update_time";"Check_time";"Collation";"Checksum";"Create_options";"Comment"
"tblbr";"InnoDB";10;"Compact";0;0;16384;0;0;0;1;"2008-04-16 16:27:37";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"Betriebsratstätigkeit\; InnoDB free: 9216 kB"
"tblbuchung";"InnoDB";10;"Compact";0;0;16384;0;65536;0;1;"2008-04-16 16:27:38";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"Kommen/GehenBuchung\; InnoDB free: 9216 kB"
"tblbuchungdelete";"InnoDB";10;"Compact";0;0;16384;0;65536;0;1;"2008-04-16 16:27:38";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"Kommen/GehenBuchung\; InnoDB free: 9216 kB"
"tblmonatssaldo";"InnoDB";10;"Compact";424;231;98304;0;0;0;689;"2008-04-16 16:27:38";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"Anfangssalden der Monate\; InnoDB free: 9216 kB"
"tblpause";"InnoDB";10;"Compact";0;0;16384;0;0;0;1;"2008-04-16 16:27:38";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"START UND ENDE VON PAUSEN\; InnoDB free: 9216 kB"
"tblpze";"InnoDB";10;"Compact";12534;125;1572864;0;606208;0;86228;"2008-04-16 16:27:38";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"InnoDB free: 9216 kB"
"tblpzeplanung";"InnoDB";10;"Compact";0;0;16384;0;0;0;1;"2008-04-16 16:27:38";NULL;NULL;"latin1_swedish_ci";NULL;"";"fuer den urlaubsplaner\; InnoDB free: 9216 kB"
"tblschichtplan";"InnoDB";10;"Compact";18;910;16384;0;16384;0;418;"2008-04-16 16:27:38";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"InnoDB free: 9216 kB"
"tblstatistik";"InnoDB";10;"Compact";12828;205;2637824;0;294912;0;17297;"2008-04-16 16:27:38";NULL;NULL;"latin1_german1_ci";NULL;"";"InnoDB free: 9216 kB"
"tblunterweisungsabteilung";"InnoDB";10;"Compact";0;0;16384;0;0;0;NULL;"2008-06-26 13:08:03";NULL;NULL;"latin1_german1_ci";NULL;"";"ordnet unterweisungen abteilungen zu\; InnoDB free: 9216 kB"
"tblunterweisungsmatrix";"InnoDB";10;"Compact";21;780;16384;0;0;0;NULL;"2008-07-18 11:54:10";NULL;NULL;"latin1_german1_ci";NULL;"";"InnoDB free: 9216 kB"
"tblunterweisungsprotokoll";"InnoDB";10;"Compact";146;112;16384;0;0;0;226;"2008-05-23 15:09:23";NULL;NULL;"latin1_german1_ci";NULL;"";"InnoDB free: 9216 kB"
"tblunterweisungsstamm";"InnoDB";10;"Compact";3;5461;16384;0;0;0;29;"2008-05-23 15:09:31";NULL;NULL;"latin1_german1_ci";NULL;"";"InnoDB free: 9216 kB"
"tblunterwmhistorie";"InnoDB";10;"Compact";1330;197;262144;0;0;0;NULL;"2008-07-25 14:11:38";NULL;NULL;"latin1_german1_ci";NULL;"";"InnoDB free: 9216 kB"
"viewt1";NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;"VIEW"
"viewunterwmatrix";NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;"VIEW"
"viewunterwmatrixalle";NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;"VIEW"



And here's the result of SHOW TABLE STATUS FROM personal:

"Name";"Engine";"Version";"Row_format";"Rows";"Avg_row_length";"Data_length";"Max_data_length";"Index_length";"Data_free";"Auto_increment";"Create_time";"Update_time";"Check_time";"Collation";"Checksum";"Create_options";"Comment"
"tblabteilung";"InnoDB";10;"Compact";5;3276;16384;0;16384;0;NULL;"2008-04-16 16:27:37";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"InnoDB free: 9216 kB"
"tblbarcode";"InnoDB";10;"Compact";0;0;16384;0;16384;0;1;"2008-04-16 16:27:37";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"InnoDB free: 9216 kB"
"tblbde";"InnoDB";10;"Compact";0;0;16384;0;16384;0;1;"2008-04-16 16:27:37";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"InnoDB free: 9216 kB"
"tblbderechte";"InnoDB";10;"Compact";23;712;16384;0;16384;0;26;"2008-04-16 16:27:37";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"InnoDB free: 9216 kB"
"tblkennzeichen";"InnoDB";10;"Compact";6;2730;16384;0;0;0;10;"2008-10-23 10:14:25";NULL;NULL;"latin1_german1_ci";NULL;"";"InnoDB free: 9216 kB"
"tblkennzeichenstamm";"InnoDB";10;"Compact";3;5461;16384;0;0;0;6;"2008-10-23 10:10:24";NULL;NULL;"latin1_german1_ci";NULL;"";"InnoDB free: 9216 kB"
"tbllanfirma";"InnoDB";10;"Compact";0;0;16384;0;0;0;1;"2008-04-16 16:27:37";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"Liste der Leiharbeitsfirmen\; InnoDB free: 9216 kB"
"tbllanfirma_bak";"InnoDB";10;"Compact";0;0;16384;0;0;0;1;"2008-06-09 08:52:00";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"Liste der Leiharbeitsfirmen\; InnoDB free: 9216 kB"
"tblpaenderung";"InnoDB";10;"Compact";14;1170;16384;0;0;0;57;"2008-09-15 12:25:17";NULL;NULL;"latin1_german1_ci";NULL;"";"protokolliert Änderungen am Personalstamm\; InnoDB free: 9216 kB"
"tblpersonal";"InnoDB";10;"Compact";37;442;16384;0;16384;0;100000;"2008-04-16 16:27:37";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"InnoDB free: 9216 kB"
"tblpersonal_bak";"InnoDB";10;"Compact";18;910;16384;0;32768;0;10302;"2008-06-03 15:58:56";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"InnoDB free: 9216 kB"
"tblpersonalaenderung";"InnoDB";10;"Compact";0;0;16384;0;0;0;NULL;"2008-09-12 12:44:18";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"InnoDB free: 9216 kB"
"tblperszuschlaege";"InnoDB";10;"Compact";0;0;16384;0;16384;0;1;"2008-04-16 16:27:37";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"Personal-Zuschlag-Kombination\; InnoDB free: 9216 kB"
"tblprogramme";"InnoDB";10;"Compact";141;116;16384;0;0;0;173;"2008-04-16 16:27:37";NULL;NULL;"latin1_german1_ci";NULL;"";"InnoDB free: 9216 kB"
"tbluserabteilung";"InnoDB";10;"Compact";13;1260;16384;0;0;0;34;"2008-04-18 07:50:03";NULL;NULL;"latin1_german1_ci";NULL;"";"InnoDB free: 9216 kB"
"tbluserrechte";"InnoDB";10;"Compact";7;2340;16384;0;16384;0;9;"2008-04-16 16:27:37";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"InnoDB free: 9216 kB"
"tblzugriffe";"InnoDB";10;"Compact";8563;185;1589248;0;0;0;8877;"2008-09-04 12:33:12";NULL;NULL;"latin1_swedish_ci";NULL;"";"InnoDB free: 9216 kB"
"tblzuschlaege";"InnoDB";10;"Compact";0;0;16384;0;16384;0;1;"2008-04-16 16:27:37";NULL;NULL;"latin1_german1_ci";NULL;"row_format=COMPACT";"Liste der Zuschläge (Stamm)\; InnoDB free: 9216 kB"
"viewaktupstamm";NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;"VIEW"


Thank you

Hm, looks very normal. I thought there may be some crashed table or invalid VIEW definition or something like that, but everything looks fine. Only the server connection crashes when doing SHOW TABLE STATUS FROM `pze` - weird.