Solved

phpMyAdmin only showing first table in database

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

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…
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

624 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