Query timeouts on Solaris

I'm using MySQL++ as a wrapper around the MySQL C API. When I suspend the database, using kill -SIGSTOP, the executing write query does not timeout as expected. The read/write timeout has been set to 1 second. It looks like timeouts work on Red Hat Enterprise Linux 4 (compiler g++ (GCC)

Problem creating a Trigger

Hi all, When I am trying to create a trigger I get an error message which I am unable to comprehend. create trigger updatepricech after insert on tbl_prices for each row BEGIN DECLARE closep INTEGER; select close into closep from temptable where Ticker = new.Ticker; update tbl_prices set

changes in tables (developemnt - production)

hi, on production server, while developing, I did some changes on some tables (I added few new columns on several tables). now, after the new web app is finished and tested, I have to upgrade (php) the app on production server. what steps do you recommend to do the tables update on the

RE: changes in tables (developemnt - production)

what steps do you recommend to do the tables update on the production database? When I work on our site DB, I follow the following steps: 1. Trash the existing dev DB and replace with the current live version 2. Develop! 3. Dump all the tables I have changed (structure and/or data) using

Re: Problem creating a Trigger

Did you remember to switch your SQL delimiter ? MySQL default delimter for SQL is the semicolon ( ; ) MySQL's stored procedure language also uses the semicolon to delimter statements. These two rules cannot peacefully coexist. You can get around this in three steps: 1)

Re: Problem creating a Trigger

Hi, Thank you so much for the prompt response. Those comments were good to be kept in mind always. I actually realised the mistake I was making as soon as I posted the problem here. So I managed the solve the problem. However I have another problem which I need your ideas. I have a table where

Re: Problem creating a Trigger

Hi, However I have another problem which I need your ideas. It's better to create a new thread when you want to discuss a new problem. I have a table where prices for a few stock tickers are inserted. I have another temp table which holds the prices for the max trade date. I have a trigger

mysql restore db error ?

hello , am a myql newbie , i am trying to restore a mysql database using phpmyadmin but i keep on getting this error : Error SQL query: TRUNCATE TABLE jamroom_band_fan_invites; MySQL said: #1146 - Table 'db_jamroom.jamroom_band_fan_invites' doesn't exist i used the jamroom in built

Re: mysql restore db error ?

If the dumps was from a single table you probably need to create the table before restoring the data from the dump olaf On 9/6/07 11:12 AM, 2 Logic Studios [EMAIL PROTECTED] wrote: hello , am a myql newbie , i am trying to restore a mysql database using phpmyadmin but i keep on getting

Use of slave server for read only queries

Hi All, I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB of RAM. Master Slave servers have same hardware configration. Now i want to know, should i use slave server for fetching read only queries. if yes, then how ?. Thanks Ashok -- MySQL General Mailing List For