[OT] phpmyadmin -- trouble importing

[sciguy-Ja3L+HSX0kI at public.gmane.org]

Well, at least the errors now are different. I was only able to read 
two tables, then it died. Since I am a newbie at this, I admit to not 
knowing what setting was appropriate for "Collation".  I used all of 
the defaults. Also, how does one find out the charset used for the 
database?
-----------8<------------------
The error I get is: 
QUERY:

SELECT 'comment'
FROM 'phpmyadmin', 'pma_column_info'
WHERE db_name = 'dbname'
AND table_name = ''
AND column_name = '(db_comment)'

MySQL said:

#1100 - Table 'pma_column_info' was not locked with LOCK TABLES
-----------8<------------------

Thanks for your help so far.

Paul

On 20 Dec 2010 at 2:52, Kevin Cozens wrote:

> sciguy-Lmt0BfyYGMw at public.gmane.org wrote:
> > MySQL said: Documentation
> > #1046 - No database selected
> 
> The error tells the story. You told it to import a file with SQL statements 
> but haven't told it which database it is to operate on.
> 
> Click the home button in phpMyAdmin. Left click one of the databases listed 
> on the left side of the screen to select an existing database. If you want 
> to import the data in to a new database, enter a name in the entry field 
> below "Create new database", set the collation entry the way you want, then 
> hit the create button. The new database will be created and selected.
> 
> Once you have selected a database you can click the Import tab and import 
> the file containing the dump of your database.
> --
> The Toronto Linux Users Group.      Meetings: http://gtalug.org/
> TLUG requests: Linux topics, No HTML, wrap text below 80 columns
> How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists
> 
> __________ NOD32 5720 (20101221) Information __________
> 
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
> 
> 


--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists