如何在phpMyAdmin中修复WordPress MySQL表? [英] How do I fix WordPress MySQL tables in phpMyAdmin?

问题描述

背景故事:

我在Mac上使用MAMP设置了本地开发服务器和数据库来创建WordPress网站.一切进展顺利.昨天，MySQL服务器没有启动，因此我在StackOverflow上回答了一个建议，从mysql56文件夹中删除了ib_logfile0，ib_logfile1和ibdata1文件.这开始了一系列事件，最终破坏了我在phpMyAdmin上的表.

I used MAMP on Mac to set up a local dev server and database for creating a WordPress site. All was going well. Yesterday, the MySQL server did not start up, so I took the advice of an answer on StackOverflow to remove the ib_logfile0, ib_logfile1, and ibdata1 files from the mysql56 folder. This started a chain of events that ended up corrupting my tables on phpMyAdmin.

我保留了ib_和数据库文件，并在重新安装MAMP之后将它们放置在MAMP/db/mysql中，但是现在phpMyAdmin中的表存在错误(请参阅附件).所有表都具有相同类型的错误，并列为0字节.我尝试删除表，建立新数据库，下载MAMP的新副本等.如何修复这些表以便导出MySQL?

I kept the ib_ and database files, and after reinstalling MAMP, have placed them in MAMP/db/mysql, but now have errors with my tables in phpMyAdmin (see attachment). All of the tables have the same type of errors and are listed as 0 bytes. I've tried dropping the table, setting up a new database, downloading fresh copies of MAMP, etc. How can I fix these tables so I can export MySQL?

phpMyAdmin错误:

phpMyAdmin Errors:

回溯:警告 ./libraries/controllers/table/TableStructureController.php#1‌339 非法字符串偏移量'Data_length'回溯 ./libraries/controllers/table/TableStructureController.php#1‌258: PMA \ libraries \ controllers \ table \ TableStructureController-> get tTableStats() ./libraries/controllers/table/TableStructureController.php#3‌54: PMA \ libraries \ controllers \ table \ TableStructureController-> di‌splayStructure( 数组，数组，数组，布尔值false，数组，数组，) ./tbl_structure.php#49: PMA \ libraries \ controllers \ table \ TableStructureController-> index‐Action()'

Backtrace: 'Warning in ./libraries/controllers/table/TableStructureController.php#1‌​339 Illegal string offset 'Data_length' Backtrace ./libraries/controllers/table/TableStructureController.php#1‌​258: PMA\libraries\controllers\table\TableStructureController->ge‌​tTableStats() ./libraries/controllers/table/TableStructureController.php#3‌​54: PMA\libraries\controllers\table\TableStructureController->di‌​splayStructure( array, array, array, boolean false, array, array, ) ./tbl_structure.php#49: PMA\libraries\controllers\table\TableStructureController->in‌​dexAction()'

推荐答案

在大写中定义表和/或列时，这似乎是一个问题.我也遇到了类似的问题，并在GitHub上检查了未解决的问题，并获得了以下链接.

This seems to be an issue where the table and/or column is defined in UPPERCASE. I also faced a similar issue and checked open issues on GitHub and got the following link.

https://github.com/phpmyadmin/phpmyadmin/issues/13178

我建议在创建表或编辑表的结构后，回到phpmyadmin主页，再次进入同一表.您不会看到该错误.这是我的个人解决方法.

I suggest that after the creation of your table or editing the structure of the table, go back to phpmyadmin home and come again to the same table. You won't see that error. This is my personal workaround.

这篇关于如何在phpMyAdmin中修复WordPress MySQL表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！