Last active
February 11, 2016 23:23
-
-
Save megane9988/2aab28d888459939285a to your computer and use it in GitHub Desktop.
mysqlのユーザ追加と、インポート
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# ユーザ作成 | |
grant all privileges on [データベース名].* to [ユーザ名]@localhost identified by '[パスワード]'; | |
# ダンプ | |
mysqldump -u root -p database_name > dump.sql | |
# インポート | |
mysql -u [ユーザ名] --default-character-set=utf8 -p [データベース名] < インポートするファイル名 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment