CODEWITHSUNDEEP
mysqlinformation-schema
ActionOwl
ActionOwl

Reputation: 1473

Generate INFORMATION_SCHEMA table for MySQL database

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?

thanks

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

Upvotes: 2

Views: 6405

Answers (2)

Ike Walker
Ike Walker

Reputation: 65547

Sorry, you are out of luck. INFORMATION_SCHEMA was not added until MySQL 5.0.

Upvotes: 0

Michael Mior
Michael Mior

Reputation: 28752

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 :)

Upvotes: 4

Related Questions