特殊:Badtitle/NS100:MyISAMUnderUbuntu
文章出处: |
{{#if: | {{{2}}} | https://help.ubuntu.com/community/MyISAMUnderUbuntu }} |
点击翻译: |
English {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/af | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|Afrikaans| [[::MyISAMUnderUbuntu/af|Afrikaans]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/ar | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|العربية| [[::MyISAMUnderUbuntu/ar|العربية]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/az | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|azərbaycanca| [[::MyISAMUnderUbuntu/az|azərbaycanca]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/bcc | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|جهلسری بلوچی| [[::MyISAMUnderUbuntu/bcc|جهلسری بلوچی]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/bg | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|български| [[::MyISAMUnderUbuntu/bg|български]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/br | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|brezhoneg| [[::MyISAMUnderUbuntu/br|brezhoneg]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/ca | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|català| [[::MyISAMUnderUbuntu/ca|català]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/cs | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|čeština| [[::MyISAMUnderUbuntu/cs|čeština]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/de | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|Deutsch| [[::MyISAMUnderUbuntu/de|Deutsch]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/el | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|Ελληνικά| [[::MyISAMUnderUbuntu/el|Ελληνικά]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/es | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|español| [[::MyISAMUnderUbuntu/es|español]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/fa | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|فارسی| [[::MyISAMUnderUbuntu/fa|فارسی]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/fi | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|suomi| [[::MyISAMUnderUbuntu/fi|suomi]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/fr | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|français| [[::MyISAMUnderUbuntu/fr|français]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/gu | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|ગુજરાતી| [[::MyISAMUnderUbuntu/gu|ગુજરાતી]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/he | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|עברית| [[::MyISAMUnderUbuntu/he|עברית]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/hu | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|magyar| [[::MyISAMUnderUbuntu/hu|magyar]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/id | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|Bahasa Indonesia| [[::MyISAMUnderUbuntu/id|Bahasa Indonesia]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/it | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|italiano| [[::MyISAMUnderUbuntu/it|italiano]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/ja | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|日本語| [[::MyISAMUnderUbuntu/ja|日本語]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/ko | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|한국어| [[::MyISAMUnderUbuntu/ko|한국어]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/ksh | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|Ripoarisch| [[::MyISAMUnderUbuntu/ksh|Ripoarisch]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/mr | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|मराठी| [[::MyISAMUnderUbuntu/mr|मराठी]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/ms | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|Bahasa Melayu| [[::MyISAMUnderUbuntu/ms|Bahasa Melayu]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/nl | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|Nederlands| [[::MyISAMUnderUbuntu/nl|Nederlands]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/no | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|norsk| [[::MyISAMUnderUbuntu/no|norsk]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/oc | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|occitan| [[::MyISAMUnderUbuntu/oc|occitan]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/pl | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|polski| [[::MyISAMUnderUbuntu/pl|polski]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/pt | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|português| [[::MyISAMUnderUbuntu/pt|português]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/ro | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|română| [[::MyISAMUnderUbuntu/ro|română]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/ru | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|русский| [[::MyISAMUnderUbuntu/ru|русский]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/si | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|සිංහල| [[::MyISAMUnderUbuntu/si|සිංහල]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/sq | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|shqip| [[::MyISAMUnderUbuntu/sq|shqip]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/sr | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|српски / srpski| [[::MyISAMUnderUbuntu/sr|српски / srpski]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/sv | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|svenska| [[::MyISAMUnderUbuntu/sv|svenska]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/th | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|ไทย| [[::MyISAMUnderUbuntu/th|ไทย]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/tr | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|Türkçe| [[::MyISAMUnderUbuntu/tr|Türkçe]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/vi | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|Tiếng Việt| [[::MyISAMUnderUbuntu/vi|Tiếng Việt]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/yue | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|粵語| [[::MyISAMUnderUbuntu/yue|粵語]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/zh | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|中文| [[::MyISAMUnderUbuntu/zh|中文]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/zh-hans | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|中文(简体)| [[::MyISAMUnderUbuntu/zh-hans|中文(简体)]]}}|}} {{#ifexist: {{#if: UbuntuHelp:MyISAMUnderUbuntu | UbuntuHelp:MyISAMUnderUbuntu | {{#if: | :}}MyISAMUnderUbuntu}}/zh-hant | • {{#if: UbuntuHelp:MyISAMUnderUbuntu|中文(繁體)| [[::MyISAMUnderUbuntu/zh-hant|中文(繁體)]]}}|}} |
{{#ifeq:UbuntuHelp:MyISAMUnderUbuntu|:MyISAMUnderUbuntu|请不要直接编辑翻译本页,本页将定期与来源同步。}} |
{{#ifexist: :MyISAMUnderUbuntu/zh | | {{#ifexist: MyISAMUnderUbuntu/zh | | {{#ifeq: {{#titleparts:MyISAMUnderUbuntu|1|-1|}} | zh | | }} }} }} {{#ifeq: {{#titleparts:MyISAMUnderUbuntu|1|-1|}} | zh | | }}
You must remove skip-innodb from /etc/mysql/my.cnf otherwise the MySQL that currently ships with Hoary will silently downgrade your MyISAM tables to MyISAM. Very confusing!
david@bunta:~ $ mysql --host=***** --user=***** --password=***** test2 Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 765 to server version: 4.0.23_Debian-3ubuntu2-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> drop database test2; Query OK, 0 rows affected (0.02 sec) mysql> create database test2; Query OK, 1 row affected (0.00 sec) mysql> CREATE TABLE AccountLink ( -> active int(10) unsigned NOT NULL default '0', -> inactive int(10) unsigned NOT NULL default '0', -> UNIQUE KEY inactive (inactive) -> ) TYPE=MyISAM; Query OK, 0 rows affected (0.02 sec) mysql> mysql> Bye david@bunta:~ $ mysqldump -a -c --host=***** --user=***** --password=***** test2 -- MySQL dump 9.11 -- -- Host: ***** Database: test2 -- ------------------------------------------------------ -- Server version 4.0.23_Debian-3ubuntu2-log -- -- Table structure for table `AccountLink` -- CREATE TABLE `AccountLink` ( `active` int(10) unsigned NOT NULL default '0', `inactive` int(10) unsigned NOT NULL default '0', UNIQUE KEY `inactive` (`inactive`) ) TYPE=MyISAM; # # okay it's come out as MyISAM ... I'll fix it! # david@bunta:~/root/common $ mysql --host=***** --user=***** --password=***** test2 Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 769 to server version: 4.0.23_Debian-3ubuntu2-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> ALTER TABLE AccountLink Type = MyISAM; Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> Bye david@bunta:~/root/common $ mysqldump --host=***** --user=***** --password=***** test2 -- MySQL dump 9.11 -- -- Host: ***** Database: test2 -- ------------------------------------------------------ -- Server version 4.0.23_Debian-3ubuntu2-log -- -- Table structure for table `AccountLink` -- CREATE TABLE `AccountLink` ( `active` int(10) unsigned NOT NULL default '0', `inactive` int(10) unsigned NOT NULL default '0', UNIQUE KEY `inactive` (`inactive`) ) TYPE=MyISAM; -- -- Dumping data for table `AccountLink` -- david@bunta:~/root/common $ # # Nooo... it's still MyISAM! #.
Other keywords: MySQLMyISAMDialect