Using the Database Administration Module

To see an overview of the tables in your database, select administer > database. For each table, you are shown the number of rows and have the following options:

• The View option shows the contents of the table.

• The Describe option shows the data structure of the table, as shown in Figure 4-19.

Describe table 'node' tables run script view describe check backup empty drop

DESCRIBE nods;

Field Type Null Key Default Extra

Describe table 'node' tables run script view describe check backup empty drop

DESCRIBE nods;

Field Type Null Key Default Extra

nid

int(lO) unsigned

PRI

auto_increment

type

varchar(ie)

MUL

title

varchar(128)

MUL

uid

int(10)

MUL

status

int(4)

MUL

1

created

int(ll)

MUL

changed

int(ll)

MUL

comment

int(2)

promote

int(2)

MUL

moderate

int(2)

MUL

teaser

longtext

body

longtext

revisions

longtext

sticky

int(2)

format

int(4)

Figure 4-19. The node table described

Figure 4-19. The node table described

• The Check option checks the table (and its indexes) for errors and integrity.

• The Repair option attempts to fix errors found with check. See the MySQL documentation (http://dev.mysql.com/doc/mysql/en/repair-table.html) for details.

• The Backup option saves one or more tables in the form of a SQL dump to a file that you specify.

• The Empty option deletes all data from the table.

• The Drop option removes the table from the database.

0 0

Post a comment