MySQLでよくやることのソースを表示

== dump/restore ==
=== dump ===
<syntaxhighlight lang="bash">
$ mysqldump --single-transaction -u <USER_NAME> -p <DATABASE_NAME> > <FILE_NAME>
</syntaxhighlight>
=== restore ===
<syntaxhighlight lang="bash">
$ mysql -u <USER_NAME> -p <DATABASE_NAME> < <FILE_NAME>
</syntaxhighlight>



== user ==
=== 一覧 ===
<syntaxhighlight lang="sql">
# SELECT Host,User FROM mysql.user;
</syntaxhighlight>
=== 作成 ===
<syntaxhighlight lang="sql">
CREATE USER <USER_NAME> IDENTIFIED BY [PASSWORD] '<PASSWORD>';
</syntaxhighlight>
=== 名前変更 ===
<syntaxhighlight lang="sql">
# RENAME USER <OLD_USER_NAME> TO <NEW_USER_NAME>;
</syntaxhighlight>
=== 削除 ===
<syntaxhighlight lang="sql">
# DROP USER <USER_NAME>;
</syntaxhighlight>



== database ==
=== 一覧 ===
<syntaxhighlight lang="sql">
# SHOW DATABASES;
</syntaxhighlight>
=== 切り替え ===
<syntaxhighlight lang="sql">
# USE <DABASE_NAME>;
</syntaxhighlight>
=== 作成 ===
<syntaxhighlight lang="sql">
# CREATE DATABASE <DABASE_NAME>;
</syntaxhighlight>
=== 削除 ===
<syntaxhighlight lang="sql">
# DROP DATABASE <DATABASE_NAME>;
</syntaxhighlight>


[[Category:MySQL]]
[[Category:Database]]
[[Category:よくやること]]