Home > Support > WebCards Manual
WebCards Manual
SQL Manager
This is a useful tool to get information about the SQL database WebCards is running on. It also allows you to perform some basic operations on the database.
There are links to view SQL system and runtime information at the top of the page. This is useful for debugging.
Each table is listed along with the number of records it holds and the table size. The total table size is located to the bottom right of the page.
To perform basic maintenance actions on the table check the boxes next to the tables you wish to apply the action to. CLicking the checkbox at the top of the page will automatically check all the boxes. Choose the action you wish to perform and click "Perform Action."
In the above screenshot the "CHECK" operation has been applied to all the tables. It has given us information about the health of our database and any problems with it.
The "CHECK" operation will give you information about the health of your tables.
The "ANALYZE" operation will give you information about your tables.
The "OPTIMIZE" operation will attempt to reduce the space your database occupies.
The "REPAIR" operation will attempt to fix an errors in your database.