SQL Import

s3bb0 · June 25, 2012, 5:50pm

Hallo,

ich weiß nicht, ob ich hier richtig bin, aber da ich probleme beim einlesen des sql backups habe, wollte ich nun die befehle einzeln über phpMyadmin reinkopieren.

nur leider bingt er mir bei folgendem befehl:

CREATE TABLE `oxconfigdisplay` (
  `OXID` char(32) collate latin1_general_ci NOT NULL,
  `OXCFGMODULE` varchar(32) collate latin1_general_ci NOT NULL default '',
  `OXCFGVARNAME` char(32) collate latin1_general_ci NOT NULL default '',
  `OXGROUPING` varchar(255) collate latin1_general_ci NOT NULL default ''
  `OXPOS` int(11) NOT NULL default '0',
  PRIMARY KEY  (`OXID`),
  KEY `list` (`OXCFGMODULE`,`OXCFGVARNAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

den Fehler:

MySQL meldet: 

#1064 - 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 '`OXPOS` int(11) NOT NULL default '0',
  PRIMARY KEY  (`OXID`),
  KEY `list` (`' at line 6

ausserdem kann ich folgendes nicht eingeben:

INSERT DELAYED IGNORE INTO `oxarticles` (`OXID`, `OXSHOPID`, `OXPARENTID`, `OXACTIVE`, `OXACTIVEFROM`, `OXACTIVETO`, `OXARTNUM`, `OXEAN`, `OXDISTEAN`, `OXMPN`, `OXTITLE`, `OXSHORTDESC`, `OXPRICE`, `OXBLFIXEDPRICE`, `OXPRICEA`, `OXPRICEB`, `OXPRICEC`, `OXBPRICE`, `OXTPRICE`, `OXUNITNAME`, `OXUNITQUANTITY`, `OXEXTURL`, `OXURLDESC`, `OXURLIMG`, `OXVAT`, `OXTHUMB`, `OXICON`, `OXPICSGENERATED`, `OXPIC1`, `OXPIC2`, `OXPIC3`, `OXPIC4`, `OXPIC5`, `OXPIC6`, `OXPIC7`, `OXPIC8`, `OXPIC9`, `OXPIC10`, `OXPIC11`, `OXPIC12`, `OXWEIGHT`, `OXSTOCK`, `OXSTOCKFLAG`, `OXSTOCKTEXT`, `OXNOSTOCKTEXT`, `OXDELIVERY`, `OXINSERT`, `OXTIMESTAMP`, `OXLENGTH`, `OXWIDTH`, `OXHEIGHT`, `OXFILE`, `OXSEARCHKEYS`, `OXTEMPLATE`, `OXQUESTIONEMAIL`, `OXISSEARCH`, `OXISCONFIGURABLE`, `OXVARNAME`, `OXVARSTOCK`, `OXVARCOUNT`, `OXVARSELECT`, `OXVARMINPRICE`, `OXVARNAME_1`, `OXVARSELECT_1`, `OXVARNAME_2`, `OXVARSELECT_2`, `OXVARNAME_3`, `OXVARSELECT_3`, `OXTITLE_1`, `OXSHORTDESC_1`, `OXURLDESC_1`, `OXSEARCHKEYS_1`, `OXTITLE_2`, `OXSHORTDESC_2`, `OXURLDESC_2`, `OXSEARCHKEYS_2`, `OXTITLE_3`, `OXSHORTDESC_3`, `OXURLDESC_3`, `OXSEARCHKEYS_3`, `OXBUNDLEID`, `OXFOLDER`, `OXSUBCLASS`, `OXSTOCKTEXT_1`, `OXSTOCKTEXT_2`, `OXSTOCKTEXT_3`, `OXNOSTOCKTEXT_1`, `OXNOSTOCKTEXT_2`, `OXNOSTOCKTEXT_3`, `OXSORT`, `OXSOLDAMOUNT`, `OXNONMATERIAL`, `OXFREESHIPPING`, `OXREMINDACTIVE`, `OXREMINDAMOUNT`, `OXAMITEMID`, `OXAMTASKID`, `OXVENDORID`, `OXMANUFACTURERID`, `OXSKIPDISCOUNTS`, `OXRATING`, `OXRATINGCNT`, `OXMINDELTIME`, `OXMAXDELTIME`, `OXDELTIMEUNIT`, `oxefichecksum`, `oxeficschecksum`, `oxeficatchecksum`, `oxefivendorchecksum`, `oxefiattribchecksum`, `oxefiartextchecksum`, `oxefimanufactchecksum`) VALUES ('1ur92260ad3fbd2c81586ca542cf60c6', 'oxbaseshop', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1001', '', '', '', 'CLASSICO Set', 'Set, bestehend aus Gefäß und Einsatz.', 19.95, 0, 0, 0, 0, 0, 0, '', 0, '', '', '', NULL, 'classicoalljpg_mini.jpg', 'classicoalljpg_mini.jpg', 0, '', '0083.jpg', '007.jpg', '0092.jpg', '0102.jpg', '0112.jpg', '0122.jpg', '', '', '', '', '', 0, 0, 4, '', '', '0000-00-00', '2012-03-11', '2012-06-19 12:52:42', 0, 0, 0, 'classicoalljpg_mini.jpg', 'classico', '', '', 1, 0, 'Farbe | Größe (in cm)', 3, 42, '', 21.95, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'oxarticle', '', '', '', '', '', '', 0, 3, 0, 0, 0, 0, '', '', '7vsee369d6304ce5338afe09da74bf53', '7vs28fe5dd977665ccea8093b5b65d6e', 0, 0, 0, 0, 0, 'DAY', '464d215068ee3726aa7dd0a49c03fe7d', 'd41d8cd98f00b204e9800998ecf8427e', 'fd72a0ae07cb09348c49113b0ebfaa88', '4a10cdecfdf1395c78529e0ec88655b7', 'd41d8cd98f00b204e9800998ecf8427e', 'd0ef81942a79596af5990216e3d17b4e', '4a10cdecfdf1395c78529e0ec88655b7'),
('2vj00127e751757dc4993664e5bf7eda', 'oxbaseshop', '2vjef29b8ae93ccb24fbd8d819bbe3aa', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1014-02-03', '', '', '', '', '', 47.95, 0, 0, 0, 0, 0, 0, '', 0, '', '', '', NULL, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 4, '', '', '0000-00-00', '2012-03-13', '2012-05-11 18:05:35', 0, 0, 0, '', '', '', '', 0, 0, '', 0, 0, 'mokka | Ø32 x 56', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'oxarticle', '', '', '', '', '', '', 6, 0, 0, 0, 0, 0, '', '', '', '', 0, 0, 0, 0, 0, '', 'f4426695a781e249254e2b9d65feb884', 'd41d8cd98f00b204e9800998ecf8427e', 'bd3c9d1f8a4bfe07d8a184ce65731270', 'd41d8cd98f00b204e9800998ecf8427e', 'd41d8cd98f00b204e9800998ecf8427e', 'd0ef81942a79596af5990216e3d17b4e', 'd41d8cd98f00b204e9800998ecf8427e'),
('2vj00a8ac2fbda1ab9ddec49de9073df', 'oxbaseshop', '2vjabf45ce9834e2df9f7fcc1ec98078', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1015-01-03', '', '', '', '', '', 47.95, 0, 0, 0, 0, 0, 0, '', 0, '', '', '', NULL, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 4, '', '', '0000-00-00', '2012-03-13', '2012-05-11 18:05:35', 0, 0, 0, '', '', '', '', 0, 0, '', 0, 0, 'mokka | 30 x 30 x 56', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'oxarticle', '', '', '', '', '', '', 5, 0, 0, 0, 0, 0, '', '', '', '', 0, 0, 0, 0, 0, '', 'c95722c74db7de45951fc6d9e5765697', 'd41d8cd98f00b204e9800998ecf8427e', 'bd3c9d1f8a4bfe07d8a184ce65731270', 'd41d8cd98f00b204e9800998ecf8427e', 'd41d8cd98f00b204e9800998ecf8427e', 'd0ef81942a79596af5990216e3d17b4e', 'd41d8cd98f00b204e9800998ecf8427e'),
.
.
.
.
.
.****code gekürzt, denn er ist über 230 Zeilen lang ****

hierbei kommt es zu einem timeout.
könnt ihr mir helfen, wie ich dies ermöglichen kann?

warum ich den Import so umständlich mache ?
weil ich beim normalen import über phpmyadmin folgenden fehler bekomme

#1031 - Table storage engine for 'oxarticles' doesn't have this option

könnt ihr mir helfen, wie ich das backup zurückspielen kann ?

dank euch

Tom_Long · June 25, 2012, 6:06pm

Moin s3bb0,

warum machst du das nicht direkt am SQL Prompt?
Geht schneller, einfacher und vor allem AM STÜCK, egal wie gross die Importdatei ist.

Oder wenn du auf sowas keinen Zugriff hast, probiers doch mal als CSV.
Damit kriege ich so ziemlich alles importiert.

Beste Grüsse

Thomas

s3bb0 · June 25, 2012, 6:31pm

danke für deine schnelle Antwort!

wenn ich im SQL fenster einfach alles reinkopier und absende kommt nach einiger zeit :

#1031 - Table storage engine for ‘oxarticles’ doesn’t have this option

oxarticles sieht folgend aus:

CREATE TABLE oxarticles (
OXID char(32) collate latin1_general_ci NOT NULL,
OXSHOPID varchar(32) collate latin1_general_ci NOT NULL default ‘’,
OXPARENTID char(32) collate latin1_general_ci NOT NULL default ‘’,
OXACTIVE tinyint(1) NOT NULL default ‘1’,
OXACTIVEFROM datetime NOT NULL default ‘0000-00-00 00:00:00’,
OXACTIVETO datetime NOT NULL default ‘0000-00-00 00:00:00’,
OXARTNUM varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXEAN varchar(13) collate latin1_general_ci NOT NULL default ‘’,
OXDISTEAN varchar(13) collate latin1_general_ci NOT NULL default ‘’,
OXMPN varchar(16) collate latin1_general_ci NOT NULL default ‘’,
OXTITLE varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXSHORTDESC varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXPRICE double NOT NULL default ‘0’,
OXBLFIXEDPRICE tinyint(1) NOT NULL default ‘0’,
OXPRICEA double NOT NULL default ‘0’,
OXPRICEB double NOT NULL default ‘0’,
OXPRICEC double NOT NULL default ‘0’,
OXBPRICE double NOT NULL default ‘0’,
OXTPRICE double NOT NULL default ‘0’,
OXUNITNAME varchar(32) collate latin1_general_ci NOT NULL default ‘’,
OXUNITQUANTITY double NOT NULL default ‘0’,
OXEXTURL varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXURLDESC varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXURLIMG varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXVAT float default NULL,
OXTHUMB varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXICON varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXPICSGENERATED tinyint(3) NOT NULL default ‘0’,
OXPIC1 varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXPIC2 varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXPIC3 varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXPIC4 varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXPIC5 varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXPIC6 varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXPIC7 varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXPIC8 varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXPIC9 varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXPIC10 varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXPIC11 varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXPIC12 varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXWEIGHT double NOT NULL default ‘0’,
OXSTOCK double NOT NULL default ‘-1’,
OXSTOCKFLAG tinyint(1) NOT NULL default ‘1’,
OXSTOCKTEXT varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXNOSTOCKTEXT varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXDELIVERY date NOT NULL default ‘0000-00-00’,
OXINSERT date NOT NULL default ‘0000-00-00’,
OXTIMESTAMP timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
OXLENGTH double NOT NULL default ‘0’,
OXWIDTH double NOT NULL default ‘0’,
OXHEIGHT double NOT NULL default ‘0’,
OXFILE varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXSEARCHKEYS varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXTEMPLATE varchar(128) collate latin1_general_ci NOT NULL default ‘’,
OXQUESTIONEMAIL varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXISSEARCH tinyint(1) NOT NULL default ‘1’,
OXISCONFIGURABLE tinyint(4) NOT NULL default ‘0’,
OXVARNAME varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXVARSTOCK int(5) NOT NULL default ‘0’,
OXVARCOUNT int(1) NOT NULL default ‘0’,
OXVARSELECT varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXVARMINPRICE double NOT NULL default ‘0’,
OXVARNAME_1 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXVARSELECT_1 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXVARNAME_2 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXVARSELECT_2 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXVARNAME_3 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXVARSELECT_3 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXTITLE_1 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXSHORTDESC_1 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXURLDESC_1 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXSEARCHKEYS_1 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXTITLE_2 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXSHORTDESC_2 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXURLDESC_2 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXSEARCHKEYS_2 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXTITLE_3 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXSHORTDESC_3 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXURLDESC_3 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXSEARCHKEYS_3 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXBUNDLEID varchar(32) collate latin1_general_ci NOT NULL default ‘’,
OXFOLDER varchar(32) collate latin1_general_ci NOT NULL default ‘’,
OXSUBCLASS varchar(32) collate latin1_general_ci NOT NULL default ‘’,
OXSTOCKTEXT_1 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXSTOCKTEXT_2 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXSTOCKTEXT_3 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXNOSTOCKTEXT_1 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXNOSTOCKTEXT_2 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXNOSTOCKTEXT_3 varchar(255) collate latin1_general_ci NOT NULL default ‘’,
OXSORT int(5) NOT NULL default ‘0’,
OXSOLDAMOUNT double NOT NULL default ‘0’,
OXNONMATERIAL int(1) NOT NULL default ‘0’,
OXFREESHIPPING int(1) NOT NULL default ‘0’,
OXREMINDACTIVE int(1) NOT NULL default ‘0’,
OXREMINDAMOUNT double NOT NULL default ‘0’,
OXAMITEMID varchar(32) collate latin1_general_ci NOT NULL default ‘’,
OXAMTASKID varchar(16) collate latin1_general_ci NOT NULL default ‘0’,
OXVENDORID char(32) collate latin1_general_ci NOT NULL default ‘’,
OXMANUFACTURERID char(32) collate latin1_general_ci NOT NULL default ‘’,
OXSKIPDISCOUNTS tinyint(1) NOT NULL default ‘0’,
OXRATING double NOT NULL default ‘0’,
OXRATINGCNT int(11) NOT NULL default ‘0’,
OXMINDELTIME int(11) NOT NULL default ‘0’,
OXMAXDELTIME int(11) NOT NULL default ‘0’,
OXDELTIMEUNIT varchar(255) collate latin1_general_ci NOT NULL default ‘’,
oxefichecksum char(33) collate latin1_general_ci NOT NULL,
oxeficschecksum char(33) collate latin1_general_ci NOT NULL,
oxeficatchecksum char(33) collate latin1_general_ci NOT NULL,
oxefivendorchecksum char(33) collate latin1_general_ci NOT NULL,
oxefiattribchecksum char(33) collate latin1_general_ci NOT NULL,
oxefiartextchecksum char(33) collate latin1_general_ci NOT NULL,
oxefimanufactchecksum char(33) collate latin1_general_ci NOT NULL,
PRIMARY KEY (OXID),
KEY OXCOUNT (OXPARENTID,OXSHOPID),
KEY OXSORT (OXSORT),
KEY OXSHOPID (OXSHOPID),
KEY OXISSEARCH (OXISSEARCH),
KEY OXARTNUM (OXARTNUM),
KEY OXSTOCK (OXSTOCK),
KEY OXSTOCKFLAG (OXSTOCKFLAG),
KEY OXINSERT (OXINSERT),
KEY OXVARNAME (OXVARNAME),
KEY OXACTIVE (OXACTIVE),
KEY OXACTIVEFROM (OXACTIVEFROM),
KEY OXACTIVETO (OXACTIVETO),
KEY OXVENDORID (OXVENDORID),
KEY OXMANUFACTURERID (OXMANUFACTURERID),
KEY oxefichecksum (oxefichecksum),
KEY oxeficschecksum (oxeficschecksum),
KEY oxeficatchecksum (oxeficatchecksum),
KEY oxefivendorchecksum (oxefivendorchecksum),
KEY oxefiattribchecksum (oxefiattribchecksum),
KEY oxefiartextchecksum (oxefiartextchecksum),
KEY oxefimanufactchecksum (oxefimanufactchecksum)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

csv kann ich leider nicht importieren und ich hab leider nur sql dateien

Tom_Long · June 25, 2012, 7:11pm

Moin s3bb0,

hast du nen Shell Zugang? Ist das ein eigener Server oder nur Webspace?
Sonst probier doch mal den SQL-Dumper aus.
Steht auch schon in deinem anderen Thread.

Beste Grüsse

Thomas

s3bb0 · June 25, 2012, 8:12pm

ja nen Shell Zugang hätte ich.
Das is ein Webspace von Strato.

EDIT:
so nun hab ich jeden fehler beim Import gefunden.

so wie es aussieht ist beim Export schon was schief gelaufen…

hab die DB jetzt händisch importiert und hab keine fehler mehr bekommen.
trotzdem fonktioniert der Seitenaufruf noch nicht

Fatal error: Class ‘oxStart’ not found in /mnt/webf/a1/74/*******/htdocs/webshop/core/oxconfig.php on line 456

in der oxconfig.php steht :
455: //application initialization
456: $this->_oStart = new oxStart();
457 $this->_oStart->appInit();
}
in der config.inc.php passt alles und oxchkversion.php sagt :

Edition CE
Version 4.5.8
Revision 42471

Summary

OK 897
Modified 3
Version mismatch 0
Unknown 7
Number of investigated files in total: 907

This OXID eShop does not fit 100% CE_4.5.8_42471.

woran könnte das nun noch liegen ?

Tom_Long · June 26, 2012, 6:25am

Moin s3bbo,

HMM…

Also ein Shell-Zugang und WEBSPACE widersprechen sich irgendwie ziemlich.
Erzähl doch mal, was du da hast und wir kriegen das schon hin.

Beste Grüsse

Thomas

s3bb0 · June 26, 2012, 9:57am

Moin Tom,

hmm
also ich hab bei Strato PowerWeb Basic.
Dabei kann ich via Putty auf die SQLbackups zugreifen, selber anlegen und rücksichern. ( Nur leider ist bei jedem automatisch erstellten backup ein fehler, deswegen kann ich die nicht verwenden)

Danke für deine Hilfe!