MySQL-Datenbanken löschen?

[siRus101]

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:

#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

ET FOREIGN_KEY_CHECKS=0;
SET FOREIGN_KEY_CHECKS=1;

einfügen zu lassen :

-- 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:

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

MFG

[dipo01]

http://dev.mysql.com/doc/refman/5.0/...-database.html
sollte dein problem lösen