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
Solved

phpMyAdmin only showing first table in database

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
Developers of all skill levels should learn to use current best practices when developing websites. However many developers, new and old, fall into the trap of using deprecated features because this is what so many tutorials and books tell them to u…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

861 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