Unknown Column Name when Importing Table

Question

Hello all,

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 - Unknown column 'font_name' in 'field list'

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

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?

Thanks all for any help

edit

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

Answer 1

try a command line mysqldump instead of phpmyadmin