371: ページの作成:「== dump/restore == === dump === $ mysqldump --single-transaction -u -p > === rest...」

2018-08-27T07:14:11Z

ページの作成:「== dump/restore == === dump === <syntaxhighlight lang="bash"> $ mysqldump --single-transaction -u <USER_NAME> -p <DATABASE_NAME> > <FILE_NAME> </syntaxhighlight> === rest...」

新規ページ

== 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:よくやること]]

MySQLでよくやること - 版の履歴

371: ページの作成:「== dump/restore == === dump === $ mysqldump --single-transaction -u -p > === rest...」