# Ich habe die Kategorie komplett gelöscht

**URL:** <https://forum.shopware.com/t/ich-habe-die-kategorie-komplett-geloscht/9850>\
**Category:** Shopware 3.5\
**Tags:** administration\
**Created:** [15. November 2012 um 00:49 UTC](https://forum.shopware.com/t/ich-habe-die-kategorie-komplett-geloscht/9850 "2012-11-15T00:49:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![shopalado](https://avatars.discourse-cdn.com/v4/letter/s/7993a0/32.png) [@shopalado](https://forum.shopware.com/u/shopalado)\
**Post date:** [15. November 2012 um 00:49 UTC](https://forum.shopware.com/t/ich-habe-die-kategorie-komplett-geloscht/9850/1 "2012-11-15T00:49:29Z")

</div>

Ich habe die Kategorie komplett gelöscht, da vor habe ich per MySQLDumper Backup gemacht, wollte wiederherstellen geht leider nicht. Kann mir jemand helfen, über Dumper bekomme folgender Fehler. `MySQL-ERROR MySQL meldet: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB AUTO\_INCREMENT=119' at line 59 Fehler bei der Anfrage: CREATE TABLE `s_categories` ( `id` int(11) unsigned NOT NULL AUTO\_INCREMENT, `parent` int(11) unsigned DEFAULT NULL, `description` varchar(255) NOT NULL, `position` int(11) unsigned DEFAULT '0', `left` int(11) unsigned NOT NULL, `right` int(11) unsigned NOT NULL, `level` int(11) unsigned NOT NULL, `added` datetime NOT NULL, `changed` datetime NOT NULL, `metakeywords` mediumtext, `metadescription` mediumtext, `cmsheadline` varchar(255) DEFAULT NULL, `cmstext` mediumtext, `template` varchar(255) DEFAULT NULL, `noviewselect` int(1) unsigned DEFAULT NULL, `active` int(1) NOT NULL, `blog` int(11) NOT NULL, `showfiltergroups` int(11) NOT NULL, `external` varchar(255) DEFAULT NULL, `hidefilter` int(1) NOT NULL, `hidetop` int(1) NOT NULL, `mediaID` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `parent` (`parent`), KEY `description` (`description`), KEY `position` (`position`), KEY `left` (`left`,`right`), KEY `level` (`level`) ) TYPE=InnoDB AUTO\_INCREMENT=119; `