I am interested in a free and simple MySQL tool which can offer online collaboration functionality in creating database general schema. Do you know any?
You can use Vertabelo. Vertabelo is an online database designer working under Chrome and Safari developed by company I work for.
Vertabelo focuses on online collaboration in the visual database schema creation area. The most important feature of this tool is that it allow to share database models across the team and collaborate on them via web browser. It also allow to have public model link with possibility of embeding diagrams in your webpage/blog/wiki.
Others Vertabelo features include:
- Support for PosgreSql, MySQL, Oracle, MS SQL Server, DB2, SQLite, HSQLDB
- Dynamic/Visual search
- Live database model validation
- Model versioning
- Forward engineering
- Reverse engineering
Vertabelo is free to use for academic projects and have commercial versions for larger database projects.
You could use subversion(SVN) as a way to work cooperatively on the structure of the database. It is also very useful when trying to figure out who changed what and when. It also gives you the ability to rollback changes to your code if a modification didn't work or caused problems.
I have often used SVN as a way to manage the code for databases, stored procedures and permissions for both MySQL and SQL Servers. It also provides a way to lock a file, so that no one else can edit it while you have it open.
Subversion Server: http://subversion.tigris.org/
You can then install Tortoise which can integrate with Windows to give you point and click access to your code.
Tortoise SVN Client: http://tortoisesvn.tigris.org/
You do need to have an Apache 2.2 server installed,
Here is a tutorial I found on the web which looks fairly straightforward.
Other solutions exist like sourcesafe and CVS, just depends on what you feel comfortable with.
WWW SQL Designer