mysql oddity

2006-02-14 Thread Dan Stromberg
Hi folks. I've been compiling my own apps for over a decade, but it seems like it's time to get -with- the times, and start using precompiled binaries more. So I got a set of matching set of precomiled apache2/mysql5/php5 off of ibiblio for a Solaris 9/Sparc box. However, even though I have apa

Pulling a database schema out of a unknown MySQL database?

2005-02-02 Thread Dan Stromberg
I have a system with set of web pages that use PHP and a MySQL database. Apparently the old webmaster has disappeared, and a new webmaster has been hired. She needs to know the schema of the database. So my question is: Is there a way of querying MySQL not for values of fields, but rather for t

Not putting logs in /var/log?

2004-11-04 Thread Dan Stromberg
Is there a configure option to tell mysql not to put logs in /var/log? I don't want to run mysql as root if I can avoid it, and my /var/log directory requires root access. I tried using --localstatedir=$HOME/mysql-state, but that didn't help. I determined that mysql wouldn't start up correctly