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.