2007年10月31日 星期三

phpMyAdmin

Installation of phpMyAdmin is quite simple. Just upload the entire directory to your host and then it works.
Some advanced features need more tuning. The advanced features include, {bookmark, history retreival, schema designer, PDF-generation, field contents transformation}. Designer allows graphical designs of schema. Later the graphical designs can be output as pdf files.

To activate those features, some remarks need to be unremarked. Check the line after pmadb directive. Whenever you see pma words, you need to unmark them.

If you have multiple databases, you should think of use a central control user and password to work on pmadb. Otherwise you only need to create tables in scripts/create_tables_xxx.sql into your database and keep pmadb commented.

Create tables in pmadb (multi-database mode) or in your database (single database mode). The features will be stored in those tables. You can find the history of your sql command. You can design the relation links in your database. It can be much fun to use them to coordinate your project.

沒有留言: