RE: Linux vs. Windows?

2005-08-12 Thread Patrick Fowler
Folks, Go with what you know best. If you are a good Windows admin etc go with windows. If you are a good Linux/Unix admin go with Linux. What little performance gain from one or the other will be lost if you do not run a tight ship all around. Performance and stability goes way beyond what

database dir change

2004-02-05 Thread Patrick Fowler
Folks, I want to change the database dir to a new dir. When I change the my.cnf and add [mysqld] datadir=\data Do I have to do anyting to the mysql and test databases? This is a fresh install rpm install. Patrick Fowler Unix Admin/database Admin Wynit, Inc. 6847 Ellicott Drive East

InnoDB

2004-01-22 Thread Patrick Fowler
Folks, Is InnoDB activated by default in MySQL V4 or V4max? Do I have to compile from source with the innoDB flag in order to use the innoDB tables or just in stall the RPM? Patrick

MS Exchange Email?

2002-10-01 Thread Patrick Fowler
. DBA / Unix Administrator Patrick Fowler Wynit, Inc. 6847 Ellicott Drive East Syracuse, NY 13057 V (315) 437-7617 x2172 F (315) 437-0432 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Output to a file?

2002-09-26 Thread Patrick Fowler
Hello, I'm new to MySQL. I've been able to query the database via PHP and display it within a html page. I would like to out put the results to a flat file tab delimited instead of onto a new page. Thanks for any help. DBA / Unix Administrator Patrick Fowler Wynit, Inc. 6847 Ellicott Drive

Remote ServerAccess

2002-09-23 Thread Patrick Fowler
Hello, I'm just starting out with MySQL. How do you set permission to allow for access from a domain or IP. I found this in the docs. I this all I need? GRANT ALL PRIVILEGES ON *.* TO monty@% - IDENTIFIED BY 'some_pass' WITH GRANT OPTION; DBA / Unix Administrator Patrick Fowler Wynit, Inc

Moving from MS-SQL to MySQL

2002-09-17 Thread Patrick Fowler
to authenticate users without with their win2k login and not have to type in the login/passwd again? Is MySQL as flexable as MS-SQL with scheduling task and process. DB = MySQL OS = RH Linux 7.3 HW = New IBM xSeries hardware. Thanks for any information you may provide. DBA / Unix Administrator Patrick