Solved

phpMyAdmin only showing first table in database

Posted on 2009-04-10
4
389 Views
Last Modified: 2013-12-12
This one has me scratching my head.  I am creating a database with several tables.  All of the tables are there (I can see them using the GUI of MySQL) but phpMyAdmin only shows the first table (listed alphabetically).  Any idea what has caused this?  I've read as much of the phpMyAdmin documentation as I can understand, and have searched the web for this phenomenon, but so far, I'm not finding anything on this.  Any help would be greatly appreciated!  I've included a screen capture showing a database called SECURE, with two tables, but only showing one below the Database name in the left frame.

Thanks,
Picture-3.png
0
Comment
Question by:sully1958
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 9

Accepted Solution

by:
LinuxNubb earned 250 total points
ID: 24120204
Very odd.  Have you tried the latest version of phpmyadmin?  What are the other database and table names?
0
 

Author Comment

by:sully1958
ID: 24120390
The other table name in "SECURE" is "Member."  The other databases are NCR, CSR, information_schema and mysql.  I created Member, NCR and CSR.  information_schema and mysql already existed.  I can see all the tables in the information_schema and mysql tables, but only one in the databases I created.  My phpMyAdmin version is 2.11.9.5.
0
 
LVL 9

Expert Comment

by:LinuxNubb
ID: 24123187
Are you creating the tables/databases inside phpmyadmin? If not, what happens if you do?
0
 

Author Closing Comment

by:sully1958
ID: 31569100
Updating to the latest version solved my problem.  Thanks!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question