- 12.1 Data Definition Statements
- 12.1.1 ALTER DATABASE Syntax
- 12.1.2 ALTER EVENT Syntax
- 12.1.3 ALTER LOGFILE GROUP Syntax
- 12.1.4 ALTER FUNCTION Syntax
- 12.1.5 ALTER PROCEDURE Syntax
- 12.1.6 ALTER SERVER Syntax
- 12.1.7 ALTER TABLE Syntax
- 12.1.8 ALTER TABLESPACE Syntax
- 12.1.9 ALTER VIEW Syntax
- 12.1.10 CREATE DATABASE Syntax
- 12.1.11 CREATE EVENT Syntax
- 12.1.12 CREATE FUNCTION Syntax
- 12.1.13 CREATE INDEX Syntax
- 12.1.14 CREATE LOGFILE GROUP Syntax
- 12.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 12.1.16 CREATE SERVER Syntax
- 12.1.17 CREATE TABLE Syntax
- 12.1.18 CREATE TABLESPACE Syntax
- 12.1.19 CREATE TRIGGER Syntax
- 12.1.20 CREATE VIEW Syntax
- 12.1.21 DROP DATABASE Syntax
- 12.1.22 DROP EVENT Syntax
- 12.1.23 DROP FUNCTION Syntax
- 12.1.24 DROP INDEX Syntax
- 12.1.25 DROP LOGFILE GROUP Syntax
- 12.1.26 DROP PROCEDURE and DROP FUNCTION Syntax
- 12.1.27 DROP SERVER Syntax
- 12.1.28 DROP TABLE Syntax
- 12.1.29 DROP TABLESPACE Syntax
- 12.1.30 DROP TRIGGER Syntax
- 12.1.31 DROP VIEW Syntax
- 12.1.32 RENAME DATABASE Syntax
- 12.1.33 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.14, “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. In
MySQL 5.1, the only permitted values for
engine_name are
NDB and
NDBCLUSTER.
DROP LOGFILE GROUP was added in MySQL 5.1.6. In
MySQL 5.1, it is useful only with Disk Data storage for MySQL
Cluster. See MySQL Cluster Disk Data Tables.
User Comments
Add your own comment.