我可以从wordpress数据库中删除现有的数据库表吗?
问题:当我打开website.com/wp-admin
时。此错误消息显示
One or more database tables are unavailable. The database may need to be repaired.
当我打开我的网站时,会显示此错误消息。
Error establishing a database connection
我的用户名、密码和主机名都是正确的。
问题:如何删除现有表并安装新的wordpress。
注意我无法访问托管服务器。我只有wordpress管理员访问权限。并具有数据库用户名和密码。
如果我点击修复。
出现这些线条。这是11张表,但wordpress有13张表。
The wp_users table is okay.
The wp_usermeta table is okay.
The wp_posts table is okay.
The wp_comments table is okay.
The wp_links table is okay.
The wp_options table is okay.
The wp_postmeta table is okay.
The wp_terms table is okay.
The wp_term_taxonomy table is okay.
The wp_term_relationships table is okay.
The wp_commentmeta table is okay.
Repairs complete. Please remove the following line from wp-config.php to prevent this page from being used by unauthorized users.
define('WP_ALLOW_REPAIR', true);
是的,您可以通过使用这个插件SQL执行器来实现这一点。
激活插件后,只需转到管理面板中的"工具"菜单,在那里你可以找到,运行你想要的查询!
I think you are not required to delete the tables, all you need is to repair your existing tables.
For that please go to your server database:
1>>Check all the tables, and choose the "repair table" option from the drop down list.
2>> Hit the go button, that's it!!
Hope that will help
您不能从wordpress管理面板访问数据库。