Before sleep

Dabao and beibei are watching Tom and jerry.

MySQL UDF Execution - strong password

For mysql 5.5.8 or earlier on Windows, there is such danger about "User-defined-functions" execution.

So help, there is a need to 

1. Ensure the password is strong

2. Delete the "root" account for hostname "%" (i.e. others cannot use "root" account at other host)

A good habit:

1. Create new user privilege only on specific database it belongs to.

2. Have a strong password for the user account

What is a strong password:

Hint:

• It needs to contain special characters such as @#$%^&
• It must be at least 8 characters long.
• It must not have any common words such as 123, password, your birth date, your login name and any words that can be found in the dictionary.
• a variation of capitalization and small letters

Todo:

1. A password manager is needed to remember for you.

Dublin Core

The Dublin Core set of metadata elements provides a small and fundamental group of text elements through which most resources can be described and cataloged.

简单的都柏林核心原数据集（DCMES） 包括15种元数据元素：

1. 标题（Title）
2. 创建者（Creator）
3. 主题（Subject）
4. 描述（Description）
5. 发行者（Publisher）
6. 资助者（Contributor）
7. 日期（Date）
8. 类型（Type）
9. 格式（Format）
10. 标识符（Identifier）
11. 来源（Source）
12. 语言（Language）
13. 关系（Relation）
14. 范围（Coverage）
15. 权限（Rights）

每一个都柏林核心元素都是可选合可以重复的。

 Now studying how greenstone or Dspace to make an online archive for qipao project.

Wordpress problem

For Worldpress web, need to enable

LoadModule rewrite_module modules/mod_rewrite.so

in httpd.conf

otherwise, the webpage can't show correctly.

http://155.69.146.102/category/networking/research-collaborator

Need to use the model to write to a pseudo html file

Backup innoDB database of mysql

Two main types of databases in mysql: MyISAM and InnoDB.

mysql/data contains all the databases. Each database is shown as a folder.

For MyISAM, just copy the data folder under mysql.
For InnoDB, can't just copy the frm files under data folder. There is a need to copy the "ibdata1" which contains the table info.

Best practice: use the backup function to export the database to mysql, then import.