MySQL: Difference between revisions
Jump to navigation
Jump to search
Anthoanthop (talk | contribs) No edit summary |
Anthoanthop (talk | contribs) No edit summary |
||
| Line 11: | Line 11: | ||
* Unlock replication (ex: Duplicate Key): | * Unlock replication (ex: Duplicate Key): | ||
<syntaxhighlight lang="sql">SET GLOBAL sql_slave_skip_counter = 1; | <syntaxhighlight lang="sql">STOP SLAVE; SET GLOBAL sql_slave_skip_counter = 1; START SLAVE;</syntaxhighlight> | ||
Revision as of 13:42, 16 April 2015
- List MySQL tables engines for a MYDB database:
SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'MYDB' AND ENGINE IS NOT NULL ORDER BY ENGINE;
- Change engine for a MYTABLE table:
ALTER TABLE MYTABLE ENGINE=InnoDB;
ALTER TABLE MYTABLE ENGINE=MyISAM;
- Unlock replication (ex: Duplicate Key):
STOP SLAVE; SET GLOBAL sql_slave_skip_counter = 1; START SLAVE;