miniu Posted April 23, 2010 Share Posted April 23, 2010 How can I create INFORMATION_SCHEMA tables in MySQL - 5.0.83 ? Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted April 23, 2010 Share Posted April 23, 2010 Why would you need to create them? From the quick reading I just did, there is an INFORMATION_SCHEMA database and it contains views only; there are no tables. Quote Link to comment Share on other sites More sharing options...
miniu Posted April 23, 2010 Author Share Posted April 23, 2010 Because I moved to a different server and in my previous I had INFORMATION_SCHEMA and was wondering if in order to copy the database info I should also create the INFORMATION_SCHEMA tables that I hade on the previous server Quote Link to comment Share on other sites More sharing options...
Mchl Posted April 23, 2010 Share Posted April 23, 2010 No. You don't need that. As stated above, information_schema contains read_only views that provide easy way to access information about database objects. You can't insert any data into it. It is possible, that on your new server you simply have no access privileges to information_schema. Quote Link to comment Share on other sites More sharing options...
miniu Posted April 23, 2010 Author Share Posted April 23, 2010 ok, thank you Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.