MySQL Talk Archive at ListSearch

Re: Table Structure

Fri, 16 May 2008 10:18:42 -0400

Kevin Hunter to MySQL Talk on 2008-05-16 10:18:42 - At 5:32a -0400 on Fri, 16 May 2008, Ananda Kumar wrote: >>> 2 Index would do range scan, which would be comparitivly slower. >> >> Not exactly. This, again, depends on implementation and the >> data against which queries are run. An index is an inde...

Re: master - slave replication - slave not updating

Fri, 16 May 2008 10:17:45 -0400

Juan Eduardo Moreno to MySQL Talk on 2008-05-16 10:17:45 - Hi Tom, Your master binary log start with mysql-bin.000003, then, your insert ( or update) in the master could be in mysql-bin.000002 or 1. Please, reload your binary logs again from the beginning ( put mysql-bin.000002 or 1, ). Your insert or up...

RE: Slave Server

Fri, 16 May 2008 10:11:00 -0400

Jerry Schwartz to MySQL Talk on 2008-05-16 10:11:00 - >-----Original Message----- >From: Shanmugam, Dhandapani [mailto:dhandapani.shanmugam@eds.com] >Sent: Friday, May 16, 2008 4:01 AM >To: Phani; Ananda Kumar >Cc: replication@lists.mysql.com; mysql@lists.mysql.com >Subject: RE: Slave Server > > >Ok....

Replication advise

Fri, 16 May 2008 09:44:15 -0400

Ben Clewett to MySQL Talk on 2008-05-16 09:44:15 - Dear MySql, Hope somebody might give some advise about replication! On 5.1.24, I have something simple like: CREATE TABLE big f er ( id BIGINT UNSINGED NOT NULL AUTO INCREMENT, t TIMESTAMP NULL NOT NULL, PRIMARY KEY (id, t), KEY (...

Re: master - slave replication - slave not updating

Fri, 16 May 2008 09:09:58 -0400

Tom Brown to MySQL Talk on 2008-05-16 09:09:58 - > > Yes thanks - i have done that and restarted the slave and some > tables now appear to update but others dont > > eg > > master: > mysql> select count(*) from tbl checkcommand; > +----------+ > | count(*) | > +----------+ > | 30 | ...

Re: master - slave replication - slave not updating

Fri, 16 May 2008 08:40:12 -0400

Tom Brown to MySQL Talk on 2008-05-16 08:40:12 - > > The error 1062 you could skipped in the slave modifying your my.cnf ( slave > side) using : > > slave-skip-errors 1062 > > This error on duplicated records, normally is problem in binarylogs transfer > data. But, anyway, please confer that th...

Re: master - slave replication - slave not updating

Fri, 16 May 2008 08:37:02 -0400

Juan Eduardo Moreno to MySQL Talk on 2008-05-16 08:37:02 - Hi Tom, The error 1062 you could skipped in the slave modifying your my.cnf ( slave side) using : slave-skip-errors 1062 This error on duplicated records, normally is problem in binarylogs transfer data. But, anyway, please confer that the da...

master - slave replication - slave not updating

Fri, 16 May 2008 07:40:10 -0400

Tom Brown to MySQL Talk on 2008-05-16 07:40:10 - Hi I am running 4.1.20 as this is the stock version in RHEL4 u5 and i have setup a master/slave combination. Updates at first appeared to work as creating and inserting into the master created the db's on the slave etc. I have noticed however tha...

Re: Slave Server

Fri, 16 May 2008 06:19:01 -0400

Ananda Kumar to MySQL Talk on 2008-05-16 06:19:01 - or what u can do is create a new set of databases on slave and dump all the data from the master into it and ask your developers to test there, in this case, you can have both your master and slave in sync. The new set of databases u create on slave...

Re: Slave Server

Fri, 16 May 2008 06:10:52 -0400

Ananda Kumar to MySQL Talk on 2008-05-16 06:10:52 - Hi Shanmugam, If its a simple master, slave replication, any changes on SLAVE will not be replicated to master. If its a circular replication any change on master will be done on slave and any changes on slave will be done on master. So you need to pi...

Re: Table Structure

Fri, 16 May 2008 05:32:34 -0400

Ananda Kumar to MySQL Talk on 2008-05-16 05:32:34 - Hi Kevin, > 2 Index would do range scan, which would be comparitivly slower. Not exactly. This, again, depends on implementation and the data against which queries are run. An index is an index. Remember, a primary key is implemented by the MyS...

Re: Table Structure

Fri, 16 May 2008 05:00:29 -0400

Kevin Hunter to MySQL Talk on 2008-05-16 05:00:29 - At 2:49a -0400 on Fri, 16 May 2008, Ananda Kumar wrote: > it goes without saying Eh, not to those who don't know. Hence the list and question. :-D Krishna, the short answer is that it depends on your data, and the queries against it that you run...

Re: migration from 4.0 to 5.0

Fri, 16 May 2008 04:29:06 -0400

MarisRuskulis to MySQL Talk on 2008-05-16 04:29:06 - Found partial sollution! Need to specify mysql query("SET NAMES 'latin1'"); for connection charset. MarisRuskulis wrote: > Hello! > I'm trying to migrate database from mysql 4.0 to 5.0 (latin1). So I > maked dump from 4.0 and then restored it to 5....

RE: Slave Server

Fri, 16 May 2008 04:01:22 -0400

Shanmugam, Dhandapani to MySQL Talk on 2008-05-16 04:01:22 - Ok..But if I do any changes on slave databases for testing it will affect Master server also right...I don't want that to happen.. After my testing on the slave database I need to revert back the databases as of master Thanks and Regards, DD ...

RE: Slave Server

Fri, 16 May 2008 03:54:46 -0400

Phani to MySQL Talk on 2008-05-16 03:54:46 - You can try circular replication between server. So each server will act as both Master and Slave. Regards, Phani | Business Analyst zetainteractive Road No 12, Banjara Hills, Hyderabad, AP 500034 T +91 40 23390080 | Ext: 337 | F +91 40 233909...

migration from 4.0 to 5.0

Fri, 16 May 2008 03:54:47 -0400

MarisRuskulis to MySQL Talk on 2008-05-16 03:54:47 - Hello! I'm trying to migrate database from mysql 4.0 to 5.0 (latin1). So I maked dump from 4.0 and then restored it to 5.0, but without success because inside the web symbols isnt correct. On mysql 5.0 database charset is latin1 and "SHOW TABLE STATUS...

Re: Floor Decimal Math

Fri, 16 May 2008 03:42:51 -0400

Adam de Zoete to MySQL Talk on 2008-05-16 03:42:51 - Thanks for your responses, i thought it was a float problem so i was trying to CAST as a DECIMAL to fix it. It turns out (and the manual does not document this) that casting as decimals doesn't actually work in mysql 4.1.20. ROUND() is needed instea...

RE: Slave Server

Fri, 16 May 2008 03:36:57 -0400

Shanmugam, Dhandapani to MySQL Talk on 2008-05-16 03:36:57 - No Anand..My question is ..If the developer do any changes on the slave server, it will not get reflected to the Master server right? So there will be data inconsistency. My requirement is When the developer do any testing on slave databases. I need to...

Re: Slave Server

Fri, 16 May 2008 03:30:27 -0400

Ananda Kumar to MySQL Talk on 2008-05-16 03:30:27 - Hi Shanmugam, Your question quite confusing. Do you mean to say, if any changes happen to slave it should get refeleted in the master, if yes, then u can setup two masters which are slave to each other. regards anandkl On 5/16/08, Shanmugam, ...

Slave Server

Fri, 16 May 2008 03:14:13 -0400

Shanmugam, Dhandapani to MySQL Talk on 2008-05-16 03:14:13 - Hi There, I am setting up a replication with one master and one slave. I have created two databases in Master Server and it gets replicated to the slave. When developer do changes on the slave database, It will not be sync with the Master server. M...

Re: Table Structure

Fri, 16 May 2008 02:49:43 -0400

Ananda Kumar to MySQL Talk on 2008-05-16 02:49:43 - it goes without saying 1. primary key and unique key would do unique scan which is fastest of all scan 2 Index would do range scan, which would be comparitivly slower. regards anandkl On 5/16/08, Krishna Chandra Prajapati

Re: Table Structure

Fri, 16 May 2008 02:02:44 -0400

Krishna Chandra Prajapati to MySQL Talk on 2008-05-16 02:02:44 - Hi, I would like to know which is faster out of the below. Primary Key Unique Key Indexing Give the numbering 1, 2 and 3 Thanks a lot On Thu, May 15, 2008 at 5:49 PM, Ananda Kumar wrote: > If both (user id,delivery id...

[Fwd: GRANT/REVOKE deny only 1 table in db from a user]

Thu, 15 May 2008 21:07:48 -0400

Philip M. Gollucci to MySQL Talk on 2008-05-15 21:07:48 - [take 2] -- ------------------------------------------------------------------------ Philip M. Gollucci (philip@ridecharge.com) o:703.549.2050x206 Senior System Admin - Riderway, Inc. http://riderway.com / http://ridecharge.com 1024D/DB9B8C1C B9...

Re: Site Attack/Failure Recovery

Thu, 15 May 2008 19:42:26 -0400

John Comerford to MySQL Talk on 2008-05-15 19:42:26 - I have worked as a DBA for a long time, just not with MySQL and I have spent a lot of time making sure the application is secure. I suppose my question was really what is the best way to do incremental backups? The DB I have most experience with h...

Re: reorder records in database

Thu, 15 May 2008 19:04:39 -0400

Rob Wultsch to MySQL Talk on 2008-05-15 19:04:39 - On Thu, May 15, 2008 at 4:32 PM, C.R.Vegelin wrote: > What about: > "ALTER TABLE > ORDER BY ;" > > HTH, Cor First off, please don't top post if a conversation is not already top posting. It is the cus...

Re: reorder records in database

Thu, 15 May 2008 19:32:17 -0400

C.R.Vegelin to MySQL Talk on 2008-05-15 19:32:17 - What about: "ALTER TABLE ORDER BY ;" HTH, Cor ----- Original Message ----- From: "Rob Wultsch" To: "afan pasalic" Cc: Sent: Thursday, May 15, 2008 8:23 PM S...

Re: reorder records in database

Thu, 15 May 2008 15:23:48 -0400

Rob Wultsch to MySQL Talk on 2008-05-15 15:23:48 - On Thu, May 15, 2008 at 11:38 AM, afan pasalic wrote: > is there built in function to "reset" order no or I have to create php > script for it? There is not a built in way to do this. Using a user defined variable it is not all that ...

Re: Trigger problem

Thu, 15 May 2008 15:01:31 -0400

Rob Wultsch to MySQL Talk on 2008-05-15 15:01:31 - On Thu, May 15, 2008 at 2:30 AM, rustam ershtukaev wrote: > I have been trying to write a trigger in mysql, but can't get it to > work. It's really simple,i just need my trigger to add varchar value to > a table on insert if post...

reorder records in database

Thu, 15 May 2008 14:38:32 -0400

afan pasalic to MySQL Talk on 2008-05-15 14:38:32 - hi, I have a table with tasks. column "status" could be 1 (means "todo") and 0 (meas "done"). also,have column "order no" to sort tasks by priorities. once in a while order no is not "in order", e.g 1, 2, 3, 5, 6, 8, 11, 12, 13, 19, 20,... (some numb...

Res: MySQL purge logs

Thu, 15 May 2008 12:32:05 -0400

Wagner Bianchi to MySQL Talk on 2008-05-15 12:32:05 - mysql> reset master; Wagner Bianchi Diretor de Tecnologia - INFODBA C&T wagnerbianchi@infodba.com.br - (31) 3272 - 0226 / 9114 - 7695 ----- Mensagem original ---- De: Kaushal Shriyan Para: mysql@lists.mysql.com Cc: repl...

Res: Table Locking (Was: Best CPU config for a busy DB server)

Thu, 15 May 2008 12:30:36 -0400

Wagner Bianchi to MySQL Talk on 2008-05-15 12:30:36 - Locking will ocours with MyISAM tables when INSERT, UPDATE, DELETE or REPLACE statemats arrive that tables, lock at the table level. In INNODB engine, a lock ocours at the row-level. BDB have lock at the page-level. Wagner Bianchi Diretor de Tecnolog...

RE: Floor Decimal Math

Thu, 15 May 2008 11:32:48 -0400

John Trammell to MySQL Talk on 2008-05-15 11:32:48 - > -----Original Message----- > From: Adam de Zoete [mailto:adam.dezoete@googlemail.com] On Behalf Of > Adam de Zoete > Sent: Thursday, May 15, 2008 6:24 AM > To: mysql@lists.mysql.com > Subject: Floor Decimal Math > > Hi, > > I'm running mysql 4....

RE: Floor Decimal Math

Thu, 15 May 2008 10:11:31 -0400

Jerry Schwartz to MySQL Talk on 2008-05-15 10:11:31 - Don't feel bad, many an experience programmer has been bitten by this. The problem is that many decimal fractions do not have exact representations as binary fractions. .01 is an example of this. I'm not sure how MySQL does arithmetic internally, b...

Re: Table Structure

Thu, 15 May 2008 08:19:20 -0400

Ananda Kumar to MySQL Talk on 2008-05-15 08:19:20 - If both (user id,delivery id) can be made primary key, then the second index would not be required. But the performance of the query would be better if it reads one index rather than indexes on each COLUMN in the "WHERE CLAUSE" On 5/15/08, Krishna Ch...

Re: Floor Decimal Math

Thu, 15 May 2008 08:15:23 -0400

wim.delvaux to MySQL Talk on 2008-05-15 08:15:23 - On Thursday 15 May 2008 13:24:10 Adam de Zoete wrote: > Hi, > > I'm running mysql 4.1.20 (Mac OS 10.4.11) and wondering why this ain't > returning the right answer? Maybe i'm missing something or am i doing > something wrong? Perhaps it is perform...

Floor Decimal Math

Thu, 15 May 2008 07:24:10 -0400

Adam de Zoete to MySQL Talk on 2008-05-15 07:24:10 - Hi, I'm running mysql 4.1.20 (Mac OS 10.4.11) and wondering why this ain't returning the right answer? Maybe i'm missing something or am i doing something wrong? mysql> select (11.11-FLOOR(11.11))> 0.11; +----------------------------+ | (11.11...

RE: replace chr(10) in field

Thu, 15 May 2008 06:33:55 -0400

Neil Tompkins to MySQL Talk on 2008-05-15 06:33:55 - I've overcome the problem by using a RichText memo box. Thanks for your help in any case. Neil > From: neildtompkins@hotmail.com> To: gclark@suppliersystems.com> CC: mysql@lists.mysql.com> Subject: RE: replace chr(10) in field> Date: Wed, 14 M...

Trigger problem

Thu, 15 May 2008 05:30:02 -0400

rustam ershtukaev to MySQL Talk on 2008-05-15 05:30:02 - I have been trying to write a trigger in mysql, but can't get it to work. It's really simple,i just need my trigger to add varchar value to a table on insert if postcode 1000. this is how i did it: delimiter | drop trigger testdep| create trig...

Re: Site Attack/Failure Recovery

Thu, 15 May 2008 03:29:59 -0400

Rob Wultsch to MySQL Talk on 2008-05-15 03:29:59 - On Wed, May 14, 2008 at 11:13 PM, John Comerford wrote: > Quickly scanning this page, it doesn't seem to give syntax for an > incremental backup. I am hoping to be able to run something that dumps only > data changed sinc...

Problem with install DBD

Thu, 15 May 2008 03:16:02 -0400

Stefano Elmopi to MySQL Talk on 2008-05-15 03:16:02 - Hi, I have installed MySQL on an Opteron 64bit with operating system Scientific Linux CERN SLC release 4.6 (Beryllium) by an archive TAR, under the directory /opt/local/mysql50. The problem is that I want to install drivers DBD to use MySQLBenchmar...

Re: Site Attack/Failure Recovery

Thu, 15 May 2008 02:13:41 -0400

John Comerford to MySQL Talk on 2008-05-15 02:13:41 - Quickly scanning this page, it doesn't seem to give syntax for an incremental backup. I am hoping to be able to run something that dumps only data changed since the last backup. Rob Wultsch wrote: > On Wed, May 14, 2008 at 10:25 PM, John Come...

Re: Site Attack/Failure Recovery

Thu, 15 May 2008 01:38:20 -0400

Rob Wultsch to MySQL Talk on 2008-05-15 01:38:20 - On Wed, May 14, 2008 at 10:25 PM, John Comerford wrote: > 2) Incremental Backups - say one every half hour, then a script to transfer > that to an off site machine that way I can get the DB back to within the > last good h...

Re: CONCAT doesn't work with NULL?

Thu, 15 May 2008 01:35:09 -0400

to MySQL Talk on 2008-05-15 01:35:09 - i execute follow sql. select concat ws('','d','\n','c'); the result is : +----------------------------+ | concat ws('','d','\n','c') | +----------------------------+ | d c | +----------------------------+ There ar...

Re: ????: RE: comparison operations in IN subquery

Thu, 15 May 2008 01:31:54 -0400

Dan Nelson to MySQL Talk on 2008-05-15 01:31:54 - In the last episode (May 15), raid fifa said: > Jerry Schwartz ????: > > look at the following test case: > > > > mysql> create table temp1( id int)ENGINE innodb; > >Query OK, 0 rows affected (0.18 sec) > > > >mysql> cr...

Site Attack/Failure Recovery

Thu, 15 May 2008 01:25:00 -0400

John Comerford to MySQL Talk on 2008-05-15 01:25:00 - Hi Folks, I am fairly new to MySQL and I am going to be setting up a web site on a third party hosting machine. I continuously hear horror stories about machines/sites being hacked and databases being destroyed. Despite my best efforts I am sur...

Re: Table Structure

Thu, 15 May 2008 00:37:43 -0400

Krishna Chandra Prajapati to MySQL Talk on 2008-05-15 00:37:43 - Hi, Since user id is a primary key. It should work either with any of the column and with both the column. Any suggestion. Thanks On Thu, May 15, 2008 at 1:22 AM, Rob Wultsch wrote: > On Tue, May 13, 2008 at 1:30 AM, Kr...

Re: CONCAT doesn't work with NULL?

Wed, 14 May 2008 17:26:23 -0400

Paul DuBois to MySQL Talk on 2008-05-14 17:26:23 - On May 14, 2008, at 10:53 AM, Afan Pasalic wrote: > hi, > > I have query > SELECT CONCAT(r.first name, ' ', r.last name, '\n', r.organization, > '\n', r.title, '\n', a.address1, '\n', a.city, ', ', a.state, ' ', > a.zip, '\n', r.email) > FROM...

Re: inserting client time instead of server time

Wed, 14 May 2008 16:19:33 -0400

Rob Wultsch to MySQL Talk on 2008-05-14 16:19:33 - On Mon, May 12, 2008 at 11:25 PM, Sebastian Mendel wrote: > Hi, > > is there a way or a function like NOW() except it returns the client time > and not the server time? > > -- > Sebastian Mendel Timezone for the clien...

Re: Timestamps replicating inconsistently depending on local timezone of server?

Wed, 14 May 2008 16:06:25 -0400

Rob Wultsch to MySQL Talk on 2008-05-14 16:06:25 - On Wed, May 14, 2008 at 12:55 PM, Ed W wrote: > Rob Wultsch wrote: >> >> This sounds like expected behavior to me. If you set the timezone one >> hour forward a timestamp will be one hour forward. The data stored on >> the serv...

Re: Timestamps replicating inconsistently depending on local timezone of server?

Wed, 14 May 2008 15:55:32 -0400

Ed W to MySQL Talk on 2008-05-14 15:55:32 - Rob Wultsch wrote: > This sounds like expected behavior to me. If you set the timezone one > hour forward a timestamp will be one hour forward. The data stored on > the server is the same, and will display the same if you change the > timezone. The ti...