Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    Mar 2009
    Posts
    3

    Default phpmyadmin don't show tables for one database

    Hello,

    A customer create a database in CPanel, and ask to me help him to restore a backup for that DB.
    I restore the backup using this command:
    mysql user_database < backup.sql

    Using mysql, I can manipulate all the tables and register, the same using the web aplication.

    The problem is when I try to use phpmyadmin to manipulate that database, phpmyadmin don't show any table, I create a new table to see if is listed, but nothing; also when I try to download a backup of that database (using CPanel Backups tool), the backup it's empty.

    All the rest of databases are working fine with phpmyadmin.
    Any have an idea about this issue?

  2. #2
    Member
    Join Date
    Nov 2011
    Posts
    302
    cPanel/Enkompass Access Level

    Root Administrator

    Default Re: phpmyadmin don't show tables for one database

    Please try to repair database with the command mysqlcheck -r databasename and check if that fix the problem.
    If not then try to restore it again with same of different backup (if you have multiple backups).

  3. #3
    Registered User
    Join Date
    Mar 2009
    Posts
    3

    Default Re: phpmyadmin don't show tables for one database

    Hello,

    Thank you for the answer, but not working that solution for me.

    The solution that I found.
    I'll check the backup, and it have a predefined user, I create that user in the mysql database, and the phpmyadmin show me the tables for that database.

Similar Threads & Tags
Similar threads

  1. phpmyadmin not show add database
    By ramindia in forum Database Discussions
    Replies: 1
    Last Post: 07-21-2011, 04:05 AM
  2. Remote mysql. Old database don't show
    By pajeknet in forum Database Discussions
    Replies: 0
    Last Post: 10-11-2010, 02:36 PM
  3. phpMyAdmin: No tables found in database
    By Acieke in forum cPanel and WHM Discussions
    Replies: 6
    Last Post: 07-13-2006, 05:31 PM
  4. phpmyadmin tables
    By xynta in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 06-08-2006, 09:26 AM
  5. cant create tables in phpmyadmin
    By eger in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 06-01-2003, 01:38 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube