i am trying to to install a component and it says that a particular table of that component exists in mysql…i am done with (drop if table exists; flush tables; and create tables; both in phpmyadmin and ubuntu terminal command)
but failed to do so…when im trying to search where the component table exists it points to information_schema (which is hard to edit because the table is like an imaginary table) no command can be done.
anyone knows how to delete/edit/alter an existing table in information_schema (??)
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hi @mjbt,
INFORMATION_SCHEMA, PERFORMANCE_SCHEMA and mysql (and possibly more) are special system tables in MySQL. Please refer to the MySQL documentation on this - Documentation
In other words, no, don’t attempt to delete/alter them. You need them in order to have a functional MySQL installation. Moreover, they’re probably protected from any regular way of deleting/altering them.
If you are experiencing issues with the installation, I’ll recommend going to developer and see if the error can be fixed by them.
Regards, KDSys