Re: My first trigger in MySQL

Hi, I tried this : CREATE TRIGGER username_check AFTER UPDATE ON `users` FOR EACH ROW UPDATE users SET users.username = concat(users.firstname, ,users.lastname) where users.id=NEW.id; END ; But it throws the error: Can't update table 'users' in stored function/trigger because it is

Re: SAN and ibdata files

Rajan, In a SAN configuration, the lun/volume should appear just like a locally attached physical disk on your server. MySQL will not need any special configurations to access it, just poiint the datadir to the SAN disk. Regards, Scott Tanner On Mon, 2007-10-08 at 11:06 +0530, Ace wrote:

Re: SAN and ibdata files

Yes Scott! Only thing that confused and still confusing me is the following note on mysql site - *Note* It is not a good idea to configure InnoDB to use datafiles or logfiles on NFS volumes. Otherwise, the files might be locked by other processes and become unavailable for use by MySQL.

Re: do I need two tables or one will do just fine?

On table it is! :-D Thanks to all of you who helped me with my problem. -afan John Meyer wrote: Afan Pasalic wrote: hi, I have a employees table (first name, last_name, address, city, state, zip, phone,...). though, I got a requested to add additional info about people, like

Re: SAN and ibdata files

Rajan, I believe you are talking about a NAS setup, which is different from the SAN configuration I was referring to. Check out http://www.nas-san.com/differ.html for a quick comparison. With NFS volumes, your adding several layers of overhead when accessing the disks which has a drastic

Using MySQL date/time

Hello guys, I would like to get some registers on my database that are older than 90 days, and after delete it because the table is very larger: mysql select count(*) from max_ecardsent; +--+ | count(*) | +--+ | 1172330 | +--+ 1 row in set (0.01 sec) But I'm confusing

How to get sane error log behavior

I had a server crash over the weekend and discovered that I don't know as much about MySQL error logging as I thought. The error logs were empty because of FLUSH LOGS. What I learned today is if I specify the log-errors parameter in /etc/mysql/my.cnf, every time there's a FLUSH LOGS (or

Re: SAN and ibdata files

In the last episode (Oct 08), Ace said: On 10/7/07, Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (Oct 06), Ace said: You all know the size problems with ibdata and log files. We plan to move those files to SAN to have maximum storage possible. We did so with configuration

Re: Connect To Foreign Tables

On Sat, 06 Oct 2007 00:25:04 -0700, Werner Van Belle [EMAIL PROTECTED] wrote: Hello, On Friday 05 October 2007 01:11:35 James Card wrote: The application I'm working on uses MySQL 5.0.41 and we also need to retrieve some data from a SQL-Server database in another department. SQL-Server

2008 conference fee?

stupid non-technical ?: does anyone know what the registration fee is going to be for the 2008 conference? my mgr needs a # today to put in next yr's budget I couldn't find it on the conference site. if it's not been finalized could someone tell me what it was last year? thx!

Problem with repeated replication corruption - Could not parse relay log event entry

I've been having trouble with my master/slave server - recently I was having a few repeated issues where the mysql slave would stop due to invalid sql syntax, but the queries executed fine on the master. I would have to manually dig through the logs and then find the query to manually execute

Re: Problem with repeated replication corruption - Could not parse relay log event entry

Frank, Frank Bottone wrote: I've been having trouble with my master/slave server - recently I was having a few repeated issues where the mysql slave would stop due to invalid sql syntax, but the queries executed fine on the master. I would have to manually dig through the logs and then find

Re: Problem with repeated replication corruption - Could not parse relay log event entry

Baron, Thanks for the quick response. I do have the binlogs still on the master, so I should be able to do that - however I saw a post somewhere (lost the link at this time) saying that resetting the slave will drop any temporary tables which could cause issues. I'm not sure at this point if

RE: Problem with repeated replication corruption - Could not parse relay log event entry

Frank- I've had the exact same issue crop up in our prod servers - it was very frustrating, as it was intermittent and would affect some of our slaves, but not all. We had a lot of back and forth with MySQL support without really being able to consistently pin down or reproduce the issue.

Re: 2008 conference fee?

Sid Lane wrote: stupid non-technical ?: does anyone know what the registration fee is going to be for the 2008 conference? my mgr needs a # today to put in next yr's budget I couldn't find it on the conference site. if it's not been finalized could someone tell me what it was last year?