个人工具
登录
查看“UbuntuHelp:MyISAMUnderUbuntu”的源代码 - Ubuntu中文
UbuntuHelp
讨论
查看源代码
历史
搜索
导航
首页
最近更改
随机页面
页面分类
帮助
编辑
编辑指南
沙盒
新闻动态
字词处理
工具
链入页面
相关更改
特殊页面
页面信息
查看“UbuntuHelp:MyISAMUnderUbuntu”的源代码
来自Ubuntu中文
←
UbuntuHelp:MyISAMUnderUbuntu
跳转至:
导航
,
搜索
因为以下原因,你没有权限编辑本页:
您所请求的操作仅限于该用户组的用户使用:
用户
您可以查看与复制此页面的源代码。
{{From|https://help.ubuntu.com/community/MyISAMUnderUbuntu}} {{Languages|UbuntuHelp:MyISAMUnderUbuntu}} 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! <pre><nowiki> 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! #. </nowiki></pre> Other keywords: MySQLMyISAMDialect [[category:CategoryDocumentation]] [[category:CategoryCleanup]] [[category:UbuntuHelp]]
该页面使用的模板:
模板:From
(
查看源代码
)
模板:Languages
(
查看源代码
)(受保护)
模板:Languages/Lang
(
查看源代码
)(受保护)
返回至
UbuntuHelp:MyISAMUnderUbuntu
。