Re: advice for blob tables?

I would love to see an implementation with 1 row for large data that works well. The main issues I had were that mysql has a default max packet size limit (I think it used to be like 16MB (mysql 3.23) - 1GB Mysql 4 - Not sure v5. Alot of people don't have control over those settings in their env

Re: how to enable logging, MySQL 5.0.37 FreeBSD 6.2

There is a sql log that you can enable in the config file. If you look at the config file now it will most likely only have one log file, Look at MSQL manual and logging. I dont have the setting infront of me at the moment. If you cannot find give a yell. On Wednesday 25 April 2007 10:06:1

how to enable logging, MySQL 5.0.37 FreeBSD 6.2

Hello, I am trying to debug another application and I need to enable logging of all queries (temporary only) to MySQL (5.0.37). OS is FreeBSD 6.2. MySQL installed from ports. any Instructions, or pointers to documentation would be appreciated. Thanks, Ray -- MySQL General Mailing List For li

Re: advice for blob tables?

This one time, at band camp, [EMAIL PROTECTED] wrote: > > I don't feel the implementation direction this article takes is good. It > uses single row binary storage, which anyone who has had to deal with > large files knows is a definate issue. According to your method of storing binary data in

RE: View with Subselect for User ID

Thank you for the clarification! For some reason I believed the WHERE belonged to the specific JOIN clause. I came up with a clause, but I removed the Group part, for I didn't know how to do that. I will work on that later. Would this statement be good SQL practice?

Re: Stopping Replication

Thanks, I've removed these files. Also, there are a BUNCH of files named "webserver2-relay-bin.{some#}" in the data folder. Can I delete all of these (including the .index file)? Thanks, Jesse - Original Message - From: "Brown, Charles" <[EMAIL PROTECTED]> To: "Michael Dykman" <[EM

Re: what kind of indices to set up

What do you guys think of this approach... Always query on all 5 columns...and then create a multicolumn index using all 5 columns? -James On Apr 24, 2007, at 11:42 AM, James Tu wrote: Thanks Mike. So let's say I have in index on each of the columns below...and I do a search for make

RE: Stopping Replication

(Read ref manual: 6.4) Here's the best kept secret: The Slave has two files called master. info and relay-log.info. The slave uses these two files to keep track of how much of the master's binary log it has processed and all pertinent info about the master( i.e userid, password, hostname) are all

Re: Stopping Replication

you mill also do well to eliminate the master.nfo file from your data directory. On 4/24/07, Gerald L. Clark <[EMAIL PROTECTED]> wrote: Jesse wrote: > I'm trying to stop replication between two servers that I've got here. > I set it up originally, to play with it and see how it works. However,

Re: Stopping Replication

Jesse wrote: I'm trying to stop replication between two servers that I've got here. I set it up originally, to play with it and see how it works. However, I now want to use these two servers separately. I have edited the my.ini file on both the server and slave machines, and removed the ser

Re: Query question

Can you post your table definitions and some sample data. Also what is the end requirement - how should the end result look like? Anoop On 4/23/07, Clyde Lewis <[EMAIL PROTECTED]> wrote: Guys, I have the following table that contains some information about a cars. I'm trying to write a query

RE: Fields seem to be mis-wired (for lack of a better term)

On Tuesday, April 24, 2007 10:12 AM Jim Winstead said: >> AND `type` = 0 >> AND `manager_id` = 0 >> AND `modified` = NOW() >> WHERE `id` = 5 > > you can't use 'AND' to connect your updates, you need to use commas: > > UPDATE users SET name = 'First Las

Re: Fields seem to be mis-wired (for lack of a better term)

On Tue, Apr 24, 2007 at 10:03:58AM -0700, Chris W. Parker wrote: > UPDATE `users` > SET `name` = 'First Last' > AND `email` = '[EMAIL PROTECTED]' > AND `balance` = 0 > AND `accrual` = 14400 > AND `is_manager` = 1 > AND `is_superadmin` = 1 > AND `type` = 0 >

Fields seem to be mis-wired (for lack of a better term)

Hello, I'm having a problem when trying to update a record. I'm trying to set a field called 'balance' to 0 but instead of 'balance' becoming 0 the field 'name' becomes 0. None of the other columns are updated incorrectly. Here's the SQL statement I'm using: UPDATE `users` SET `name` = 'First

Re: View with Subselect for User ID

Hello Andreas, >I tried the following statement: > >CREATE OR REPLACE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL >SECURITY DEFINER VIEW `shared_v` AS SELECT `shared`.`ID` AS >`ID`,`shared`.`RawID` AS `RawID`,`shared`.`OwnerID` AS >`OwnerID`,`shared`.`UserID` AS `UserID`,`shared`.`GroupI

Re: what kind of indices to set up

Thanks Mike. So let's say I have in index on each of the columns below...and I do a search for make=5 model=2 body_color=7 tire_type=11 hub_caps_type=1 MySQL will only pick one of them right? Let's say it picks make_index. Then what does it do? Does it scan the entire set of results retur

RE: View with Subselect for User ID

Hello Christian, Thank you very much for this reply. It was very helpful, and the user matching part works as it should. Is there any way to JOIN on two tables, so I can match the Users.GroupID field against a JOIN on Groups.ID? Also, I tried adding a WHERE clause after the join to compare Users.

Stopping Replication

I'm trying to stop replication between two servers that I've got here. I set it up originally, to play with it and see how it works. However, I now want to use these two servers separately. I have edited the my.ini file on both the server and slave machines, and removed the server-id from th

Re: Possible Replication Issue?

Brown, Charles wrote: Mysql Replication is not scope to one database. Rather it was intended for the entire instance. The slave reads its master's transaction log and applies those changes. Before it applies the changes, it will query the master just to make sure the values are the same -- meanin

Re: Possible Replication Issue?

Hi Jesse, Jesse wrote: I'm running MySQL version 5.0.22-community-nt on a Windows 2003 server. I a noticing A LOT of errors in there like the following: C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\nfcamp\societies.frm' This spans multiple databa

Re: Symbol resolution failed for /usr/local/lib/libz.so.

Hi Suresh, you are showing an enormous confidence in the working of our crystal balls - but they wear out under such stress: suresh kumar wrote: Hi, Warm Greetings! I am using C & mysql for my program In AIX and while compiling I am getting the following error. “exec(): 0509

Mysql "create and drop" permission problem

Dear all, I create a database called "test_aaa" to a user. And give him a permission to create and drop on this database. But I found he can create a database called "test-aaa" by his own. Can MySQL identify this problem? Also, can I limit user can only drop table in test_aaa but CAN NOT "drop dat

Possible Replication Issue?

I'm running MySQL version 5.0.22-community-nt on a Windows 2003 server. I a noticing A LOT of errors in there like the following: C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\nfcamp\societies.frm' This spans multiple databases and tables. I am using

Re: View with Subselect for User ID

On 4/23/07, Andreas Iwanowski <[EMAIL PROTECTED]> wrote: Hello MySQL experts, I am trying to create a view whose access is based on a User ID that need to be looked up in a different table. Here is an example of what I'm trying to do: CREATE OR REPLACE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL