35.8. Deleting Tables and Databases

When a table is removed from a database, all records and fields that it contains will be lost. You can remove any table, although deleting those in the mysql database is a bad idea as they contain important MySQL access control information.

To remove one, follow these steps:

1.
On the module's main page, click on the icon for the database from which you want to remove the table, and then on the icon for the table itself.

2.
Click on the Drop Table button below the list of fields. This will take you to a confirmation page that asks if you are sure and tells you how many records will be deleted.

3.
To go ahead, click the Drop Table button again. Once it has been removed, you will return to the list of surviving tables in the database.

It is also possible to delete an entire database and all the tables and records in it. Any database can be removed, but deleting the mysql database is a very bad idea. As usual, unless you have made a backup there is no way to undo the deletion.

Assuming you really want to delete a database, follow these steps:

1.
On the main page, click on the icon for the database that you want to remove.

2.
Hit the Drop Database button below the list of tables. A confirmation page will be displayed, telling you how many tables and records will be lost if you go ahead.

3.
To continue with the deletion, click the Drop Database button and you will return to the module's main page when it is done.

4.
Alternately, you can choose to remove all the tables and their records by clicking on Just delete all tables instead. The database itself will be left empty.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
52.15.179.139