RE: How can I delete a block of random rows?

Are you sure you want to delete random rows, or do you (if you have sequential IDs) just want to delete every n'th row? DELETE FROM table WHERE id MOD 5 = 0 Delete every 5th row from the table assuming sequential IDs with no missing numbers. Something like that anyway. -Original Message

Re: How can I delete a block of random rows?

Daevid Vincent wrote: I have a SQL dump that I load in for testing with lots of "interesting" data. I want to now pair that down to a smaller subset, however I can't just delete from a range of ID's, as the data is sequential. I want to delete say 1000 random rows from the table. What frac

How can I delete a block of random rows?

I have a SQL dump that I load in for testing with lots of "interesting" data. I want to now pair that down to a smaller subset, however I can't just delete from a range of ID's, as the data is sequential. I want to delete say 1000 random rows from the table. ÐÆ5ÏÐ

2007 MySQL Community Survey - Got Ten Minutes to Spare?

2007 MySQL Community Survey - Bribe Included I've created a survey on SurveyMonkey that I am hoping to get a bunch of responses for. The survey will help the community team identify how (in)effectively we communicate development and other goals and also what features you, our community users,

MySQL Camp II - August 23-24 - Brooklyn, New York

=== MySQL Camp II - August 23-24 - Brooklyn, New York == The second MySQL Camp is happening August 23rd and 24th at Polytechnic University in Brooklyn, New York. Like the first MySQL Camp, this one is a *completely free*, *community-driven* event. About MySQL Camp ---

RE: MySQL in read-only mode

This will be not that easy as there is a large array of different users accessing the DBA at different time during the day/night. CL t 11:58 AM 8/3/2007, Edward Kay wrote: > -Original Message- > From: Clyde Lewis - DBA [mailto:[EMAIL PROTECTED] > Sent: 03 August 2007 16:55 > To: MySQL

Re: "segment fault" when using mysql++

wangxu wrote: actually I am using this piece of code,but I replaced fprintf to printf just to simplify the problem. Everything I said about printf() applies equally to fprintf(). The "%s" work-around suggested by Pete Harlan will work, but not for very good reasons. Again: see examples/cgi

Re: "segment fault" when using mysql++

This may be a bit off topic, but if you are making the up-front design decision to use the C++ API instead of the more entrenched C API, why would you use the printf family of functions at all? They are deprecated in C++ in favour of iosteams which avoid the kind of buffer overrun issues you are r

RE: MySQL in read-only mode

> -Original Message- > From: Clyde Lewis - DBA [mailto:[EMAIL PROTECTED] > Sent: 03 August 2007 16:55 > To: MySQL List > Subject: Re: MySQL in read-only mode > > > The idea here is to perform this change without restarting the > server. Is that possible? I know that by updating the config f

Re: MySQL in read-only mode

The idea here is to perform this change without restarting the server. Is that possible? I know that by updating the config file, then restarting will allow the database to be in read-only mode, but need to know if it is possible without restarting. Thanks, CL At 11:46 AM 8/3/2007, Clyde Lewi

MySQL in read-only mode

Is this possible with MYSQL using the innodb engine? If so, what is the command/process to make this happen. Thanks in advance, ~ Clyde Lewis Database Administrator

Mysql Crashes I/O error...

Hello everybody, I am looking for some help on my mysql server crashes. I run version 5.0.27 on Fedora 6. However, suddenly mysql server starting crashing. I revised the log and it is telling me that is having a input/output operating system error on a read operation. The error shows up like th

Release of Installation/Management script for MySQL Cluster (NDB)

Hi all, I'm releasing an installation script for installing/managing a MySQL Cluster (NDB). http://forge.mysql.com/projects/view.php?id=228 or http://www.jimdowling.info/ndbinstaller-trac/ The script enables a quick install of cluster (you should be able to install and start a localhost cluste

Re: KEEPING 3 MONTHS DATA ON SERVER AND ARCHIVE ALSO

krishna chandra prajapati wrote: Hi Sebastain, The data size is around 10 GB. Three months data will be around 600 to 700 MB. If i have deleted the data then how i will reclaim the free space as innodb storage engine is being used. Data deletion will take a lot of time. In addition to this i have

Re: KEEPING 3 MONTHS DATA ON SERVER AND ARCHIVE ALSO

Hi Sebastain, The data size is around 10 GB. Three months data will be around 600 to 700 MB. If i have deleted the data then how i will reclaim the free space as innodb storage engine is being used. Data deletion will take a lot of time. In addition to this i have to perform other task also. My ta

Re: looking for a good book for learning mysql

It's original title is core PHP programming Third Etition By Leon Atkinson It's in French (I bought it in a shop that did not sell english books) and although the translation isn't always excelent its not bad at all ! Robert Conner a écrit : What is the PHP book? Is it in English? Thanks, B

Re: KEEPING 3 MONTHS DATA ON SERVER AND ARCHIVE ALSO

krishna chandra prajapati schrieb: > Hi Sebastain, > > On my production server there is two year data. So the hard disk is nearly > 60% full. It contains user data also. On the basis of data column, i have to > keep only 3 months user data on the production server. I have to also > archive whole d

Re: KEEPING 3 MONTHS DATA ON SERVER AND ARCHIVE ALSO

Hi Sebastain, On my production server there is two year data. So the hard disk is nearly 60% full. It contains user data also. On the basis of data column, i have to keep only 3 months user data on the production server. I have to also archive whole data and move it to other system. Regards, Kris