I have come across what may potentially be a bug in the csv import functionality of the phpmyadmin version 3.3.9. I have a tab delimited file. No major problems there, I just fill in the proper values in the import section and all should be well. The problem is that even with the proper field termination values input, the import script is failing due to the fact that it is not picking up any of the field names even though they do indeed exist. I have tested the file with another import tool and it imports fine so I am certain that this error is specific to the phpmyadmin installation. Any thoughts on this or has anyone else encountered it.
Here is the error message.
CREATE TABLE IF NOT EXISTS `boneill_data`.`TABLE 1` ( ) ENGINE = MYISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Documentation #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 ') ENGINE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1
You can see the problem, there are no field names between the brackets as phpmyadmin is not detecting them. Any thoughts are appreciated.
I have further confirmed this problem by saving the text file as an open document spreadsheet. I then tried to import the open document spreadsheet and it came in fine. This further supports the possibility of it being a big in the csv import functionality.