- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
Additional languages
MySQL 6.0 Reference Manual :: 12 SQL Statement Syntax :: 12.1 Data Definition Statements :: 12.1.14 DROP LOGFILE GROUP Syntax
Section Navigation [Toggle]
- 12.1 Data Definition Statements
- 12.1.1 ALTER DATABASE Syntax
- 12.1.2 ALTER LOGFILE GROUP Syntax
- 12.1.3 ALTER SERVER Syntax
- 12.1.4 ALTER TABLE Syntax
- 12.1.5 ALTER TABLESPACE Syntax
- 12.1.6 CREATE DATABASE Syntax
- 12.1.7 CREATE INDEX Syntax
- 12.1.8 CREATE LOGFILE GROUP Syntax
- 12.1.9 CREATE SERVER Syntax
- 12.1.10 CREATE TABLE Syntax
- 12.1.11 CREATE TABLESPACE Syntax
- 12.1.12 DROP DATABASE Syntax
- 12.1.13 DROP INDEX Syntax
- 12.1.14 DROP LOGFILE GROUP Syntax
- 12.1.15 DROP SERVER Syntax
- 12.1.16 DROP TABLE Syntax
- 12.1.17 DROP TABLESPACE Syntax
- 12.1.18 RENAME TABLE Syntax
DROP LOGFILE GROUPlogfile_groupENGINE [=]engine_name
This statement drops the log file group named
logfile_group. The log file group must
already exist or an error results. (For information on creating
log file groups, see Section 12.1.8, “CREATE LOGFILE GROUP Syntax”.)
Important
Before dropping a log file group, you must drop all tablespaces
that use that log file group for UNDO
logging.
The required ENGINE clause provides the name of
the storage engine used by the log file group to be dropped. The
only permitted values for engine_name
are NDB and NDBCLUSTER.
DROP LOGFILE GROUP is useful only with Disk
Data storage for MySQL Cluster. See
MySQL Cluster Disk Data Tables.
© 1995-2008 MySQL AB. All rights reserved.
User Comments
Add your own comment.