Skip to content

Instantly share code, notes, and snippets.

@pengmaradi

pengmaradi/mysql-create-database-utf-8.md

Last active April 23, 2016 18:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pengmaradi/2b942397fc3e11c1e3e7 to your computer and use it in GitHub Desktop.
Save pengmaradi/2b942397fc3e11c1e3e7 to your computer and use it in GitHub Desktop.
Download ZIP
the sql commend
Raw
mysql-create-database-utf-8.md

mysql

mysql create database with utf-8

mysql> CREATE DATABASE `mydb` CHARACTER SET utf8 COLLATE utf8_general_ci;

mysql dump and import

mysqldump -u user -pPWD dbname | gzip > mybackup.sql.gz
mysqldump -u user -pPWD dbname > mybackup.sql
mysql -u user -pPWD importdbname < mybackup.sql
@pengmaradi
Copy link
Author

UPDATE be_users SETdisable = '0'WHERE tstamp = '1441175451' AND disable = 1 AND deleted = 0;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment