Replication among disconnected Servers

Hi All, We have a MySQL 5.0 server (master) running on Windows. For backup, I wish to setup another system with same version of MySQL to act as backup / slave. But this slave can not have direct access to the master. Is there a way I can achive this? I do not wish to take a full dump in maste

test - please ignore

RE: Privileges question.

Nevermind, I had a lingering entry in the db table. Once I deleted that it worked as expected. Denise Lopez UCLA Center for Digital Humanities Network Services Systems Engineer 337 Charles E. Young Drive East PPB 1020 Los Angeles, CA 90095 310/206-8216 -Original Message- From: Lopez, Deni

Privileges question.

Hi all, I am trying to create a user with only SELECT,INSERT,UPDATE,DELETE privileges on a database. My question is when I type show grants for the user I create, it says the user has full privileges over the database and I only want them to have the ones listed above. mysql > grant SELECT,INSER

Re: Poor performance with WHERE Value like 'XXX%'

Rod, I'm speculating here, but I think what's happening is that too many of your entries have a PRODUCT_ID that starts with 'DRM' to make your index useful. When MySQL expects an index query to match more than around 30% of all rows, it will instead proceed with a table scan, estimating that to b

Poor performance with WHERE Value like 'XXX%'

Hi Folks, I'm getting some unexpectedly poor performance from some queries using the like operator. The table is an Innodb table with an index on the column appearing in a like conditional. Explain gives me this: [localhost]>explain select PRODUCT_ID from My_Table where PRODUCT_ID like 'DRM_00

[Q] encoding cast

Hello there, I have the following problem, I open a terminal on the mysql server with "set names utf8". I have the following string: _latin1"φου" (this is a greek word), how can i get back the utf sting? I tried various combinations using convert and cast but i can't get it to work.. e.x.

RE: return integer for positive values

Are you trying to get a 1 or 0 depending upon whether or not there is an AQ_ record that matches? If so, then you could use a LEFT JOIN and an IF(ISNULL(AQ_.SITEID),0,1) or something like that. I probably don't understand your query. Regards, Jerry Schwartz Global Information Incorporated 195 Fa

Re: return integer for positive values

<[EMAIL PROTECTED]> wrote on 04/05/2007 02:46:43 PM: > > I have a table with a list of pollutants. I have a table of > locations, site names, counties, etc. I can join the these tables > together and get a list of of all the pollutants at a site. But, > what I am really wanting is a list of

RE: return integer for positive values

I am at a higher level than that. Here is my query: SELECT distinct emt.group_name FROM epa.aq_ambient_nad83 aq_, epa.aq_ambient_pollutants pol, epa.emtb_pollutant_group emt, epa.pollutant pt WHERE (aq_.siteid = pol.siteid) AND (emt.group_code = pt.ambient_group_code) AND (pol.paramcode

RE: return integer for positive values

I'm not sure I quite follow. Is there a concentration for each location for each of a master list of pollutants? What concentration would be considered "not there"? In any case, look at a construct like (ABS(concentration) <= ), where -Original Message- > From: [EMAIL PROTECTED] [mailto:[

return integer for positive values

I have a table with a list of pollutants. I have a table of locations, site names, counties, etc. I can join the these tables together and get a list of of all the pollutants at a site. But, what I am really wanting is a list of all the pollutants with a integer field, zero for pollutant not

re: append information

Use the CONCAT() function to achieve this: UPDATE tmpTable SET Textarea = concat(Textarea,'data you wish to add') WHERE ID = someID HTH! From: sam rumaizan <[EMAIL PROTECTED]> Sent: Thursday, April 05, 20

append information

I have a question if you don't mind. The update statement will replace the existing information. What if I have Textarea instead and I want to add information to the field without erasing previous information. Basically append information - Looki

MySQL slave error when creating view

I ran the following DDL on our master today: CREATE OR REPLACE VIEW REF_TRANSFER_PREFERENCE ( IORG_UID, TDISTRICT_NAME, IORGDISPLAY, IORG ) AS SELECT 0, TDISTRICT_NAME, IORG_UID, IORG_UID FROM REF_PREFERENCE ; The master happily created the view. The slave however dies with: 07

RE: 5.0.37 ,sql a table still not found

in mysql doc you could find a better answer of your problem (http://dev.mysql.com/doc/refman/5.0/en/join.html) have a look on the part "Join Processing Changes in MySQL 5.0.12" but that you have to do is use implicit joins: select * from a1 inner join a2 on a1.f2=a2.f2 left jo

RE: Problem with authentication

have a look on this: http://dev.mysql.com/doc/refman/5.0/en/old-client.html it is because your php is using old mysql libraries, upgrade your php or consult that page... Regards! -Original Message- From: John Meyer [mailto:[EMAIL PROTECTED] Sent: Miércoles, 04 de Abril de 2007 07:16

Re: ./mysql/proc' is marked as crashed and should be repaired

Hi All, We fixed it using mysqlcheck --repair mysql proc -u root -pxxx On 4/5/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: Hi Friends, I am getting "./mysql/proc' is marked as crashed and should be repaired" on dev db, please let me know, how can i fix this. This is not allowing any action on

./mysql/proc' is marked as crashed and should be repaired

Hi Friends, I am getting "./mysql/proc' is marked as crashed and should be repaired" on dev db, please let me know, how can i fix this. This is not allowing any action on stored procs. regards anandkl

view problem

Hello, I'm having some problems with views. Could please someone give me some help? I created two tables and a view. I created the view using WITH CASCADED CHECK OPTION because I need to update some columns of the view. When I do update 2007_marche set data_invio_teramo = current_date where azi