scheduling tasks within MySQL

I'm fairly new to mysql. I have need for certain actions to occur within a database at a certain time every month. What is the best way to go about doing this? Is there a way to schedule these actions from within mysql? Thanks jeff

Re: I'm having trouble with End-Of-Record markers

Since you told it to end each line with *END* , the carriage return after the *END* is part of the first field of the next line. Try terminated by *END*\r David Ayliffe wrote: I'm having trouble bulk-loading data into a table. I have a file which contains: AYL01ôAYL01-1ôChloeô1979-12-1

RE: command mysql -u $user without typing it ????

I was doing a flush privileges. but this was coming up with the same thing no rows affected which to me was concerning. I have now got 1 user working but 1 user not. I am going to delete all users and start again with the users, as at the start I was not doing flush privileges and I was also

RE: Random Select Statement - help please

Easier method: SELECT * FROM people ORDER BY RAND() LIMIT 1; -Original Message- From: David V. Edelstein [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 1:08 PM To: 'Roger Baklund' Cc: '[EMAIL PROTECTED]' Subject: Random Select Statement - help please Hi Roger, Thanks

Re: InnoDB : Lock wait timeout exceeded; Try restarting transaction

Heikki, Hmm. That's interesting. So if you do a single command, say INSERT INTO Table1 (X, Y, Z) VALUES ( A, B, C) ; You actually need to write (I'm not sure of the exact transactional syntax for Mysql) - BEGIN ; --begin a transaction INSERT INTO Table1 (X, Y, Z) VALUES ( A, B, C) ; COMMIT ;

Re: INSERTing into joined tables?

On Wednesday, January 9, 2002, at 03:06 PM, Rick Emery wrote: First, you are describing a one-to-many relationship, bceasue one file record can be referenced by many people records. If this is the case, you may wish to re-design your tablse such that a people record contains a file_id

Re: InnoDB : Lock wait timeout exceeded; Try restarting transaction

John, MySQL runs by default in the auto-commit mode. In the auto-commit mode you do not need to write the COMMIT after each statement. But if you do SET AUTOCOMMIT=0, then you have to call commit explicitly. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at

RE: How Query and Fetch work?

Not knowing the exact internals of how it works... Assuming that it works much the same way other RDB's work in their native GL's (generation languages), the common practice with a relational database is to define/declare a cursor with the SQL statement executed against the database. After the

RE: InnoDB : Lock wait timeout exceeded; Try restarting transaction

John wrote: That's not something that is generally necessary with other RDBMSs. I disagree. I would imagine all transaction-oriented RDBMS's work this way. Oracle certainly does. You need to do an explicit commit or rollback to release the lock. (or close the cursor, etc.) Unless, of course,

RE: Complicated Query?

* Jerry Rehak I have a table with the columns names and id. I want to be able to find all names with an id of '03' that do not have other records with id values of '10','20' or '37'. Is this even possible to do? name id a 03 a 11 a 12 a 13 I want 'a' because

RE: command mysql -u $user without typing it ????

The mysql user permissions are just a table in the mysql database. Whenever you do a GRANT, you're really just doing an INSERT or UPDATE against this table. You can do SELECTs, INSERTs, UPDATEs, etc. against this table (the 'user' table), just like any other table. The only way to corrupt

primary key that doesn't autoincrement

I'm a novice at setting up a mysql database and don't know the answer to this. I usually set up my primary keys as autoincrementing ID fields. Now I need to have a primary key that isn't an autoincrementing field as I want to store the CFTOKEN and use it as the primary key. Can I not have a

RE: primary key that doesn't autoincrement

yes, you can -Original Message- From: D Woods [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 4:02 PM To: [EMAIL PROTECTED] Subject: primary key that doesn't autoincrement I'm a novice at setting up a mysql database and don't know the answer to this. I usually set up my

Re: primary key that doesn't autoincrement

In the last episode (Jan 09), D Woods said: I'm a novice at setting up a mysql database and don't know the answer to this. I usually set up my primary keys as autoincrementing ID fields. Now I need to have a primary key that isn't an autoincrementing field as I want to store the CFTOKEN and

Re: InnoDB : Lock wait timeout exceeded; Try restarting transacti on

Walt / Heikki Yes, I agree - with autocommit on, you do not need to supply COMMIT, and yes, that's the same as other RDBMSs. What I'm pointing out though is that I thought Heikki was suggesting that we need to supply the BEGIN/COMMIT for a single command even if autocommit was on, in order to

MySQL on Linux 2.4 question

Anyone else out there been playing with the new Linux 2.4 kernel? I just upgraded a test server from 2.2 to 2.4 and reran some of my InnoDB tests. The results were dramatic; updating a 600,000 row table went from 21 minutes and change to 6 minutes and change. Haven't tried 2.4 and MyISAM

Re: how do I search for a substring of a field? sql

Anyone know how to seach for a subsctring instead of the whole field? sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Re: MySQL on Linux 2.4 question

600,000 row table? what are you storing on that bad boy? - Original Message - From: Weaver, Walt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 09, 2002 2:17 PM Subject: MySQL on Linux 2.4 question Anyone else out there been playing with the new Linux 2.4 kernel?

RE: MySQL on Linux 2.4 question

Amazing! I've not had a chance to upgrade a server to 2.4 yet, though I've long imagined that the results would be similar. I imagine the biggest performance boost you received is due to the built-in multi-threading that the 2.4 kernel enjoys which is currently lacking in the 2.2 kernel.

Re: how do I search for a substring of a field? sql

Dan, you can use LIKE RLIKE and MATCH() AGAINST() If that's what you're asking. Dan wrote: Anyone know how to seach for a subsctring instead of the whole field? sql - Before posting, please check:

Re: MySQL on Linux 2.4 question

Walt, Yup, we use Innodb with 3.23.46 on Linux 2.4.2. I can't tell you whether things are better than they were on 2.2 kernels but we're updating tables just about that quickly I'd say. Largest table we have is a log table which has 50 million rows in it so far. Thanks to Innodb row locking,

Re: InnoDB : Lock wait timeout exceeded; Try restarting transaction

Hi! It is a bug if the sleeping connection is in the auto-commit mode. But we need more information of the problem. If you encounter it, please send the exact sequence of SQL commands which leads to the problem. You may also test SET AUTOCOMMIT=1 explicitly in your program. Note that LOCK

RE: 2 GB limit reached

I just found out that this is Freebsd 4.1 running v3.22.23 of mySQL. Is there an issue with v3.22 related to this? Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: InnoDB : Lock wait timeout exceeded; Try restarting transaction

Heikki, Thanks very muich for the explanation. That's an interesting question for the connection modules in Apache/PHP/DBI etc. Perhaps this is a problem with the way the connections are opened by those programs. I hadn't thought of that, so it would definitely be a good thing to test before

Re: MySQL on Linux 2.4 question

Walt, a possible reason is that fsync is much faster in Linux-2.4 than in 2.2. Check that the combined size of your log files is 50 % - 100% of the buffer pool size. Small log files cause more disk i/o and more fsyncs. The kernel 2.4.4-SMP-64GB has been very stable on our 2-way computer.

accumulating data in a compressed table

Hi, I have two tables, one with a smaller working set of data and one with all the historic data; both have exactly the same layout. I want to run a script about every month which will select the oldest data from the working set and move it into a temporary table. Than I want to add all data

Re: 2 GB limit reached

In the last episode (Jan 09), Dennis said: I just found out that this is Freebsd 4.1 running v3.22.23 of mySQL. Is there an issue with v3.22 related to this? http://www.mysql.com/doc/T/a/Table_size.html says that 3.22 was limited to 2gb or 4gb, depending on the OS. Upgrading to 3.23 will let

A difficutl query I cannot do.

I have a delimited file sent to me with students ID subjects and when they do these subjects. This file (table) looks like: ID TimeSlotSubject 215 3 Eng1 648 2 Maths2 901 4

RE: command mysql -u $user without typing it ????

I was aware of the user table as a standard table. I did a select on it and it all looked fine. Loads of Y's and % for host Yet this user still cannot connect. The only explaination is corruption. Although I am still looking at it. -Original Message- From: James Montebello

Re: INSERTing into joined tables?

So I designed my files and people tables without any direct relationship with one another, thinking to link them with the SELECT statement. What I completely forgot, up until this point, was that I would need to INSERT these records (from pre-written HTML/PHP forms), and there is no WHERE

Multi-table delete/update

Two questions regarding multi-table operations: 1) I've got multi-table delete working with a couple of BDB tables, where it's properly deleting from one or both tables, and all possibilities of the delete criteria are being exersized. After the multi-table delete command, I can 'select *' from

I'm having trouble with End-Of-Record markers

I'm having trouble bulk-loading data into a table. I have a file which contains: AYL01ôAYL01-1ôChloeô1979-12-1 0:0:0ôF*END* AYL01ôAYL01-2ôMelissaô1985-3-2 0:0:0ôF*END* AYL01ôAYL01-3ôDavidô1979-1-12 0:0:0ôM*END* COL01ôCOL01-1ôSimeonô1989-12-14 0:0:0ôF*END* DAV01ôDAV01-1ôMurialô1990-2-2

DBI and MySQL update log question

I am putting the finishing touches on a completely reworked replication server/client scheme (we cannot use MySQL's native replication for what we are doing). The whole thing is written in Perl/DBI and runs on Linux (x86). We are using various versions of MySQL, but all 3.23.x series. We

Re: A difficutl query I cannot do.

On Thu, Jan 10, 2002 at 10:24:37AM +1100, Sam Russo wrote: I have a delimited file sent to me with students ID subjects and when they do these subjects. This file (table) looks like: ID TimeSlotSubject 215 3

Re: I'm having trouble with End-Of-Record markers

At 18:21 + 1/9/02, David Ayliffe wrote: I'm having trouble bulk-loading data into a table. I have a file which contains: AYL01ôAYL01-1ôChloeô1979-12-1 0:0:0ôF*END* AYL01ôAYL01-2ôMelissaô1985-3-2 0:0:0ôF*END* AYL01ôAYL01-3ôDavidô1979-1-12 0:0:0ôM*END* COL01ôCOL01-1ôSimeonô1989-12-14

Re: DBI and MySQL update log question

At 17:23 -0800 1/9/02, Kyle Hayes wrote: I am putting the finishing touches on a completely reworked replication server/client scheme (we cannot use MySQL's native replication for what we are doing). The whole thing is written in Perl/DBI and runs on Linux (x86). We are using various versions

Re: DATES Optimization

At 9:02 -0600 1/9/02, Robert L. Yelvington wrote: Two quick qux for the gurus on the list! 1. If I needed to do date calculations based upon a TIME STAMP field, what's the most efficient way to accomplish this with respect to data types (field types...I already understand how to use the DATE

Re: scheduling tasks within MySQL

At 15:16 -0500 1/9/02, Jeffrey Lomas wrote: I'm fairly new to mysql. I have need for certain actions to occur within a database at a certain time every month. What is the best way to go about doing this? Is there a way to schedule these actions from within mysql? No. Use cron to schedule

Re: DATES Optimization

At 20:22 -0600 1/9/02, Paul DuBois wrote: At 9:02 -0600 1/9/02, Robert L. Yelvington wrote: Two quick qux for the gurus on the list! 1. If I needed to do date calculations based upon a TIME STAMP field, what's the most efficient way to accomplish this with respect to data types (field types...I

Best Practice - Allowing Access to MySQL

I have setup a database that GRANTs a specific user access to a database, which is theirs and will be their responsibility to manage. They have privileges on that database only. Using MySQLGUI they can log in and manage that database, but from the drop- down menu they also see the other

4416 Great Growth Potential 185528

OTC News Alerts' Last 3 Picks have gained 358%! Here is our next Hot Pick! Single Source Financial Services Corp. (OTCBB : SSFL) URGENT BUY AT $ .75 PER SHARE! SELL TARGET $4.50 PER SHARE! SSFL is the fastest growing, publicly-traded credit card transaction processor through its contractual

Re: 4416 Great Growth Potential 185528

On Wed, 2002-01-09 at 23:08, [EMAIL PROTECTED] wrote: OTC News Alerts' Last 3 Picks have gained 358%! Here is our next Hot Pick! Dear MySQL list, I'm afraid I've had it. I don't post often here - but I probably help on average one person a day by working directly with them in the background.

Re: 4416 Great Growth Potential 185528

Billy, Block yahoo.com mail they don't do anything about spammers abusing their services ;-) I did that and found that the spam I see dropped by 99% Billy Harvey wrote: On Wed, 2002-01-09 at 23:08, [EMAIL PROTECTED] wrote: OTC News Alerts' Last 3 Picks have gained 358%! Here is our

RE: 4416 Great Growth Potential 185528 ---Hmmm

Ok so where is database SQL Mysql in the message anywhereG Sorry there Billy but this list happens to be Very clean of Spam. I get about 190+ messages daily from different lists and the only one I can be assured to have little to no spam is this one. My poor filter works overtime on the others.

Re: [MySQL] RE: 4416 Great Growth Potential 185528 ---Hmmm

Mike wrote: Ok so where is database SQL Mysql in the message anywhereG At the end of the Disclaimer: DISCLAIMER: Certain statements. .. profiled. All information provided about the profiled companies may include information provided by outside sources, such as research

Problems with User logins.

I'm kinda new to mySQL and I set up a user (myself) and a database for myself on our webserver at work. I did the insert into into the User table and the Db table. However, when I try to log into the database I get errors. I go to my mysql path on the machine and do: ./mysql -u username -p

RE: Kylix Frustrated Me...!!!

One word ZEOS http://www.zeoslib.org/ K1 sucks on MySQL support but using ZEOS I have had no problems. K1 will run on 2.4.4 the earlier 2.4 had memory issues from what we have seen. Using both K1 and K2 on 2.2 and 2.4.4 RH boxes Cheers M:) I like to set small goals that might lead into larger

Suggestions - FullText ??

I have a simple table with A LOT of data, 2.1M rows. this is purely a development/test/learning endeavor. The table structure is: ID- auto-increment url - varchar(255) topic - varchar(255) about - tinytext Anyone use fulltext indexing under this scenario? The DB server is a P3-866

Re: Problems with User logins.

For the sweet love of god! Thanks Neil. After I wrote you that email, my head suddenly slipped out of my butt and I realized I didn't run a reload via the mysqladmin...funny..that seems to make everything work. thanks for the jolt. Neil Silvester wrote: Did you FLUSH PRIVILEGES?

RE: command mysql -u $user without typing it ????

Matt: I don't remember you saying what machine you're running mysql on. Try adding another copy of the same user only @localhost. My win32 installation requires that for a dos box. The hosting service I use doesn't seem to care as it almost seems to ignore the Host column. GRANT ALL

Interesting Problem

Hi... I have an interesting problem I don't know which way to solve. I tried posting this on the PHP site (since I'm coding with PHP and mysql) but they said I might want to try my odds here.. since they suggested I go with the mysql solution, but I'm clueless where to start. So I'll shoot it out

Re: command mysql -u $user without typing it ????

Matthew Darcy writes: I was aware of the user table as a standard table. I did a select on it and it all looked fine. Loads of Y's and % for host Yet this user still cannot connect. The only explaination is corruption. It sounds to me like you haven't removed the @localhost entry, but you

Mandrake and myisampack

I had mandrake 7.2 running on my system. It crashed and I transfered my back up files to a system running Debian 2.2. The file were db.frm db.myd db.myi. These are packed files and the mysql I am now running does not use these. What can I do?? Need help Eric.

setting root psswd on Win2K ??

Having some problems setting root password on MySQL. Can anybody help me? I've just installed MySQL 3.23.38 on a Windows 2000 server. I'm following the directions in the documenation for setting the root password: mysql -u root mysql mysqlUPDATE user mysqlSET password=password('mynewpass')

<    1   2