PHPMyadmin import CSV creates new table

I am trying to import some data into a MySQL 5.5.31 table from a CSV file using PHPMyadmin 4.0.0.

When I try to import, the import "works" but it creates a new table rather than imports into the current table - the new table is assigned a sequential name by PHPMyadmin and, whilst the data is viewable, the data is not usable as the table does not contain a unique column.

Here is a screenshot of the settings I am using to import which also shows I am trying to import into the table:

And here is the result I get from PHPMyadmin:

Any idea why this is happening? I have tried searching for the "The following structures have either been created or altered" message but found nothing here and only a few things on Google but none of the Google responses were of any help.

Answers


This is a bug in phpMyAdmin and it has been fixed since version 4.0.1. See 14 item under 4.0.1.0 (2013-05-14) section of the change log file. Upgrade to 4.0.1 or a version greater than that.


Need Your Help

Reference to another item inside a ListView with ViewHolder

android baseadapter android-viewholder

I need a little bit of help: I have a listview with a custom list item and a viewholder. The code I copied represents the adapter I am using but a simplier version. For the sake of simplicity, lets...

How to shrink a log file without backuping first?

sql sql-server-2008-r2 ssms

I have a SQL Server 2008 database with a .mdf file with 1 GB and a .ldf file (log) with 70 GB. I really don't know what took my log file to be so big in a week and to stop to increase, but my main ...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.