为 MySQL 数据库生成 INFORMATION_SCHEMA 表 [英] Generate INFORMATION_SCHEMA table for MySQL database

问题描述

我在旧服务器上使用旧版本的 MySQL (4.0)，由于某种原因它没有 INFORMATION_SCHEMA 数据库，不知道是不是这个版本的 MySQL 没有包含 INFORMATION_SCHEMA 或者是否有人删除了它.

I'm using an old version of MySQL (4.0) on an old server and for some reason it has no INFORMATION_SCHEMA database, I don't know if this version of MySQL did not include INFORMATION_SCHEMA or if someone deleted it.

有没有办法(重新)生成这个数据库?

Is there some way to (re)Generate this database?

谢谢

# mysql --version
mysql  Ver 12.22 Distrib 4.0.18, for suse-linux (x86_64)

推荐答案

INFORMATION_SCHEMA 数据库是在 MySQL 5.02 中添加的.无法创建或删除它.它由服务器直接管理.如果可能的话，与其试图找到一种方法来解决这个问题，不如将时间花在升级服务器上:)

The INFORMATION_SCHEMA database was added in MySQL 5.02. It's not possible to create or delete it. It's managed by the server directly. Instead of trying to find a way to work around this, your time would be much better spent upgrading the server if at all possible :)

这篇关于为 MySQL 数据库生成 INFORMATION_SCHEMA 表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！