导入表时未知列名 [英] Unknown Column Name when Importing Table

问题描述

我刚刚使用phpMyAdmin导出了一个表，并且尝试通过导入刚导出的sql文件将该表导入到本地数据库中.在phpMyAdmin导入15,000的330行之后.它说:

I have just exported a table using phpMyAdmin and I have tried to import this table into my local database by importing the sql file I have just exported. After phpMyAdmin imports 330 rows of the 15,000. It says:

1054-中的未知列"font_name" 字段列表"

1054 - Unknown column 'font_name' in 'field list'

怎么可能出问题了，我以为是直接导出/导入?

How can anything go wrong, I thought it was straight forward export/import?

我看过第330行和第331行，两列中没有任何错误.

I have had a look at row 330 and 331 and there isn't anything wrong within the two columns.

如何缩小范围?可能是什么问题?

How can I narrow this down? What is the problem likely to be?

感谢所有帮助

CREATE TABLE IF NOT EXISTS `tags2` (
  `font_name` varchar(250) NOT NULL,
  `tags` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

推荐答案

尝试使用命令行mysqldump代替phpmyadmin

try a command line mysqldump instead of phpmyadmin

这篇关于导入表时未知列名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！