Need restart mysql when time changed

I fond my mysql db os time was not correct so i sync with ntpdate ,when testing my app which depend on the date was not the current os time .After restarting Mysql ,the app goes well. All you best What we are struggling for ? The life or the life ? -- MySQL General Ma

Question on encoding parameters and binary fields encoding (character_set_connection)

Hi, I'm finding the description of character_set_connection unclear. Does this influence the encoding of queries, but not of results? I'm wondering about the effect of connection encoding. Is there documentation on how exactly character set settings affect BLOBs? For example, "this is what

Re: Update record count

On 9/16/2010 5:12 PM, Jerry Schwartz wrote: I should be able to figure this out, but I'm puzzled. Here's a simplified example: UPDATE a JOIN b ON a.kb = b.kb JOIN c ON b.kc = c.kc SET a.f1 = NOW(), b.f2 = NOW() WHERE c.f3 IN ('x', 'y', 'z') AND b.f4 = 'yen'; It seems to me that if there are

Re: filesystem or database??

On Thu, September 16, 2010 13:30, mohit verma wrote: > hello , > when we install any package the terminal shows in end " reading database" > (used by package manager like .deb or rpm). but as in linux everything is > nothing but a file. so database shown above must be a part of the > filesystem

Update record count

I should be able to figure this out, but I'm puzzled. Here's a simplified example: UPDATE a JOIN b ON a.kb = b.kb JOIN c ON b.kc = c.kc SET a.f1 = NOW(), b.f2 = NOW() WHERE c.f3 IN ('x', 'y', 'z') AND b.f4 = 'yen'; It seems to me that if there are 3 rows found in `c` that match a total of 10

Re: filesystem or database??

hello , when we install any package the terminal shows in end " reading database" (used by package manager like .deb or rpm). but as in linux everything is nothing but a file. so database shown above must be a part of the filesystem . so why we not say that " reading filesystem". what differs and

RE: Update query problem

Try using the IS NULL operator instead of ! -Travis -Original Message- From: Andy Wallace [mailto:awall...@ihouseweb.com] Sent: Thursday, September 16, 2010 10:47 AM To: mysql@lists.mysql.com Subject: Update query problem So I'm having a problem with an update query. I have three tables

Update query problem

So I'm having a problem with an update query. I have three tables: Table: A Columns: acnt, name, company, email, domain Table: AM Columns: acnt, m_id Table: M Columns: m_id, name, company, email, domain and I want to conditionally update the columns in one to values from the other. i.e.,

Re: skip locking

Hi, The first main difference is that InnoDB has transactional capabilities (all-or-nothing) and MyISAM not yet. If you need to use COMMIT on some statements, you need to use InnoDB. The second point is the locking of MyISAM, which is on table-level. If your environment is mixed with read/write co

Improve query

Hi, Regarding my query below, is there anyway in which this query can be improved ? SELECT t1.players_brought, t2.players_sold, t3.team_balance, t4.home_team_wages, t5.away_team_wages, (t3.team_balance+t2.players_sold)-(t1.players_brought+t4.home_team_wages+t5.away_team_wages) AS team_balance, t6

Re: SOLVED!!!!Re: hard disk crash: how to discover the db?

Uwe Brauer wrote: > > What I had to do in addition was to copy the ibdata1 > *then* I recovered the content of the db. > > Thanks a lot > > > Uwe Brauer > Uwe, Congratulations! That's great news! Sorry I didn't know to mention that step. Where is your 'ibdata1'? Mine is in '/var/lib/mysql' so

Re: Capitalize Input via Auto Complete?

On Wed, Sep 15, 2010 at 6:50 AM, Johan De Meersman wrote: > >> I commonly set up a tunnel to the SSH server at the office and then >> another tunnel from that server to my development rig, so I can run >> MySQL WB at home on my database at work.  Is that what you mean? >> > > Pretty much, yeah. I'

Re: skip locking

Any idea on this? -Mon From: Michael Satterwhite To: mysql@lists.mysql.com Sent: Mon, September 13, 2010 1:07:38 AM Subject: Re: skip locking Received. On Sunday, September 12, 2010 09:32:12 am monloi perez wrote: > Hi All, > > Sorry if I posted on the wr

Re: how to recover crashed db: only the db or the whole directory /var/lib/mysql

It depends on what u want to recover and type of the db engine... If u want to recover just the specifi db and if u have dump of the db, just restore the db for innodb. for myisam, u can just restore the files in that database. regards anandkl On Thu, Sep 16, 2010 at 3:27 PM, Uwe Brauer wrote:

how to recover crashed db: only the db or the whole directory /var/lib/mysql

Hello I have so far tried (unsuccessfully) to recover the database from the crashed Mac. (I am using Kubuntu 9.04) I tried 2 tactics. - shutdown the server (service mysql shutdown) copy the maqwiki folder into /var/lib/mysql restart the server. The server came up some tables