In process of use of databases in them excess information - tables, records, indexes, etc. is accumulated. Sometimes this unnecessary cargo gives to deceleration of work or errors in the appendices using them. For manual cleaning of databases of MySQL DBMS which is widely used in web construction the phpMyAdmin application best of all is the most suitable.
It is required to you
- Access to phpMyAdmin
Instruction
1. After authorization in phpMyAdmin select the necessary database in the left frame.
2. If it is necessary to clean base from all tables together with the data which are contained in them, then click the reference "Note Everything" placed under the table, and then select in a drop-down list with the inscription "With Noted" the line "Delete". The application will demand confirmation of execution of request of DROP TABLE - click "Yes". After that the plate with results of implementation of the SQL query on removal of all tables will be loaded into the right frame.
3. If it is necessary to delete only the data which are contained in tables, then, as well as in the previous step, it is necessary to click the link "Note Everything", but in a drop-down list to select the line "Clean". Certainly, and for removal operation, and for cleaning, it is not obligatory to select all tables at all. You can give marks only for those tables which interest you.
4. In the course of active work with the database when many write operations and removals are carried out, in tables there is "garbage" - parts of the lines which are not used more, indexes, etc. The option "Optimize the Table" is intended for unloading of tables from all superfluous. To use, you should click again "Note everything" and select this line in a drop-down list.
5. If SQL queries cause errors, then, perhaps, there were some damages of the data on structure and indexing of tables of base stored by the SQL server. In this case, having clicked the link "Note Everything", you should select the Restore the Table item in a drop-down list.