首页 > 代码库 > MySQL 使用笔记

MySQL 使用笔记

2024-07-18 12:20:11   231人阅读

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


联系
我们