how would mysqld restart affect dynamically set global variables?

Hi, We're running mysql 4.1.20. If I understand the manual correctly, I can change max_connections while mysqld is running without restart mysqld to make the change take effect. But what if mysqld restarts later in some other situations, like machine reboot, would my (global) change on max_conne

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

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 provide mysql server name and port number. In our situ

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?

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 format for compatibility with mysql 3.x # clients (thos

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

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. Actually, the connection to mysql.com has become extreme

Re: retrieve value from an external file?

> At 02:48 PM 7/20/2006, you wrote: >>Hello everyone, >> >>Without scripting, can this be done from mysql> command line? The >>'publications' field is mediumtext in table 'research'. Since >>'publication' is pretty long, I want to save it in a file on the file >>system. But I don't know how, or

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?

Hello everyone, Without scripting, can this be done from mysql> command line? The 'publications' field is mediumtext in table 'research'. Since 'publication' is pretty long, I want to 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 fro

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?

Hello, I don't understand why user 'test1user' can see database 'test' as well. I think user 'test1user' should only be able to see database 'test1'. What did I do wrong here? I'd appreciate any help. Thanks. As root: mysql> show databases; +---+ | Database | +--

possible to select from multiple databases?

Hello, I have two separate databases that I need to query data from. In the following SELECT statement, 'title' and 'db_entry_name' are in database1, and 'projectID' is in database2. If they were in one database, this SELECT should work. How should I tweak it to get data from both database1 and

Re: query of a query?

> Not necessarily. I would think the CREATE SELECT statement would be > the closest equivalent. > > http://dev.mysql.com/doc/refman/4.1/en/create-table.html > Thanks much for the reply, John. That surely would help with our future applications. But this time, we only have read access to the

query of a query?

The following are Cold Fusion code. It's interesting that previously defined queries can be used as 'tables' to pull data from. In MySQL, does the same functionality have to be implemented using join or subselect? === SELECT db_entry_num, title

Re: link MS Access to MySQL?

> The only way to link tables in MySQL (to use the term from Access) is to > use the Federated database engine. A Federated table physically exists on > one server but virtually exists on another. This is exactly like creating > a linked table. > > However, AFAIK, the Federated database engine only

link MS Access to MySQL?

Hello everyone, Please correct me if my understanding is wrong. Does the implementation of linked table mentioned on "18.1.11.3. How to Import or Link MySQL Database Tables to Access?" (http://dev.mysql.com/doc/refman/4.1/en/import-of-data.html) means that data is actually stored in MySQL and tab

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?

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: 1. server1 has to

web assistant?

Hello, Anybody here are also familiar with SQL server 2000 Web Assistant Wizard? The wizard enables you to create queries that run against the SQL server 2000 database to push data to your web site in the form of static pages. You can choose how often the web client sees the changes in the SQL se

manage multiple mysql servers on different hosts?

Hello everyone, We're running several mysql servers for different applications on different machines. Instead of connecting to each mysql server manually to find out basic information, e.g. versions, mostly like what 'show variables' returns, plus what databases exist on each server, are there an

install multiple versions of MySQL?

Hello everyone, I've ever seen some document about how to install multiple versions of MySQL on the same server. But I don't remember where I saw the document. Anybody know anything about it and happen to have some pointers? If I want to install multiple versions, I have to install from source

how to resolve this conflict?

Hello, 5.0.11-beta-standard is already running. Now I need to install php-mysql which requires mysql-3.23.58-15.RHEL3.1.i3. Here is what I did and the errors I got: $ sudo up2date -i php-mysql Password: Fetching Obsoletes list for channe

about mysqld

Hi, Usually, 'ps -ef|grep mysqld' shows: root 1932 1 ... mysql 1962 1932 ... mysql 1963 1932 ... mysql 1964 1932 ... ... But today I noticed it's like this: root 1932 1 mysql 1962 1932 ... mysql 1963 1962 ... mysql 1964 1963 ... mysql 1965 1963 ... mysql 196

asking opinion about hosting database and webserver on the same server

Hello all, Should MySQL and Apache be hosted on separate servers or it's ok they being on one server? We're building a compound that includes about 10 websites, all their contents are hosted in MySQL. There will be frequent database updates and the webserver will have to handle heavy traffic. T

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

Hello, Anybody have a good pointer that could help explain why is 4.1, 5.0 and 5.1 respectively? 5.0 had been in development state for a while, now it's finally released. I know 5.0 has added more features. Would 4.x eventually be obsolete and replaced by 5.x? I guess I need some help to under

why libmysqlclient.so.10?

Hi, When I run a Perl script that uses DBI and DBD::mysql on a RHEL 3 machine, I got this error: == Can't load '/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.10: cannot open shared object file: No such file or directory

mysqld disappeared!

Hi, Linux 2.4.21-32.0.1.EL #1 Tue May 17 18:01:37 EDT 2005 i686 i686 i386 GNU/Linux I rebooted the mysql server. After the OS came back, I was not able to find mysqld, safe_mysqld and mysqladmin any more (their respective man pages are still there). But the mysql client command and other mysql

Re: migrate Access to MySQL

> Hello, > > I've been looking around for a while. Seems there are many options and > tools that can help do it. Guidance and directions are highly welcome. > > We need to move the contents of a bunch of tables from Access to the > existing tables on MySQL. The target tables in MySQL already hav

migrate Access to MySQL

Hello, I've been looking around for a while. Seems there are many options and tools that can help do it. Guidance and directions are highly welcome. We need to move the contents of a bunch of tables from Access to the existing tables on MySQL. The target tables in MySQL already have some infor

Re: not a rpm package?

> The problem is exactly as the problem says, you're trying to install > something > that isn't an RPM package. Try: > > file MySQL-server-5.0.4-0.i386.rpm > > It'll tell you what the file you've downloaded actually is. Either it's a > corrupted rpm, or you've downloaded a link to the package, ins

access 3.23 tables on 5.0?

We moved a bunch of *.frm, *.MYD and *.MYI from 5.0 to 3.23. Now after successfully connecting to 3.23, it shows: Didn't find any fields in table 'person' Didn't find any fields in table '...' mysql> desc person; ERROR 1033: Incorrect information in file: './LTM/person.frm' Is there anyway

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://lists.mysql.c

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?

Many times I need to do this. I know the name of a specific field. But I don't know which table has this field. There usually are a lot tables in one database. So the question is how I can find out which table or tables has this field? If it can be done within one database, can it also be done

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

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

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?

; ENGINE syntax is availiable in 4.1.x and later versions. > > -Original Message- > From: Bing Du > To: [EMAIL PROTECTED] > Sent: 6/29/04 2:30 PM > Subject: Re: Didn't find any fields in table, why? > > Yes, both user and group ownership of the mydb directory and all i

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?

I have two mysql servers as shown below: MySQL server A: version 3.23.58, database: mydb, table: mytable MySQL server B: version 5.0.0-alpha-standard-log I want the server B to have the exact same database and table as those on the server A. So, on server B, I manually created a database called

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?

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 *** Host: localhost User: ltmuser Pas

disable an option but not take server down?

Greetings, Our MySQL server (4.0.13) is currently running with the option --skip-networking. We want the server to accept TCP/IP connections. If this option were specified in the config file, perhaps I could just modify the config file and HUP the server process. So there would be no server dow

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?

Greetings, I used the 'scp' command to copy the file.MYD, file.MYI and file.frm files from one linux box to another linux box. On the source linux box, the table is like this: mysql> desc file; +--+---+--+-+-+---+ | Field| Type

RE: Newbie

t; CREATE TABLE oldreport_2002_12_08 as select * from oldreports >> where >> 1=2; >> to create an empty copy >> >> I hope this helps >> >> Simon Windsor >> Eml: [EMAIL PROTECTED] >> Tel: 01454 617689 >> Mob: 07960 321599 >> >&

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 resear

grant problem

Greetings, This is how the entry looks like in the mysql.user table. So basically, root has all the global privileges. | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_

use mysqldump and mysqlhotcopy together?

Greetings, I've been looking at the backup/recover related discussions in the list archives for a while. Seems to me most people use either mysqldump or mysqlhotcopy. We don't have a good MySQL backup scheme in place yet. Now I have some questions based on my reading. How do I know how each ta

Re: does mysqldump take care of stored procedures?

stored procs > in > readable format. > > Best regards, > Mikhail. > > > - Original Message - > From: "Bing Du" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, January 21, 2004 4:42 PM > Subject: does mysqldump take ca

does mysqldump take care of stored procedures?

I'm testing backup and restore on MySQL 5.0. I did mysqldump first and then dropped a table and a stored procedure on purpose. After doing 'mysql -h host -u user -p database < dump-file', the dropped table could be restored back in the database. But the dropped procedure stayed missing. How sho

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

Thanks a bunch for your instance responce. Right now, I'm just testing the stored procedure feature of MySQL 5.0. If that works, we'll see next if the timetable for MySQL 5.0 go production can meet our own timetable. 'Select Into' was also what I figured. Just wanted to see if MySQL has already

How 'if not exists' implemented in MySQL?

Greetings, We're trying to migrate an application from MS SQL Sever 2000 to MySQL 5.0. Choosing version 5.0 of MySQL is because its support of stored procedure is needed. We have a stored procedure doing something as shown below on the MS SQL Server 2000: IF NOT EXISTS (SELECT statement) {sql

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