how would mysqld restart affect dynamically set global variables?

ge 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]

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 >>

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 bef

monitor multiple mysql servers with no 3306 access

tions and database server. 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: 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] >> d

no log generated?

ysqld 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 Lis

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 connectin

account that can only do backup

has become 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: retrieve value from an external file?

save it in a file on the file >>system. But I don't know how, or if that's even possible, to grab the >>content from the file and use it in the following update statement? >> >>mysql>update research set publications='lng text in a file' where >

Re: retrieve value from an external file?

> On Thursday 20 July 2006 12:48 pm, Bing Du wrote: >> Hello everyone, > >> mysql>update 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 s

retrieve value from an external file?

t's even possible, to grab the content from the file and use it in the following update statement? mysql>update 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.m

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]

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

SERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `test1`.* TO 'test1user'@'localhost' | +--+ 2 rows in set (0.00 sec) As user test1user: mysql> show databases; +--+ | Database | +-

possible to select from multiple databases?

o get data from both database1 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

Re: query of a query?

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

query of a query?

WHEREdb_entry_num = projectID = Thanks, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: link MS Access to MySQL?

ed database engine only supports direct MySQL > to MySQL sharing. It is not ready to do MySQL to 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 informatio

link MS Access to MySQL?

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 arch

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

Is port forwarded connection taken as local?

): Access denied for user '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: ht

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?

rver, 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?

rom source 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]

how to resolve this conflict?

ine 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

about mysqld

1963 ... mysql 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 Mai

asking opinion about hosting database and webserver on the same server

vy traffic. 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?

lp 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?

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]

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]

Re: migrate Access to MySQL

et tables in MySQL already have some > 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, > >

migrate Access to MySQL

some 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.mysq

Re: not a rpm package?

d rpm, or you've downloaded a link to the package, instead 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://list

access 3.23 tables on 5.0?

ile: './LTM/person.frm' Is there anyway 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]

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

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]>

search a field in all the tables?

so 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: Didn't find any fields in table, why?

ble with 3.23.x? 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 > >

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: R

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

ysqldump --help' does not show --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 >

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

27;List the names and locations of files attached to tasks'; I did a test, seems after removing 'DEFAULT CHARSET=latin1' from 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

Didn't find any fields in table, why?

g files because I have a lot tables that need 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: 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

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

;N' in all the *_priv columns for user '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='lt

mysql.user does not reflect privileges granted correctly?

: YES) What privileges are needed for doing 'load data infile'? I can insert rows one by one 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]

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]

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 use

same table description behaves differently on different machine?

Now the time shows 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 t

RE: Newbie

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; > wou

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 my

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 M

use mysqldump and mysqlhotcopy together?

were created 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]

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

does mysqldump take care of stored procedures?

ayed missing. How 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: How 'if not exists' implemented in MySQL?

d MaxDB has a bunch of param_* DBM commands. Does 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 unr

How 'if not exists' implemented in MySQL?

other than some very basic '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 to drop more than one tables at once in a database?

he tables 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 pat

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

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

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,

How to unsubsribe from the mysql list?

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

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 A&M University, CIS, Operating Systems, Unix >>> [EMAIL PROTECTED] 08/08/01 02:50AM >>> Dear Bing, what about omitting REPLACE? This

load multiple files into the same table at once?

But the second 'load data' replaces all the stuff 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 PR

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 A&M University, CIS, Operating Systems, Unix >>> Kevin Fonner <[EMAIL PROTECTED]> 08/07/01 10:08AM >>> Is there an easy way or perhaps a util

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 A&M Univer

mass data load

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

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 _.--"""--._ .' '-. `. __/__(-. `\

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