General comments:

This pages provides a general introduction to the shared Li lab database. Li lab members should address any further questions or requests for privileges on the database to Geoff, the current database adminstrator.

It is a MySQL database, so you should familiarize yourself with www.mysql.com where you can read the users manual, download MySQL clients, or download the MySQL server program to install on your desktop. There are many copies of Paul DuBois' standard text MySQL floating around the lab including a Li lab copy.

If you access the database and find you can't do something there is usually a good reason for it. To protect peoples I will grant privileges other than SELECT (i.e. read privileges) only if they are needed.

Features of the databases:

There are two types of databases: personal databases and shared databases. The personal databases are generally for rough work or individual. The shared databases (currently only the yeast database has tables) are meant to be well-currated sources of information for all Li lab members.

To get information about tables in the personal databases you'll have to ask the individual who owns that database. For the shared database, the information you need about who created the tables, with data from what sources, how they modified the data from the original etc. should all be in the "table log" table in the "mysql" database. If you can't find information about a table in a shared database please let me know, because it sould be there.

Thanks, Geoff