RE: Linux vs. Windows?
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 OS is better. Don't let anyone push you in one direction if you are more comfortable with the other OS. If you have little exposure with both I would say Linux. Not because it may or may not outperform windows just because once you learn it it's under your belt. Same machine, any performance difference? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
database dir change
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 Syracuse, NY 13057 V (315)437-1086 x2172 F (315)437-0432
InnoDB
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?
Hello, Is there a way to have email from an email account on a MS Exchage Server be populated into MySQL. I can to this by connecting to the exchange server with MS Access and then push the data from access into the MySQL table. I would like not to have to use MS Access. Thanks for any help. 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://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Output to a file?
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 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://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Remote ServerAccess
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. 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://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Moving from MS-SQL to MySQL
Hello, We are thing about moving from MS-SQL to MySQL. We are in the very early planning of creating a data warehouse. Does anyone have any information regarding the +/- of using MySQL vs MS-SQL. The db will at most be 20gb with about 100 users. A few questions would be: Is there a way 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 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://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php