Hi all i want to import a text or csv file using "import" on heidisql but the database im importing too is blank, so it wont let me do it without a table, why cant i just copy/paste SQL and run query like you can do in phpmyadmin? its extremely frustrating, its taken me an hour so far!
please help!
Simple import not happening
why cant i just copy/paste SQL and run query like you can do in phpmyadmin? its extremely frustrating, its taken me an hour so far!
Well, you can. SQL is not the problem, just load or paste some SQL queries into the query tab and press the "Execute" button (F9). But you said you have a CSV file, not an SQL file, so I'm confused now.
second error attachedhttp://www.ultimadevelopments.info/oxford2012/heidisqlerror.png
* "Duplicate Entry": You have a unique or primary key in that table and the script contains more than 1 row with the same value ("1" in your case)
* "USING BTREE" is not supported by MySQL 5.0 and older. See here, or just remove the "USING BTREE" from your script.
I guess you are trying to run a script from a 5.5 server onto an older server?
* "USING BTREE" is not supported by MySQL 5.0 and older. See here, or just remove the "USING BTREE" from your script.
I guess you are trying to run a script from a 5.5 server onto an older server?
Please login to leave a reply, or register at first.