MySQL-Datenbanken löschen?

Fragen zu allen Themen rund ums Programmieren außerhalb von phpBB können hier gestellt werden - auch zu anderen Programmiersprachen oder Software wie Webservern und Editoren.
Antworten
ProF80
Mitglied
Beiträge: 222
Registriert: 29.07.2007 18:43

MySQL-Datenbanken löschen?

Beitrag 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
Nach oben
ProF80
Mitglied
Beiträge: 222
Registriert: 29.07.2007 18:43

Re: MySQL-Datenbanken löschen?

Beitrag von ProF80 »

Hat keiner eine Hilfe ???

MFG
Nach oben
Benutzeravatar
canonknipser
Ehemaliges Teammitglied
Beiträge: 2053
Registriert: 10.09.2011 11:14
Kontaktdaten:
Kontaktdaten von canonknipser

Re: MySQL-Datenbanken löschen?

Beitrag 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.
Grüße, canonknipser
"there are only 10 types of people: those, who understand binary and those, who don't"
just arrived ;) - Bilder
Kein Support via PN, nur im Board und (manchmal) im IRC
Nach oben
ProF80
Mitglied
Beiträge: 222
Registriert: 29.07.2007 18:43

Re: MySQL-Datenbanken löschen?

Beitrag von ProF80 »

Keiner der 8 Tabellen lassen sich einzeln löschen ??
Nach oben
Benutzeravatar
Pyramide
Ehrenadmin
Beiträge: 12734
Registriert: 19.04.2001 02:00
Wohnort: Meschede

Re: MySQL-Datenbanken löschen?

Beitrag 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).
KB:knigge
Nach oben
ProF80
Mitglied
Beiträge: 222
Registriert: 29.07.2007 18:43

Re: MySQL-Datenbanken löschen?

Beitrag von ProF80 »

???
Kannst du das genauer erklären , bitte ?


MFG
Nach oben
Benutzeravatar
Pyramide
Ehrenadmin
Beiträge: 12734
Registriert: 19.04.2001 02:00
Wohnort: Meschede

Re: MySQL-Datenbanken löschen?

Beitrag von Pyramide »

http://dev.mysql.com/doc/refman/5.5/en/ ... html#c7393
http://dev.mysql.com/doc/refman/5.5/en/ ... #id1086333
KB:knigge
Nach oben
Antworten

Zurück zu „Coding & Technik“