Hi JAM,
Thank You for Your answer. But it didn't work for me. (I'm a beginner!)
I've tried
Code: Select all
mysql> LOAD DATA INFILE "/Users/gerhard/Sites/quickstart/typo3conf/tt_content.sql" INTO TABLE test6.tt_content.sql;
ERROR 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 '.sql' at line 1
and got the error, that the table does not exist. I want to import the dumped table. And MySQL should create the table and fill it with content.
In Typo3 I can import this file from the 'install' dialog. It's no problem. But I don't want to import 63 files manually.
This is the dumped file I want to import (shorted):
Code: Select all
-- MySQL dump 9.11
--
-- Host: db336.1und1.de Database: db105030711
-- ------------------------------------------------------
-- Server version 4.0.23-standard-log
--
-- Table structure for table `tt_content`
--
DROP TABLE IF EXISTS tt_content;
CREATE TABLE tt_content (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
hidden tinyint(4) unsigned NOT NULL default '0',
sorting int(11) unsigned NOT NULL default '0',
CType varchar(30) NOT NULL default '',
...
tx_xinittwocolumn_type int(11) unsigned NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
--
-- Dumping data for table `tt_content`
--
/*!40000 ALTER TABLE tt_content DISABLE KEYS */;
LOCK TABLES tt_content WRITE;
INSERT INTO tt_content VALUES (1,1,1087982660,0,1000000000,'text','Mal sehen, wie es geht',...;
UNLOCK TABLES;
/*!40000 ALTER TABLE tt_content ENABLE KEYS */;