mysql monitoring?

is there an snmp mib or something available for snmp to monitor mysql server? or, does anyone have a script that they would like to share that they use to monitor and gather statistics about mysql? thanks, shon - Before posting,

RE: Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

ot@cofr3 mysql]# ./bin/mysqld -L /mysql/share/mysql/english Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! 021122 16:00:58 Aborting 021122 16:00:58 ./bin/mysqld: Shutdown Complete Regards, Ken Illingsworth >>> Shon Stephen

RE: Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

you say you chown -R mysql /usr/local/mysql/data, yet the error shows mysql trying to start with databases from /var/lib/mysql. check your startup script for basedir and datadir settings. -Original Message- From: Kenneth Illingsworth [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 20

RE: mysql permissions

thank you victoria! -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net] Sent: Friday, November 08, 2002 12:07 PM To: [EMAIL PROTECTED] Subject: re: mysql permissions Shon, Friday, November 08, 2002, 4:46:19 PM, you wrote: SS> i need to create a user (

RE: perl dbi and mysql question

yeah, but i was looking for a function. mostly just to see if a matching function to dbh->tables() existed. -Original Message- From: Grigor, Peter [mailto:pgrigor@;aseedge.com] Sent: Friday, November 08, 2002 10:07 AM To: 'Shon Stephens'; '[EMAIL PROTECTED]' Su

RE: perl dbi and mysql question

eureka! i found it! @dbs = $dbh->func('_ListDBs'); -Original Message----- From: Shon Stephens [mailto:sstephens@;corp.goamerica.net] Sent: Friday, November 08, 2002 9:45 AM To: '[EMAIL PROTECTED]' Subject: perl dbi and mysql question i am using perl dbi with dbd::m

mysql permissions

i need to create a user (besides root) that can show databases, show tables from every database, lock all tables, and flush all tables. what permissions should i grant to this user? thanks, shon [don't bounce me as spam] mysql sql query ---

perl dbi and mysql question

i am using perl dbi with dbd::mysql. i know that using the dbi function, $dbh->tables (), will list all the tables in a database. is there a function that will show all the databases on a server? thanks, shon - Before posting, pl

mysql backup user permissions?

i want to add a user to my system that has permissions to backup all the databases using mysqlhotcopy. i don't want to use the root user. so what permissions (minium set) should i give the user in order to accomplish this. thanks in advance, shon --

RE: using load_file...problems

i also figured out that load_file only works on the local server, not from clients...duh! thanks! -Original Message- From: Egor Egorov [mailto:egor.egorov@;ensita.net] Sent: Tuesday, October 29, 2002 12:19 PM To: [EMAIL PROTECTED] Subject: re: using load_file...problems Shon, Tuesday, O

using load_file...problems

sql/mysql i am trying to insert data into a blob column. its not working. i have tried setting --local-infile=1. i tried granting file to my user and got an error. i have read the manaul (for all you smarties who like to rtfm everyone) and still don't get it. here is what i did for grant grant fi

RE: safe_mysqld - my.cnf weird foo

thanks victoria. now that is cleared up for me. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 8:41 AM To: [EMAIL PROTECTED] Subject: Re: safe_mysqld - my.cnf weird foo Shon, Tuesday, July 16, 2002, 10:45:19 PM, you wrote: SS> i c

my.cnf - pulled out all my hair

can anyone tell me how to make mysql read my.cnf from /usr/local/etc instead of /etc? i tried configuring with --sysconfdir=/usr/local/etc at compile time. that is not working. thanks, shon - Before posting, please check: htt

more weird my.cnf foo???

i recompiled/reinstalled 3.23.51. i copied mysql.server /etc/rc3.d/S99mysql. i edited /usr/local/etc/my.cnf. i started mysql and it read the my.cnf file from that location and everything worked great. i created a solaris package and installed it on another system. the system the package was instal

safe_mysqld - my.cnf weird foo

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 i configure/make/make install mysql-3.23.51 on sparc solaris using gcc-2.95.2. i used the configure option --sysconfdir=/usr/local/etc. i ran the mysql_install_db script, i performed all the chown/chgrp operations, i copied mysql.server to /etc/rc3.

relocatable mysql?? - off topic??

once, and use relocatable packages. is this possible? second, i have other programs, such as perl dbi, which use the mysql libs. how can i compile once, create a relocatable package, and still have my supported programs function properly? thanks, shon ste

what permissions do i need to set

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 i have an application that will allow me to rotate mysql table using date variable substition. in other words table=tblname.%m%d%Y if i am using a remote system to host the application, what permissions to i need to give the remote application use

RE: Need help

check that the file exists. also check that the user that mysql is running as has the appropriate permissions to read/write that file. run the "perror" command. -Original Message- From: Bertrand TACHAGO [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 09:16 To: [EMAIL PROTECTED] Sub

mysql 3.22.32 table checking

i am running mysql version 3.22.32. yes i am planning an upgrade. in the meantime, i need to check (and possibly) repair my tables without bringing down the mysql daemon. thanks, Shon Stephens 540.942.7292 office 540.649.3508 mobile shon8work aim

Re: perl mysql DBI::db question

Message - From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]> To: "Shon Stephens" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, February 27, 2002 11:32 AM Subject: Re: perl mysql DBI::db question Try moving your $dbh->disconnect call afte

perl mysql DBI::db question

i am trying to write a program in perl and am getting a mysql error from my module. here is the error: DBI::db=HASH(0x294738)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at ./pop.pl line 124, line 2." i think a

Re: what type of key is this?

thanks, that did the trick just fine. shon - Original Message - From: "Rick Emery" <[EMAIL PROTECTED]> To: "'Shon Stephens'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, February 01, 2002 11:55 AM Subject: RE: what type of key

what type of key is this?

i have been asked to create an sql table with a certain structure. i was sent a description of the table. the first column is desribed as having a "MUL" key. i don't now what that is or how to create it. can someone please help. thanks, shon

MySQL +VCS?

for MySQL, I am struggling. If anyone (even those who haven't attempted this) has any ideas for software agents, please respond. Thanks Shon Stephens [EMAIL PROTECTED] - Before posting, please check: http://www.mysq

MySQL Log Management

I am looking for some suggestions for MySQL log management. Just some people to respond to this message with their log rotation, and archival methods. I am just curious to see what others are doing, and to possibly suggest a method for myself to use. Thanks, Shon Stephens

MySQL determination of hostname?

How does MySQL determine hostnames when checking access permissions? I assume it uses whatever methods are available to the system (/etc/hosts, NIS, DNS, etc...). Will it use those services in the order they are listed in nsswitch.conf (Solaris)? What about for determining its local hostname?

MySQL General Questions

I have read the documentation thoroughly, however there are still some things unclear to me, and others that I want opinions on. I am dismayed at what I see as a fundamental lack of "server administration" documentation. Much of the docs focus on the SQL aspects of MySQL. There is only a minor

Re: Mysql and tmp dir problem

Have you checked that /tmp isn't full? If /tmp is its own filesystem, and its full, then no matter what the permissions you won't be able to write to it. At 10:24 PM 10/2/01 +0200, you wrote: >When execcuting some queries in MySQL (3.23.42) on Redhat 7.1 i'v got >error: >ERROR 1: Can't create/w

Change options during MySQL compile???

option "--sysconfdir" would do this. It did not. Does anyone know how to do this? Also, I know how to compile mysqld with extra character sets, is there anyway to limit the character sets that are built? I don't want support for all of the character sets, just a few. Thanks, Shon

Re: mysqlbinlog

perl script At 08:50 AM 8/9/01 -0400, Michael T. Babcock wrote: >I would like to dump all sql transactions from a binary transaction log >for a specific table after a specific timestamp. I can run mysqlbinlog >and delete all the queries up to the point of the correct timestamp, then >try to filt

Re: Remote MySQL Console?

Setup a user account that can access your databases from the remote hosts you wish to use. Do this using GRANT. Then install the mysql client on those systems and use mysql -h hostname -u user -p password to connect. Shon Stephens At 01:38 PM 8/5/01 -0400, Chris wrote: >Is there a metho

MySQL vs. Oracle

rt in MySQL for something akin to Oracle's Parallel Server? Can I use MySQL with Veritas? Thanks, Shon Stephens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: HA Setup for MySQL

to know if an update to server A updates server B will server A ignore the update when it comes in from server B? Thanks, Shon Stephens At 01:44 PM 7/13/01 -0500, Gerald Clark wrote: >I don't believe NFS locking is reliable enough to allow two >servers to serve the same databases.

HA Setup for MySQL

-> B -> A. I want to be able to put both system behind a load-balancing switch. If an insert is done on server A, then server B is updated, then server B sends an update to server A, will server A know to ignore it since it originated from server A? Thank