Re: questions about merging

2009-02-01 Thread Steve Holmes
Robert, I know you have had other answers, but as to the database name, yes, you can remove the CREATE DATABASE statement and change the USE statement to the right database name. N.B. In our environment the students have only one database each, and will install blogs and wiki's etc. using that one

Re: frequent issues restoring mysqldump file

2009-01-14 Thread Steve Holmes
Andy, I just had an interesting experience you might also find interesting. I rarely have to do restores, also (MySQL is very solid), but I just upgraded my (only) MySQL server. At the same time I upgraded the MySQL release from 5.0.45 to 5.0.67. While testing my procedure (which was a piece of ca

Re: Inno Setup script for MySQL and MySQL ODBC?

2008-12-19 Thread Steve Holmes
2008/12/19 Menachem Bazian > Does anyone have an inno setup script so I can automatically install MySQL > with an application? > > > I don't know about anyone else, but I don't know what you mean by "inno setup script". Please be more spec

Re: Consolidation suggestions - some LAMP servers

2008-12-09 Thread Steve Holmes
Götz We've been doing this for some time. Of course we have GigE internally so the network is not a problem. The biggest problem for us is making sure the students know to configure software they want to use for their web sites to use the MySQL server name rather than the default which is usually '

error log file permissions

2008-09-09 Thread Steve Holmes
Background: Solaris 10, MySQL 5.0.45. I have changed something recently that is causing the error log file to be created with mode 660. I would like for it it be mode 664. I admit that I recently changed the my.cnf file and added a log-error line which did not have the fully qualified path and cau