I've just inherited a mySQL server. It has 13 databases, 5-50 tables per database. The largest table may have 10,000 records, but most tables are much smaller.
What began as a test database server for a web developer in one department, has now become a tangled web of production databases, test databases, and abandoned databases for multiple departments. Of course, the only documentation I have is a Post-It note with the root password on it. The first thing I did was a complete backup of all databases. The second thing I did was change the root password. My next step is to try and document what is on the server. I am thinking I should document each database on the server, the purpose of the database, the department it belongs to, and a primary contact name, and a backup schedule for the database. Next, I think I should document all the user accounts and what permissions they have on the databases. Does this sound reasonable? Any advice? __________________________________ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]