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
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 150
row2
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 [EMAIL PROTECTED] wrote
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
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
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:
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, 2003
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
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:
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 a
10 matches
Mail list logo