Solved

phpMyAdmin only showing first table in database

Posted on 2009-04-10
4
374 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
  • 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to count occurrences of each item in an array.

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now