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
Friday, August 19, 2011
Monday, August 15, 2011
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.
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.
Subscribe to:
Comments (Atom)