phpBB.de

phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/

MySQL-Datenbanken löschen?

https://www.phpbb.de/community/viewtopic.php?t=217608

Seite 1 von 1

MySQL-Datenbanken löschen?

Verfasst: 22.08.2011 12:28
von ProF80
Hi!
Ich wollte eine Datenbank löschen (wird nicht mehr benötigt)
Es war eine alte Onlineshop Datenbank. Nun konnte nicht alles löschen ? Ich bekomme immer diese Meldung:

Code: Alles auswählen

#1217 - Cannot delete or update a parent row: a foreign key constraint fails
Hab dann auch schon im Netz einige Möglichkeiten gesucht und ausprobiert. Komme dann immer nur auf neue Fehlermeldungen.
1. Möglichkeit sollte sein: Die datein zu exportieren und dabei

Code: Alles auswählen

ET FOREIGN_KEY_CHECKS=0;
SET FOREIGN_KEY_CHECKS=1;
einfügen zu lassen :

Code: Alles auswählen

-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: xxxxxxxx
-- Erstellungszeit: 22. August 2011 um 11:32
-- Server Version: 5.1.56
-- PHP-Version: 5.3.6

SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `xxxxxx`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `iContactId` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `iUserId` mediumint(9) unsigned DEFAULT NULL,
  `iAddressId` mediumint(9) unsigned DEFAULT NULL,
  `iBranchId` smallint(5) unsigned DEFAULT NULL,
  `sDate` varchar(15) NOT NULL DEFAULT '',
  `iPersonId` mediumint(9) unsigned DEFAULT NULL,
  `iShopId` smallint(5) unsigned NOT NULL DEFAULT '0',
  `iCreditAssessment` tinyint(2) NOT NULL,
  `sExternalId` varchar(20) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`iContactId`),
  KEY `iShopId` (`iShopId`),
  KEY `sExternalId` (`sExternalId`),
  KEY `iUserId` (`iUserId`),
  KEY `iBranchId` (`iBranchId`),
  KEY `iAddressId` (`iAddressId`),
  KEY `iPersonId` (`iPersonId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `contact`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `contact_address`
--

CREATE TABLE IF NOT EXISTS `contact_address` (
  `iAddressId` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `sSalutation` tinyint(2) NOT NULL DEFAULT '0',
  `sCompany` varchar(150) NOT NULL DEFAULT '',
  `sFirstname` varchar(60) NOT NULL DEFAULT '',
  `sName` varchar(60) NOT NULL DEFAULT '',
  `sStreet` varchar(200) NOT NULL DEFAULT '',
  `sStreet2` varchar(200) NOT NULL DEFAULT '',
  `sPostalCode` varchar(8) NOT NULL DEFAULT '',
  `sLocation` varchar(60) NOT NULL DEFAULT '',
  `iCountryId` smallint(3) unsigned NOT NULL,
  `iContactId` mediumint(9) unsigned DEFAULT NULL,
  `iAddressChecked` tinyint(1) NOT NULL DEFAULT '0',
  `sExternalId` varchar(20) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`iAddressId`),
  KEY `sExternalId` (`sExternalId`),
  KEY `iCountryId` (`iCountryId`),
  KEY `iContactId` (`iContactId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `contact_address`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `data_country`
--

CREATE TABLE IF NOT EXISTS `data_country` (
  `iCountryId` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `sCountryId` varchar(5) NOT NULL DEFAULT '',
  `bEuropeanUnion` smallint(1) NOT NULL DEFAULT '0',
  `iMandatorId` smallint(5) unsigned NOT NULL DEFAULT '0',
  `iSequence` smallint(6) unsigned NOT NULL,
  PRIMARY KEY (`iCountryId`),
  KEY `iMandatorId` (`iMandatorId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `data_country`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `data_currency`
--

CREATE TABLE IF NOT EXISTS `data_currency` (
  `iCurrencyId` smallint(3) unsigned NOT NULL AUTO_INCREMENT,
  `sFigure` varchar(200) NOT NULL DEFAULT '',
  `dExchangeRate` double(4,2) NOT NULL DEFAULT '0.00',
  `bActive` binary(1) NOT NULL DEFAULT '\0',
  `sPaypalFigure` varchar(4) NOT NULL,
  `iMandatorId` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`iCurrencyId`),
  KEY `iMandatorId` (`iMandatorId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `data_currency`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `data_mail_pattern`
--

CREATE TABLE IF NOT EXISTS `data_mail_pattern` (
  `iMailPatternId` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `iShopId` smallint(5) unsigned DEFAULT '0',
  PRIMARY KEY (`iMailPatternId`),
  KEY `iShopId` (`iShopId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

--
-- Daten für Tabelle `data_mail_pattern`
--

INSERT INTO `data_mail_pattern` (`iMailPatternId`, `iShopId`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `data_purchase_tax`
--

CREATE TABLE IF NOT EXISTS `data_purchase_tax` (
  `iPurchaseTaxId` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `dPurchaseTax` double(5,2) NOT NULL DEFAULT '0.00',
  `iMandatorId` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`iPurchaseTaxId`),
  KEY `iMandatorId` (`iMandatorId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Daten für Tabelle `data_purchase_tax`
--

INSERT INTO `data_purchase_tax` (`iPurchaseTaxId`, `dPurchaseTax`, `iMandatorId`) VALUES
(1, 19.00, 1),
(2, 7.00, 1);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `user_mandator`
--

CREATE TABLE IF NOT EXISTS `user_mandator` (
  `iId` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `sName` varchar(255) NOT NULL,
  `iParent` int(11) DEFAULT '0',
  `iAdmin` int(11) NOT NULL,
  `bActive` tinyint(1) NOT NULL,
  `bCascade` tinyint(1) NOT NULL,
  `iMaxShop` int(11) NOT NULL,
  `iDefaultShop` smallint(5) unsigned NOT NULL DEFAULT '0',
  `sMandatorDirectory` varchar(16) NOT NULL,
  `bSaveRecommendation` varbinary(1) NOT NULL DEFAULT '0',
  `iTypeComment` tinyint(4) NOT NULL,
  `bUniqueProductNumber` tinyint(1) NOT NULL,
  `iMaxArticle` int(11) NOT NULL,
  `iActivateStart` int(12) NOT NULL,
  `iActivateStop` int(12) NOT NULL,
  `iCreatorId` varchar(100) NOT NULL,
  `iOrderTypePaid` smallint(5) unsigned NOT NULL,
  PRIMARY KEY (`iId`),
  KEY `iParent` (`iParent`),
  KEY `iAdmin` (`iAdmin`),
  KEY `iDefaultShop` (`iDefaultShop`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Daten für Tabelle `user_mandator`
--

INSERT INTO `user_mandator` (`iId`, `sName`, `iParent`, `iAdmin`, `bActive`, `bCascade`, `iMaxShop`, `iDefaultShop`, `sMandatorDirectory`, `bSaveRecommendation`, `iTypeComment`, `bUniqueProductNumber`, `iMaxArticle`, `iActivateStart`, `iActivateStop`, `iCreatorId`, `iOrderTypePaid`) VALUES
(1, 'Basismandant', 0, 0, 1, 0, 12, 0, 'm4qsh7', '0', 1, 1, 1000, 0, 0, '', 0);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `user_shop`
--

CREATE TABLE IF NOT EXISTS `user_shop` (
  `iId` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `sName` varchar(255) NOT NULL,
  `sCompany` varchar(128) NOT NULL,
  `iParent` int(11) DEFAULT NULL,
  `iMaxArticle` int(11) NOT NULL,
  `iMandatorId` smallint(5) NOT NULL DEFAULT '0',
  `iAdmin` int(11) NOT NULL,
  `bCascade` tinyint(1) NOT NULL,
  `sStreet` varchar(255) NOT NULL,
  `sZip` varchar(10) NOT NULL,
  `sTown` varchar(255) NOT NULL,
  `sPhone` varchar(100) NOT NULL,
  `sFax` varchar(100) NOT NULL,
  `sMail` varchar(100) NOT NULL,
  `sHR` varchar(20) NOT NULL,
  `sCEO` varchar(64) NOT NULL,
  `sImpress` longtext NOT NULL,
  `sURL` varchar(255) NOT NULL,
  `sURLs` varchar(255) NOT NULL,
  `sMailAddressWebmaster` varchar(255) NOT NULL,
  `sMailAddressWebmasterText` varchar(255) NOT NULL,
  `sMailAddressService` varchar(255) NOT NULL,
  `sLanguageId` varchar(10) NOT NULL,
  `iCurrencyId` smallint(3) unsigned DEFAULT NULL,
  `iCountryId` int(11) DEFAULT NULL,
  `iDefaultClientGroupId` int(11) DEFAULT NULL,
  `iPurchaseTaxId` smallint(5) unsigned DEFAULT NULL,
  `iMailPatternCustomerRegistrationId` smallint(5) unsigned DEFAULT NULL,
  `iMailPatternContactFormId` smallint(5) unsigned DEFAULT NULL,
  `iMailPatternAddToNewsletterId` smallint(5) unsigned DEFAULT NULL,
  `iMailPatternRemoveFromNewsletterId` smallint(5) unsigned DEFAULT NULL,
  `iMailPatternRecommendationId` smallint(5) unsigned DEFAULT NULL,
  `bShowProductInventory` tinyint(1) NOT NULL,
  `bShowProductIfNotAvailable` tinyint(1) NOT NULL,
  `bAllowOrderIfProductNotAvailable` tinyint(1) NOT NULL,
  `bShowProduct` tinyint(1) NOT NULL,
  `sMandatorDirectory` varchar(255) NOT NULL,
  `sShopDirectory` varchar(255) NOT NULL,
  `sCountryCourtId` varchar(255) NOT NULL,
  `sSalesTaxId` varchar(255) NOT NULL,
  `sOwnerId` varchar(255) NOT NULL,
  `sTaxId` varchar(255) NOT NULL,
  `sWebsiteId` varchar(255) NOT NULL,
  `sTheme` varchar(64) NOT NULL DEFAULT 'orange',
  `iMPDeliveryInformationId` smallint(5) unsigned DEFAULT NULL,
  `sMailAddressOrderMessage` varchar(128) NOT NULL,
  `bProspectDifferingDeliveryAddress` varbinary(1) NOT NULL DEFAULT '1',
  `bRegularCustomerDifferingDeliveryAddress` varbinary(1) NOT NULL DEFAULT '1',
  `iMailPatternObserve` smallint(5) unsigned DEFAULT NULL,
  `bRequiredFieldStreet` varbinary(1) NOT NULL DEFAULT '0',
  `bRequiredFieldPostalCode` varbinary(1) NOT NULL DEFAULT '0',
  `bRequiredFieldLocation` varbinary(1) NOT NULL DEFAULT '0',
  `bRequiredFieldTelephoneNumber` varbinary(1) NOT NULL DEFAULT '0',
  `bRequiredFieldName` varbinary(1) NOT NULL DEFAULT '1',
  `bRequiredFieldFirstName` varbinary(1) NOT NULL DEFAULT '1',
  `bRequiredFieldTelefax` varbinary(1) NOT NULL DEFAULT '0',
  `bRequiredFieldMobileNumber` varbinary(1) NOT NULL DEFAULT '0',
  `bRequiredFieldBirthday` varbinary(1) NOT NULL DEFAULT '0',
  `bRequiredFieldMailAddress` varbinary(1) NOT NULL DEFAULT '1',
  `bRequiredFieldPassword` varbinary(1) NOT NULL DEFAULT '0',
  `iClientGroupNewCustomer` int(11) DEFAULT NULL,
  `iConfirmationOrderMail` smallint(5) unsigned DEFAULT NULL,
  `iWebmasterInfoMailId` smallint(5) unsigned DEFAULT NULL,
  `iPageAfterAddingProductToCart` tinyint(4) NOT NULL,
  `iOrderStatusType` smallint(6) DEFAULT NULL,
  `iNumberOrderProspect` tinyint(4) NOT NULL,
  `bShowPrice` varbinary(1) NOT NULL,
  `RequiredFieldLocation` varchar(255) NOT NULL,
  `sKeyWords` text NOT NULL,
  `sLongName` varchar(250) NOT NULL,
  `bProductFinder` tinyint(1) NOT NULL DEFAULT '0',
  `bActiveLimited` tinyint(1) NOT NULL DEFAULT '0',
  `iActiveFrom` int(12) NOT NULL,
  `iActiveTo` int(12) NOT NULL,
  `bActivateNewClients` binary(1) NOT NULL DEFAULT '1',
  `iMPResetPassword` smallint(5) unsigned DEFAULT NULL,
  `sEmailSignature` text NOT NULL,
  `sEmailGreetings` varchar(250) NOT NULL,
  `eTypeProspectCheck` enum('orders','orderAmount') NOT NULL,
  `sProspectCheck` varchar(32) NOT NULL,
  `sTrustedShopsId` varchar(33) NOT NULL,
  `eRequireEmailVerification` enum('yes','no') NOT NULL,
  `iMPEmailVerification` smallint(5) unsigned NOT NULL,
  `iMailPatternOrderConfirm` smallint(5) unsigned DEFAULT NULL,
  `bOrderByInventoryIsEmpty` tinyint(1) NOT NULL DEFAULT '1',
  `iMailPatternOrderFailure` smallint(5) unsigned DEFAULT NULL,
  `sLogoPath` varchar(150) NOT NULL,
  PRIMARY KEY (`iId`),
  KEY `iAdmin` (`iAdmin`),
  KEY `iMandant` (`iMandatorId`),
  KEY `iParent` (`iParent`),
  KEY `iMailPatternCustomerRegistrationId` (`iMailPatternCustomerRegistrationId`),
  KEY `iMailPatternContactFormId` (`iMailPatternContactFormId`),
  KEY `iMailPatternAddToNewsletterId` (`iMailPatternAddToNewsletterId`),
  KEY `iMailPatternRemoveFromNewsletterId` (`iMailPatternRemoveFromNewsletterId`),
  KEY `iMailPatternRecommendationId` (`iMailPatternRecommendationId`),
  KEY `iMPDeliveryInformationId` (`iMPDeliveryInformationId`),
  KEY `iMailPatternObserve` (`iMailPatternObserve`),
  KEY `iConfirmationOrderMail` (`iConfirmationOrderMail`),
  KEY `iWebmasterInfoMailId` (`iWebmasterInfoMailId`),
  KEY `iMPResetPassword` (`iMPResetPassword`),
  KEY `iPurchaseTaxId` (`iPurchaseTaxId`),
  KEY `iCurrencyId` (`iCurrencyId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Daten für Tabelle `user_shop`
--

INSERT INTO `user_shop` (`iId`, `sName`, `sCompany`, `iParent`, `iMaxArticle`, `iMandatorId`, `iAdmin`, `bCascade`, `sStreet`, `sZip`, `sTown`, `sPhone`, `sFax`, `sMail`, `sHR`, `sCEO`, `sImpress`, `sURL`, `sURLs`, `sMailAddressWebmaster`, `sMailAddressWebmasterText`, `sMailAddressService`, `sLanguageId`, `iCurrencyId`, `iCountryId`, `iDefaultClientGroupId`, `iPurchaseTaxId`, `iMailPatternCustomerRegistrationId`, `iMailPatternContactFormId`, `iMailPatternAddToNewsletterId`, `iMailPatternRemoveFromNewsletterId`, `iMailPatternRecommendationId`, `bShowProductInventory`, `bShowProductIfNotAvailable`, `bAllowOrderIfProductNotAvailable`, `bShowProduct`, `sMandatorDirectory`, `sShopDirectory`, `sCountryCourtId`, `sSalesTaxId`, `sOwnerId`, `sTaxId`, `sWebsiteId`, `sTheme`, `iMPDeliveryInformationId`, `sMailAddressOrderMessage`, `bProspectDifferingDeliveryAddress`, `bRegularCustomerDifferingDeliveryAddress`, `iMailPatternObserve`, `bRequiredFieldStreet`, `bRequiredFieldPostalCode`, `bRequiredFieldLocation`, `bRequiredFieldTelephoneNumber`, `bRequiredFieldName`, `bRequiredFieldFirstName`, `bRequiredFieldTelefax`, `bRequiredFieldMobileNumber`, `bRequiredFieldBirthday`, `bRequiredFieldMailAddress`, `bRequiredFieldPassword`, `iClientGroupNewCustomer`, `iConfirmationOrderMail`, `iWebmasterInfoMailId`, `iPageAfterAddingProductToCart`, `iOrderStatusType`, `iNumberOrderProspect`, `bShowPrice`, `RequiredFieldLocation`, `sKeyWords`, `sLongName`, `bProductFinder`, `bActiveLimited`, `iActiveFrom`, `iActiveTo`, `bActivateNewClients`, `iMPResetPassword`, `sEmailSignature`, `sEmailGreetings`, `eTypeProspectCheck`, `sProspectCheck`, `sTrustedShopsId`, `eRequireEmailVerification`, `iMPEmailVerification`, `iMailPatternOrderConfirm`, `bOrderByInventoryIsEmpty`, `iMailPatternOrderFailure`, `sLogoPath`) VALUES
(1, 'Shop1', 'Testfirma', 0, -1, 1, 1, 0, 'Straße', 'PLZ', 'Ort', 'Telefon', 'Fax', 'E-Mail-Adresse', 'Handelsregister', 'Gesch', '', 'http://www.shop.ley-design.de/', 'http://www.shop.ley-design.de/', 'email@domain.tld', 'email@domain.tld', 'email@domain.tld', 'de', NULL, 10, 1, 1, 3, 6, NULL, NULL, 4, 1, 1, 1, 1, 'm4qsh7', 'rcygda', '', '', '', '', '', 'defaultshop', 7, 'mail@invalid.tld', '1', '1', 1, '1', '1', '1', '0', '1', '1', '0', '0', '0', '1', '0', 1, 1, 5, 1, 9, 0, '1', '', '', '', 0, 0, 0, 0, '1', 2, 'Firma\r\n<br/>Straße \r\n<br/>PLZ Ort\r\n<br/><br/>Telefon: \r\n<br/>Telefax: \r\n<br/>\r\n<br/>Geschäftsführer: \r\n<br/>Handelsregister und Amtsgericht\r\n<br/>\r\n<br/>USt-ID: DE124345', 'Mit freundlichen Grüßen <br/> <br/>', 'orders', '3', '', 'no', 8, 10, 1, 11, '');

--
-- Constraints der exportierten Tabellen
--

--
-- Constraints der Tabelle `contact`
--
ALTER TABLE `contact`
  ADD CONSTRAINT `contact_ibfk_1` FOREIGN KEY (`iShopId`) REFERENCES `user_shop` (`iId`) ON DELETE CASCADE,
  ADD CONSTRAINT `contact_ibfk_4` FOREIGN KEY (`iAddressId`) REFERENCES `contact_address` (`iAddressId`) ON DELETE SET NULL;

--
-- Constraints der Tabelle `contact_address`
--
ALTER TABLE `contact_address`
  ADD CONSTRAINT `contact_address_ibfk_1` FOREIGN KEY (`iCountryId`) REFERENCES `data_country` (`iCountryId`) ON DELETE CASCADE,
  ADD CONSTRAINT `contact_address_ibfk_2` FOREIGN KEY (`iContactId`) REFERENCES `contact` (`iContactId`) ON DELETE CASCADE;

--
-- Constraints der Tabelle `data_country`
--
ALTER TABLE `data_country`
  ADD CONSTRAINT `data_country_ibfk_1` FOREIGN KEY (`iMandatorId`) REFERENCES `user_mandator` (`iId`) ON DELETE CASCADE;

--
-- Constraints der Tabelle `data_currency`
--
ALTER TABLE `data_currency`
  ADD CONSTRAINT `data_currency_ibfk_1` FOREIGN KEY (`iMandatorId`) REFERENCES `user_mandator` (`iId`) ON DELETE CASCADE;

--
-- Constraints der Tabelle `data_mail_pattern`
--
ALTER TABLE `data_mail_pattern`
  ADD CONSTRAINT `data_mail_pattern_ibfk_2` FOREIGN KEY (`iShopId`) REFERENCES `user_shop` (`iId`) ON DELETE CASCADE;

--
-- Constraints der Tabelle `data_purchase_tax`
--
ALTER TABLE `data_purchase_tax`
  ADD CONSTRAINT `data_purchase_tax_ibfk_1` FOREIGN KEY (`iMandatorId`) REFERENCES `user_mandator` (`iId`);

--
-- Constraints der Tabelle `user_shop`
--
ALTER TABLE `user_shop`
  ADD CONSTRAINT `user_shop_ibfk_1` FOREIGN KEY (`iMailPatternCustomerRegistrationId`) REFERENCES `data_mail_pattern` (`iMailPatternId`),
  ADD CONSTRAINT `user_shop_ibfk_14` FOREIGN KEY (`iMailPatternContactFormId`) REFERENCES `data_mail_pattern` (`iMailPatternId`),
  ADD CONSTRAINT `user_shop_ibfk_36` FOREIGN KEY (`iCurrencyId`) REFERENCES `data_currency` (`iCurrencyId`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_shop_ibfk_37` FOREIGN KEY (`iPurchaseTaxId`) REFERENCES `data_purchase_tax` (`iPurchaseTaxId`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_shop_ibfk_38` FOREIGN KEY (`iMailPatternCustomerRegistrationId`) REFERENCES `data_mail_pattern` (`iMailPatternId`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_shop_ibfk_39` FOREIGN KEY (`iMailPatternContactFormId`) REFERENCES `data_mail_pattern` (`iMailPatternId`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_shop_ibfk_40` FOREIGN KEY (`iMailPatternAddToNewsletterId`) REFERENCES `data_mail_pattern` (`iMailPatternId`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_shop_ibfk_41` FOREIGN KEY (`iMailPatternRemoveFromNewsletterId`) REFERENCES `data_mail_pattern` (`iMailPatternId`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_shop_ibfk_42` FOREIGN KEY (`iMailPatternRecommendationId`) REFERENCES `data_mail_pattern` (`iMailPatternId`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_shop_ibfk_43` FOREIGN KEY (`iMPDeliveryInformationId`) REFERENCES `data_mail_pattern` (`iMailPatternId`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_shop_ibfk_44` FOREIGN KEY (`iMailPatternObserve`) REFERENCES `data_mail_pattern` (`iMailPatternId`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_shop_ibfk_45` FOREIGN KEY (`iConfirmationOrderMail`) REFERENCES `data_mail_pattern` (`iMailPatternId`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_shop_ibfk_46` FOREIGN KEY (`iWebmasterInfoMailId`) REFERENCES `data_mail_pattern` (`iMailPatternId`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_shop_ibfk_47` FOREIGN KEY (`iMPResetPassword`) REFERENCES `data_mail_pattern` (`iMailPatternId`) ON DELETE SET NULL;
SET FOREIGN_KEY_CHECKS=1;
Dann zu importieren. Um dann alles zu löschen. Nur bekomme ich bei import wieder eine Fehler Meldung:

Code: Alles auswählen

#1062 - Duplicate entry '1' for key 'PRIMARY'
MFG

Re: MySQL-Datenbanken löschen?

Verfasst: 12.09.2011 04:40
von ProF80
Hat keiner eine Hilfe ???

MFG

Re: MySQL-Datenbanken löschen?

Verfasst: 12.09.2011 06:02
von canonknipser
Die Fehlermeldung bedeutet, dass die Tabelle Daten enthält, die von einer anderen Tabelle als Schlüssel verwendet werden ("Fremdschlüsselbeziehung")
Wenn Eltern ("Parent row") vorhanden sind, gibt es auch Kinder ("Childs").
Vorschlag: Die Tabellen nicht in der Reihenfolge löschen, wie sie dir angeboten werden (also wahrscheinlich alphabetisch), sondern in der Reihenfolge der Schlüsselbeziehungen, also die Childs zuerst.

Re: MySQL-Datenbanken löschen?

Verfasst: 12.09.2011 07:00
von ProF80
Keiner der 8 Tabellen lassen sich einzeln löschen ??

Re: MySQL-Datenbanken löschen?

Verfasst: 12.09.2011 18:41
von Pyramide
Du könntest noch versuchen, alle Tabellen in einem Schritt zu löschen (DROP TABLE a,b,c). Ansonsten die Constraints zuerst händisch löschen (ALTER TABLE x DROP FOREIGN KEY y).

Re: MySQL-Datenbanken löschen?

Verfasst: 13.09.2011 12:06
von ProF80
???
Kannst du das genauer erklären , bitte ?


MFG

Re: MySQL-Datenbanken löschen?

Verfasst: 13.09.2011 18:37
von Pyramide
http://dev.mysql.com/doc/refman/5.5/en/ ... html#c7393
http://dev.mysql.com/doc/refman/5.5/en/ ... #id1086333
Alle Zeiten sind UTC+02:00
Seite 1 von 1

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de