Hi Jennie, could you say me please, how can I import tables in a database with a file. I have a .sql-File and the content is for example like this:
data.sql
DROP TABLE IF EXISTS `actor`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `actor` ( `actor_id` int(8) NOT NULL, `first_name` varchar(50) DEFAULT NULL, `last_name` varchar(50) NOT NULL, `initials` varchar(10) DEFAULT NULL, PRIMARY KEY (`actor_id`) ) LOCK TABLES `actor` WRITE; /*!40000 ALTER TABLE `actor` DISABLE KEYS */; INSERT INTO `actor` VALUES (1,'Mack','10',NULL),(2,'Highway','101',NULL), ... INSERT INTO `actor` VALUES (33350,'Nicholas','Pasco',NULL),(33351,'Richard', ... INSERT INTO `actor` VALUES (66434,'Joseph','Roman',NULL),(66435,'Garry', ... This file contains nearly by 20 tables with data sets. Thanks -- View this message in context: http://old.nabble.com/Create-Database---Load-Data-tp31653813p31752251.html Sent from the monetdb-users mailing list archive at Nabble.com.