Re: monitor multiple mysql servers with no 3306 access

Hi Bing Du wrote: In our situation, we have three or four separate MySQL servers running. Each has 'skip-networking' configured. So mysql don't accept requests coming from outside via network. Each mysql server also runs as web server. 'Localhost' is used for communication between web

how would mysqld restart affect dynamically set global variables?

on max_connections remain? I'm just very clear when to make dynamic changes and when is better to put changes in my.cnf. Please advise. Thanks in advance, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

monitor multiple mysql servers with no 3306 access

. In this case, how should I monitor our multiple mysql servers remotely? Would anybody advise? Thanks in advance, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: monitor multiple mysql servers with no 3306 access

On 3/13/07, Bing Du [EMAIL PROTECTED] wrote: Hi, Seems like there are quite many MySQL monitoring tools on the Internet. The one I tried today was MONyog http://www.webyog.com/en/. I've also tried a couple of others before, including phpmysqladmin as I was suggested. They require you

Re: no log generated?

On 12/19/06, Bing Du [EMAIL PROTECTED] wrote: Hi, We use /usr/libexec/mysqld Ver 4.1.20 for redhat-linux-gnu on i386 (Source distribution). /etc/my.cnf has the following configurations. == [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password

no log generated?

experienced too many connections problem. But I didn't find anything got logged in mysqld.log. Why is that? I'm sure that's the config file mysqld reads because the pid-file has the pid of the running mysqld. I'd appreciate any insight. Bing -- MySQL General Mailing List For list archives: http

account that can only do backup

extremely slow since I noticed the mysql.com was redesigned. Thanks in advance, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: account that can only do backup

On 12/13/06, Bing Du [EMAIL PROTECTED] wrote: Hi, I want to create a MySQL user account that can only do database backup but nothing else. What privileges does such an account need? I'm having trouble with connecting to mysql.com to look at the documents. It's just spinning forever

Re: retrieve value from an external file?

On Thursday 20 July 2006 12:48 pm, Bing Du wrote: Hello everyone, mysqlupdate research set publications='lng text in a file' where uid=319; You already have the data in a storage system ( a file on the filesystem ). That said, use what you have, store the location to the file

Re: retrieve value from an external file?

even possible, to grab the content from the file and use it in the following update statement? mysqlupdate research set publications='lng text in a file' where uid=319; Any ideas? Thanks in advance, Bing Bing, You could create a temporary table with a single text field and then use

retrieve value from an external file?

from the file and use it in the following update statement? mysqlupdate research set publications='lng text in a file' where uid=319; Any ideas? Thanks in advance, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

user can see more than it's allowed to see?

' | +--+ 2 rows in set (0.00 sec) As user test1user: mysql show databases; +--+ | Database | +--+ | test | | test1| +--+ 2 rows in set (0.00 sec) Bing -- MySQL General Mailing List For list archives: http

Re: user can see more than it's allowed to see?

database test itself has Grants that it shows itself to everyone. How should I verify that? Thanks, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: query of a query?

to the database. Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

possible to select from multiple databases?

and database2? Is that even possible in single SELECT? SELECT title, db_entry_num, projectID FROM account_info, ResearchProjects WHERE ResearchProjects.IDNo = $idno AND account_info.db_entry_num = ResearchProjects.projectID Thanks in advance, Bing -- MySQL General Mailing List For list archives

query of a query?

of a query --- cfquery dbtype=query name=getstudproj SELECT title, db_entry_num, projectID FROM getprojects, getprojectID WHEREdb_entry_num = projectID /cfquery /cfif = Thanks, Bing -- MySQL General

link MS Access to MySQL?

and tables in Access are links pointing to tables in MySQL? What I want is do linked table the other way, which is store data in Access and make tables in MySQL links that point to tables in Access? Is it possible and how? Thanks in advance, Bing -- MySQL General Mailing List For list archives: http

Re: link MS Access to MySQL?

supports direct MySQL to MySQL sharing. It is not ready to do MySQL to any other server yet. http://dev.mysql.com/doc/refman/5.0/en/federated-description.html http://dev.mysql.com/doc/refman/5.0/en/federated-limitations.html Interesting, thanks much for the information, Shawn. Bing -- MySQL

Re: Is port forwarded connection taken as local?

Bing Du wrote: Hello everyone, What I'm after is trying to figure out a way to centrally and remotely managing (e.g. on server1) our MySQL servers (server2 is an example) on different machines. Right now, these MySQL servers are all set up to only accept logons from localhost. My questions

Is port forwarded connection taken as local?

'myusername'@'localhost' (using password: YES) But on server2, the following command works fine. server2% mysql -h localhost -u myusername -p I'd appreciate if anybody would shed some light. Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

web assistant?

server 2000 data by specifying how often the HTML pages are updated. I'm wondering if any equivalent or similar feature is provided by MySQL? Thanks, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

manage multiple mysql servers on different hosts?

, are there any tools that can do that? Can phpMyAdmin manage multiple mysql servers? Thanks in advance for any ideas, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

install multiple versions of MySQL?

rather than from RPM, right? I'm running RHEL 3. Thanks in advance, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

about mysqld

1966 1963 ... ... So what might have caused 1-1932-1962-1963-1964? Also there are 10 mysqld running. Does that mean there are that many connections established? Would anyboby shed some light or provide pointers? Thanks much in advance. Bing -- MySQL General Mailing List For list archives

how to resolve this conflict?

rpmUtils.runTransaction(ts,rpmCallback, transdir) File /usr/share/rhn/up2date_client/rpmUtils.py, line 520, in runTransaction Failed running transaction of packages: %s) % errors, deps=rc) // So any way to walk around this conflict? Thanks in advance for any suggestions. Bing

asking opinion about hosting database and webserver on the same server

. Thanks in advance for sharing your opinion and experience or pointers! Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

what's the relationship among 4.1, 5.0 and 5.1?

to understand how there are several versions for the same software and suggestion on which one should be used? Thanks in advance, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

why libmysqlclient.so.10?

for any help. Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqld disappeared!

. Anybody have any clues what might have happened? What should I do to get safe_mysqld back? Thanks in advance for any help, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

migrate Access to MySQL

information. So we need some how to map Access fields to MySQL fields. Anybody would like to share experience about how you did your migration and what kind of tool can best meet needs as such? Thanks much in advance, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: migrate Access to MySQL

information. So we need some how to map Access fields to MySQL fields. Anybody would like to share experience about how you did your migration and what kind of tool can best meet needs as such? Thanks much in advance, Bing Thanks all who replied. I had no problem transfering Access

Re: not a rpm package?

of the package itself. HTH Daniel Thanks for the help. $ file MySQL-server-5.0.4-0.i386.rpm MySQL-server-5.0.4-0.i386.rpm: data Is that correct? Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

not a rpm package?

I downloaded MySQL-server-5.0.4-0.i386.rpm. When I did 'rpm -i MySQL-server-5.0.4-0.i386.rpm', the following message returned: MySQL-server-5.0.4-0.i386.rpm: not an rpm package (or package manifest): What's the problem? Bing -- MySQL General Mailing List For list archives: http

access 3.23 tables on 5.0?

to make these tables created on 5.0 to be accessible on 3.23? Thanks in advance for any help. Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

search a field in all the tables?

be done across all the databases? Thanks in advance for any help. Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: search a field in all the tables?

Thanks so much for taking time replying, Rhino. Unfortunately, I don't know Java much. But I got your point. Yeah, I wish it could be done within MySQL. Bing - Original Message - From: Bing Du [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 10, 2004 10:52 AM

Didn't find any fields in table, why?

to be moved over? Thanks in advance for any help. Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Didn't find any fields in table, why?

line 12, the table could be imported fine. Is there some syntax of version 3.* that is not supported in version 5.*? Like I said, there are a lot tables that need to be transferred, manually editting the dump file is not acceptable. Any workaround? Bing Bing Du wrote: I have two mysql servers

RE: Didn't find any fields in table, why?

--compatible as a valid option. 'mysqldump -V' shows mysqldump Ver 9.10 Distrib 4.0.18, for pc-linux (i686). I also looked through mysqldump help but did not find any option that could be used to produce a backward compatible dump. Any ideas? Bing ENGINE syntax is availiable in 4.1.x and later versions

RE: Didn't find any fields in table, why?

Yes, migrate from 5.0.x to 3.23.x. No innodb and dbd tables. Bing Are you migrating from 5.0.x to 3.23.x? Do you have any innodb or dbd tables? -Original Message- From: Bing Du To: '[EMAIL PROTECTED] ' Sent: 6/29/04 3:59 PM Subject: RE: Didn't find any fields in table, why

RE: Didn't find any fields in table, why?

? Bing I have not tried 5.0.x to 3.23.x but give this a try: Flush the tables with read lock or flush the tables and shutdown the database tar.gz the files Move the files to the the new server Untar/unzip the files Start up both databases -Original Message- From: Bing Du

mysql.user does not reflect privileges granted correctly?

into table ltm_enrollment as user 'ltmuser'@'localhost' without any problems. Would anybody tell me what's wrong? Thanks, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql.user does not reflect privileges granted correctly?

'ltmuser'. Bing Bing Du wrote: I did: mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret'; But mysql select * from user where user='ltmuser'\G; shows: :: that 'ltm' != 'ltmuser' :-) Or is the example a typo? -- Hassan Schroeder - [EMAIL

Re: mysql.user does not reflect privileges granted correctly?

Thanks for the heads-up! Bing Du [EMAIL PROTECTED] wrote: Greetings, I did: mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret'; But mysql select * from user where user='ltmuser'\G; shows: *** 1. row

disable an option but not take server down?

down time. But now it's a command line option, how can I disable it without stopping/starting the server? Any ideas? Thanks, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

same table description behaves differently on different machine?

as '20030729081900' on the source machine. But the time reads like '2003-07-29 08:19:00' on the destination machine. Can anybody tell me why the 'modified' field changed from type 'timestamp(14)' to type 'timestamp'? I need to keep the type timestamp(14). Thanks in advance, Bing -- MySQL General Mailing

Re: same table description behaves differently on differentmachine?

Paul, your guess was absolutely correct. Looking at the information pointed to by the URL you sent, seems it's pretty easy to switch to the old format. That's good. Thanks for the heads-up! Bing At 15:46 -0600 2/24/04, Bing Du wrote: Greetings, I used the 'scp' command to copy the file.MYD

grant problem

as user 'root' and got the error: mysql grant all on *.* to 'someuser'@% identified by 'secret'; ERROR 1045 (0): Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Any idea what I did wrong? Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Newbie

Have you tried creating a table called 'oldreport_2002_12_08' following the instructions on http://www.mysql.com/doc/en/CREATE_TABLE.html? Bing I have spent some time in the past with mysql but am far from an experienced database head. A while back I received a some mysql data for a research

RE: Newbie

and oldreport_2002_12_08.MYI. Better rename them temporarily to something else and move them back after table 'oldreport_2002_12_08' is created. Bing Thanks for the response. The syntax: mysql CREATE TABLE oldreport_2002_12_08 as select * from oldreports where 1=2; wouldn't that just create an empty

use mysqldump and mysqlhotcopy together?

in the first place and using mysqlhotcopy to backup actual database binary files every day. How bad is my idea? Thanks in advance for sharing experiences, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

does mysqldump take care of stored procedures?

should I do to get the stored procedures backed up as well? Any suggestions/ideas appreciated. Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: does mysqldump take care of stored procedures?

Ah, I forgot to dump the 'mysql' db. Thanks so much, Mikhail, for waking me up :). Bing Hi, since MySQL stores stored procs in mysql db you need to make backup of mysql db. But it would be nice to have a possibility to make backup of stored procs in readable format. Best regards

How 'if not exists' implemented in MySQL?

'if' syntax. How does MySQL do 'if not exists' to check if the SELECT statement returns no rows ? Thanks in advance for any help and ideas, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How 'if not exists' implemented in MySQL?

MySQL support user defined parameters (or perhaps it's called something else rather than 'parameter')? Bing First, please be aware that MySQL 5.0 is an alpha release. It is very young and there may still be some unresolved issues. It is not generally recommended to use alpha releases in production

MySQL 5.0

Any time table for MySQL 5.0 go production? We need its stored procedure feature. Thanks, Bing Du Engineering Computing Support Services 2240 Hoover Hall Iowa State University voice: 515-294-6405 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

how to drop more than one tables at once in a database?

Greetings, Say, one database has a lot of tables. How can I drop some of them all at once assuming their names follow some pattern like tbl_*? Thanks in advance for any ideas, Bing Du Engineering Computing Support Services 2240 Hoover Hall Iowa State University voice: 515-294-6405 email

Re: how to drop more than one tables at once in a database?

to be dropped is not acceptable to us. Thanks anyway. Bing On 5 Jan 2004, at 19:58, Bing Du wrote: Greetings, Say, one database has a lot of tables. How can I drop some of them all at once assuming their names follow some pattern like tbl_*? Thanks in advance for any ideas, Take a look

How to unsubsribe from the mysql list?

Hi all, Could you please tell me how to unsubsribe from the mysql list? Thanks, Li Bing _.._ .' '-. `. __/__(-. `\ \ /o `o

Re: How to unsubsribe from the mysql list?

Dear Wheeler, I forgot the authorization code o mysql list. I need it to usubscribe. How can I do? Thank so much! Li Bing - Original Message - From: Alfred Wheeler [EMAIL PROTECTED] To: Li Bing [EMAIL PROTECTED] Sent: Sunday, March 17, 2002 9:08 AM Subject: Re: How to unsubsribe from

Re: load multiple files into the same table at once?

Hrmm...from my testing, omitting REPLACE has the same effect as IGNORE is used. Bing Bing Du [EMAIL PROTECTED], 979-845-9577 Texas AM University, CIS, Operating Systems, Unix [EMAIL PROTECTED] 08/08/01 02:50AM Dear Bing, what about omitting REPLACE? This should simply load the data

Re: importing data

Please see section 6.17 of http://www.mysql.com/doc/index.html. Bing Bing Du [EMAIL PROTECTED], 979-845-9577 Texas AM University, CIS, Operating Systems, Unix Kevin Fonner [EMAIL PROTECTED] 08/07/01 10:08AM Is there an easy way or perhaps a utility to import a tab delimeted text file

load multiple files into the same table at once?

that the first one just loaded. If I use 'ignore', the grades can not get loaded at all. Any help would be greatly appreciated. Bing Bing Du [EMAIL PROTECTED], 979-845-9577 Texas AM University, CIS, Operating Systems, Unix - Before

mass data load

are greatly appreciated. Bing Bing Du [EMAIL PROTECTED], 979-845-9577 Texas AM University, CIS, Operating Systems, Unix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: mass data load

Stefan, Hrmm...which manual did you refer to? I found some LOAD DATA info in the on-line manual http://www.mysql.com/documentation/mysql/bychapter/. But its chapter 7 is about 'MySQL Full-text Search'. Bing Bing Du [EMAIL PROTECTED], 979-845-9577 Texas AM University, CIS, Operating

Invert all bits (~)

In version 3.22.32 I can't get the Invert all bits-function to function. Is it implemented later or am I doing it all wrong? I'm trying to do a select ~bitmask from mytable... I've tried with (~bitmask) and a gazillion other tricks, but only get a syntax error out of it.. Anyone?

Is an Object-Relational MySQL available?

Hi, All, I need an object-relational database. Can MySQL have such a capability? Thanks, Li Bing _.._ .' '-. `. __/__(-. `\ \ /o `o

The Syntax to Get JDBC Connection

/RegistrationDB?user=libing;password=123456); My requirements are as follows, I need to create a database, RegistrationDB, after getting connected with MySql. The username is libing and password iis 123456. Thanks! Li Bing