导入的表未显示在phpmyadmin中 [英] Imported tables are not showing up in phpmyadmin

问题描述

我导出了生产数据库，并创建了一个名为test的开发数据库.我使用ssh将表/数据导入到开发数据库中.

I exported our production database and created a development database called test. Using ssh I imported the tables/data into the development database.

mysql -u root -p -h localhost test < data.sql

我可以查看数据库结构，并在使用命令行mysql时按预期返回行.但是，当我打开phpmyadmin时，测试"数据库在那里，但没有表，我无法选择任何数据.

I can view the database structure and it returns rows as expected when I use the command line mysql. However, when I open up phpmyadmin, the "test" database is there but it has no tables and I can't select any of the data.

关于如何解决此问题的任何想法?

Any idea on how to fix this?

推荐答案

我不知道如何，但是我的同事已解决此问题.不管怎么说，还是要谢谢你.原来他改变了数据库的位置...

I don't know how but this has been fixed by my coworker. Thanks anyway. Turns out he changed where the database was...

这篇关于导入的表未显示在phpmyadmin中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！