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
- 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