´╗┐附近的语法错误

塞萨里翁

嗨,我正在尝试找出如何从txt文件在MySQL中还原数据库的方法。

txt文件:

-- MySQL dump 10.11
--
-- Host: localhost    Database: labb
-- ------------------------------------------------------
-- Server version   5.0.45-community-nt

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `bil`
--

DROP TABLE IF EXISTS `bil`;
CREATE TABLE `bil` (
  `regnr` varchar(10) NOT NULL,
  `marke` varchar(20) NOT NULL,
  `farg` varchar(20) NOT NULL,
  `agare` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`regnr`),
  KEY `FK_bilagare` (`agare`),
  CONSTRAINT `FK_bilagare` FOREIGN KEY (`agare`) REFERENCES `person` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bil`
--

LOCK TABLES `bil` WRITE;
/*!40000 ALTER TABLE `bil` DISABLE KEYS */;
INSERT INTO `bil` VALUES ('ABC123','VOLVO','blå',1),('BCD234','SAAB','gul',2),('CDE451','FIAT','svart',3),('FFF333','NISSAN','grön',4),('GGH011','AUDI','svart',17),('GGH445','DODGE','brun',6),('JGR344','FIAT','svart',8),('KFS929','FIAT','brun',16),('KGB654','VOLVO','brun',15),('KOOL01','VOLVO','svart',12),('KRF799','AUDI','blå',7),('OKS555','SAAB','vit',18),('OOD001','FIAT','röd',10),('PAD902','NISSAN','grå',10),('PED900','SAAB','grön',13),('RFN754','MERCEDES','svart',19),('SLL989','SAAB','svart',13),('TJJ675','NISSAN','silver',9),('TYY764','NISSAN','vit',14),('UFF220','PEUGEOT','gul',18),('UUU110','PEUGEOT','vit',7);
/*!40000 ALTER TABLE `bil` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `person`
--

DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fnamn` varchar(20) NOT NULL,
  `enamn` varchar(20) NOT NULL,
  `stad` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `person`
--

LOCK TABLES `person` WRITE;
/*!40000 ALTER TABLE `person` DISABLE KEYS */;
INSERT INTO `person` VALUES (1,'Lina','Karlsson','Stockholm'),(2,'Lena','Svensson','Lund'),(3,'Lisa','Fredriksson','Uppsala'),(4,'Maria','Bergström','Umeå'),(5,'Karin','Sjödahl','Lund'),(6,'Kristina','Boström','Stockholm'),(7,'Pia','Bengtsson','Stockholm'),(8,'Ulrika','Alfredsson','Lund'),(9,'Maria','Berglund','Stockholm'),(10,'Sara','Ling','Uppsala'),(11,'Kerstin','Kruger','Stockholm'),(12,'Christina','Lambert','Göteborg'),(13,'Greta','Westin','Göteborg'),(14,'Gustav','Westman','Stockholm'),(15,'Peter','Thor','Stockholm'),(16,'Peter','Nordlund','Lund'),(17,'Harald','Olsson','Stockholm'),(18,'Lars-Erik','Pettersson','Göteborg'),(19,'Alexander','Sederlind','Örebro');
/*!40000 ALTER TABLE `person` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2007-09-01 17:29:18

我当前的MySQL命令和结果:

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 5.1.73-community MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> \. /Users/myusername/Desktop/Lab/labbdb.txt
ERROR 1064 (42000): 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 '´╗┐





/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
Query OK, 0 rows affected (0.00 sec)

ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
ERROR 1046 (3D000): No database selected
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'NULL'
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql>

目前发生了什么事?您如何还原该脚本?

阿尔瓦罗·冈萨雷斯(Alvaro Gonzalez)

这些´╗┐符号似乎是UTF-8 BOM,被误解为CP850字符(西欧的默认Windows代码页)。由于BOM既不是必需的也不是推荐的,则可以将其剥离。

本文收集自互联网,转载请注明来源。

如有侵权,请联系[email protected] 删除。

编辑于
0

我来说两句

0条评论
登录后参与评论

相关文章

来自分类Dev

Postgresql:“-”或附近的语法错误

来自分类Dev

在“ IF”或附近的Postgres语法错误

来自分类Dev

“或”附近的plpgsql语法错误

来自分类Dev

INTERSECT附近的语法错误

来自分类Dev

AWK错误-grep或附近的语法错误

来自分类Dev

“ WHERE”或附近的语法错误

来自分类Dev

PostgreSQL错误:“ varchar”或附近的语法错误

来自分类Dev

在“ THEN”或附近的Postgresql语法错误

来自分类Dev

SQL语法错误:“(”附近

来自分类Dev

$$ DELIMITER附近的语法错误

来自分类Dev

PostgreSQL或附近的语法错误

来自分类Dev

PostgreSQL错误:“ PRIMARY”或附近的语法错误

来自分类Dev

{ScientistSeedError:'或附近[[“']的语法错误

来自分类Dev

错误:“选择”或附近的语法错误

来自分类Dev

或附近“(”的Postgresql语法错误

来自分类Dev

''附近的MySQL语法错误

来自分类Dev

“ posedge”附近的语法错误

来自分类Dev

PostgreSQL:“ ||”或附近的语法错误

来自分类Dev

“ @gmail”语法错误附近

来自分类Dev

“ +”或附近的psql语法错误

来自分类Dev

SQLite语法错误附近“?”

来自分类Dev

PostgreSQL或附近的语法错误:

来自分类Dev

在“ THEN”或附近的Postgresql语法错误

来自分类Dev

SQL语法错误:“(”附近

来自分类Dev

PostgreSQL:“。”或附近的语法错误。

来自分类Dev

PERL语法错误在“ =”附近

来自分类Dev

附近的语法错误 , 和 )

来自分类Dev

行为附近的语法错误

来自分类Dev

“;”附近的PLSQL语法错误