Re: mysqldumps from java program

Is it possible to setup replication so you would have another server to do backups on? Replicate the data, do whatever you want to the spare, and then delete the data from the production server. On 4/19/06, balaraju mandala <[EMAIL PROTECTED]> wrote: > > Hi Everybody, > > I need a suggestion reg

Re: need help to delete duplicates

If the ID doesn't represent anything, you can CREATE TABLE new_table SELECT DISTINCT Row1, Row2 FROM old_table And then recreate your index(es). All your autoincrement IDs will be changed. On 4/17/06, Patrick Aljord <[EMAIL PROTECTED]> wrote: > > On 4/18/06, William Fong

Re: need help to delete duplicates

Sample Data: ID-Row1-Row2 1-A-B 2-A-B Row1 and Row2 are duplicate, so you only want one. Which ID do you want? -will On 4/17/06, Patrick Aljord <[EMAIL PROTECTED]> wrote: > > hey all, > I have a table "mytable" that looks like this: > id tinyint primary key auto_increment > row1 varchar 15

Re: Specs for a dedicated MySQL server

I'm all for using what works and do not try to avoid MS (as long as it fits the requirements). However, I found out that MySQL does not work very well under load under Windows 2000. It is considerably slower than a similar configured Linux system. It may be how MySQL AB compiled the Windows binari

Re: DB design question

I was wondering if maybe your SELECTs could be optimized? Are you using an index? MySQL can handle billions of rows w/o a problem. -will Real-time Chat: irc.freenode.net -> #mysql ( http://www.mysql.com/doc/en/IRC.html ) - Original Message - From: "Julian Zottl" <[EMAIL PROTECTED]> To

Re: Choosing between VARCHAR and TEXT

Will any names or addresses exceed 255 characters? The documentation recommends to use the smallest column size possible. -will Real-time Chat: irc.freenode.net -> #mysql ( http://www.mysql.com/doc/en/IRC.html ) - Original Message - From: "Paul Fine" <[EMAIL PROTECTED]> To: <[EMAIL PRO

Re: Adding mysql to the subject line would improve clarity and ease of classification.

Wasn't this addressed already? http://lists.mysql.com/faq.php#subjectprefix -will Real-time Chat: irc.freenode.net -> #mysql ( http://www.mysql.com/doc/en/IRC.html ) - Original Message - From: "BAO RuiXian" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]> Sent: Thursday, November 20,

Re: Deleting column data & LOAD question

> what would the syntax be to delete all the data in a column for every > record but still maintain the column? In other words, I don't want to > delete the column, just the data in it. I would use an UPDATE and set it to '' or NULL, depending on your column. > Second, is there a way I can LOAD

Re: error 13

Check this out: http://www.mysql.com/doc/en/Repair.html -will - Original Message - From: "Yves Goergen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 19, 2003 11:12 AM Subject: Re: error 13 > I just received another error message I don't know what to do with: >

Re: Need Help Upgrading From 4.x to 4.x

You could either use mysqldump or just copy the data directory to a safe place. Also, if you do not need any special build flags, you should use the official MySQL binaries, either the RPM or tarball. They optimized the binaries. -will - Original Message - From: "Thomas Spahni" <[EMAIL