2,187
edits
Difference between revisions of "Maintenance (MySQL)"
Jump to navigation
Jump to search
m
→SHOW etc: innodb
(→Export / Backup: Added Create a Copy of a Table) |
m (→SHOW etc: innodb) |
||
| Line 3: | Line 3: | ||
<source lang="mysql"> | <source lang="mysql"> | ||
SHOW STATUS; # Shows general info | SHOW STATUS; # Shows general info | ||
SHOW ENGINE INNODB STATUS \G # Show InnoDB database status | |||
SHOW DATABASES; # Show databases | SHOW DATABASES; # Show databases | ||
SHOW TABLES; # Show tables in the current database | SHOW TABLES; # Show tables in the current database | ||