Re: General MySQL Question: Ed Reed (CA, United States ofAmerica) Medium

s to attend the Quiz Show (Wed 8pm) or other "after hours" activities. Great fun, and a good way to hook up with people for dinner or drinks away from the center. Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA Mike Wexler wrote: The area by the Santa Clara convention c

Re: [OT} How to pronounce GIF

In an effort to quell this off-topic and rather pointless dialog, allow me to refer you to the Wikipedia article on the subject: http://en.wikipedia.org/wiki/GIF Specifically the section: "According to the creator of the "GIF" format, Steve Wilhite, the pronunciation is with a soft "g" and the

Re: www/dev.mysql.com?

by tomorrow afternoon US pacific time. -- Eric Braswell Web Manager MySQL AB Cupertino, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Crashing mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686)

Is there a reason you cannot upgrade from an early =alpha= version of 5.0 ? I think you fill find the release versions more stable. -- Eric Braswell Web Manager MySQL AB Cupertino, USA murthy gandikota wrote: Hi Can someone tell me where in the file system to look for the logs? Mysql

Re: MySQL lock tables - bug or not?

+ 2 rows in set (0.00 sec) mysql> show databases; ++ | Database | +----+ | information_schema | | dl | ++ 2 rows in set (0.00 sec) -- Eric Braswell Web Manager MyS

Re: MySQL Read_only Mode

--read_only is probably what you are looking for. http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html -- Eric Braswell Web Manager MySQL AB Cupertino, USA Clyde Lewis wrote: The idea is to prevent all users from applying changes to the system. Not just a single user

Re: possible to select from multiple databases?

ojectID This is easy as long as the dbs are on the same machine: SELECT * from db1.table1, db2.table1... Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to Verify Replication Status?

You could have a shell script lock the tables, do an md5sum on the .MYD and maybe .frm files (for MyISAM), then unlock. I can't off-hand think of any reason this wouldn't work well as long as the slave and master are configured identically and are the same version. Eric -- Eric Bra

Re: How to Verify Replication Status?

nces are. But this won't help you if you can't transfer all the data to one place -- you could just do a checksum then on both sides and compare that. Would be pretty easy to script that and perform periodic checks. Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA R

Re: Error on T_echo ?? what is this ?

This is not a PHP list and that's a PHP error. But you are missing a semi-colon at the end of the line "...`BondRem`)". Eric Brian E Boothe wrote: i,m getting the following error on my MySQL Code inserting data into a database, .? `OthrProjBill`, `OthrRem`, `BondAm`, `BondBill`, `BondRem`)

Re: Restrict MySQL server 4/5 to single IP

pecify the socket name as a parameter), but if your requirement is that clients must connect using default settings, then this is one way. Personally I'd find another. Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA -- MySQL General Mailing List For list archives: h

Re: Restrict MySQL server 4/5 to single IP

x27;m confident you'll find there are ample options to get the setup that works best for you. I strongly suggest you read up in the manual on how MySQL handles TCP/IP and local connections. Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA -- MySQL General Mailing List Fo

Re: Restrict MySQL server 4/5 to single IP

guration file, and the appropriate mysqld binary, for each instance. Before the instance manager in 5.0, there is also mysqld_multi: http://dev.mysql.com/doc/refman/4.1/en/mysqld-multi.html, which might be of help here. Does that make sense? Did I misunderstand? -- Eric Braswell Web Manager

Re: Web Farm Design

g sure that MySQL server is making the best use of memory. If you give us more details I think we can probably give more specific advice on what sort of architecture might be an appropriate fit. -- Eric Braswell Web Manager MySQL AB Cupertino, USA Elias wrote: We are currently building a

Re: Restrict MySQL server 4/5 to single IP

Yves Goergen wrote: On 04.04.2006 23:17 (+0100), Eric Braswell wrote: my.cnf: bind-address = Will probably do the trick. How can I enter multiple IP addresses there? This isn't documented online. I need to bind it to one specific external address and additionally to localhost (127.

Re: Mysql over HTTP

Jangita wrote: > Yes this is very true Eric, thanks. > > BUT there are LOADS of firewalls that don't allow non http traffic (like > mysql) over port 80; and your method wont work if all that's available is a > http proxy! > Ah, so you want to be able to bypass a firewall that does stateful ins

Re: Mysql over HTTP

No need to re-invent that wheel: Just use port=80 in my.cnf or start with --port=80 See http://dev.mysql.com/doc/refman/5.0/en/server-options.html Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA Jangita wrote: Hi all, It's all well and good having mysql using port 330

Re: upgrading problem

You need root privileges. Login as root or use sudo. E.g. sudo rpm -Uvh MySQL-shared-compat-5.0.19-0.rhel4.i386.rpm If you don't have root or sudo access, you can't perform this upgrade. You could possibly use the --prefix and --relocate rpm install options to install mysql into a directory f

Re: Replication for historical data

/articles/storage-engine.html Hope that helps, Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA Ian Collins wrote: Hi, I have a customer who wants to be able to replicate their live MySQL database to a second server, but not to have any data deleted. i.e., they want to accumulate the

Re: Restrict MySQL server 4/5 to single IP

my.cnf: bind-address = Will probably do the trick. -- Eric Braswell Web Manager MySQL AB Cupertino, USA Yves Goergen wrote: Hi, I have a machine with multiple IP addresses on my network interface and I have setup multiple MySQL servers on the machine, version 4.0 and 5.0. Currently

Re: MySQL 4.0.18 on Mac OS X 10.2.8 won't start

ed to us another utility other than safe_mysqld to start the mysql server. In most cases it is better to use safe_mysqld. Any special options you need can be specified in /etc/my.cnf. But it sounds like you are using the default installation, so everything should just work. Eric -- Eric Bra

Re: Wrf files: how can I read them?

a link to the Webex player on all web seminar signup pages. Hope you enjoy the seminars -- they have been getting extremely popular! Eric -- Eric Braswell Webmaster MySQL AB Cupertino, USA Hi, there is link "take the free trial" on webex site. haven't you seen the