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.