MySQL 使用筆記

標籤：style   color   使用   strong   ar   art   div   line   

1. How to export the database of mysql

• go to command line,  use "CMD"
• cd C:\Program Files\MySQL\MySQL Server 5.5\bin
• mysqldump -hx.x.x.x(IP) -P3306 -uroot -pxxx DB_NLS > d:/db_nls.sql
• finish the export, sql file is db_nls.sql

2. How to import the database of mysql

• go to command line,  use "CMD"
• cd C:\Program Files\MySQL\MySQL Server 5.5\bin
• mysql -hx.x.x.x(IP) -uroot -pxxx

• create a database "test" by mysql workbench
• mysql> use test
• mysql> source d:/db_nls.sql
• finish the import.

     or

 

•    mysql -hx.x.x.x(IP) -uroot -pxxx -P3306 db_nls < d:\db_nls.sql

 

3. How to convert ACCESS database to MySQL

• use the tool: Access2MySQL

1. Difference between MySQL and Access

• 儲存逸出字元不同。MySQL 需轉化字串 ，“ \\ ”to " \\\\ ", " ‘ " to " ‘‘ ", 而Access 只需轉化 " ‘ "“ ‘‘ ”.

  4. How to set Mysql support multiple language

• Modify the my.ini which is located in mysql installed folder 
• Set "default-character-set =utf8", "character-set-server=utf8" 
• restart mysql service

5. How to change the password of  user: root in mysql

• go to command line,  use "CMD"

• cd C:\Program Files\MySQL\MySQL Server 5.5\bin
• mysqladmin -uroot -padmin password xxx