Hi,
I did something terrible similar to UPDATE table SET testdate=NOW()
And I kind of forgot the WHERE lalalala, so now all my records are screwed.
Is there any way of actually undoing this? :)
On Tuesday 22 August 2006 10:29, Peter Lauri wrote:
Hi,
I did something terrible similar to UPDATE table SET testdate=NOW()
And I kind of forgot the WHERE lalalala, so now all my records are screwed.
Is there any way of actually undoing this? :)
Backup?
--
Jørn Dahl-Stamnes
homepage:
On Tue, 22 Aug 2006, Peter Lauri wrote:
Hi,
I did something terrible similar to UPDATE table SET testdate=NOW()
And I kind of forgot the WHERE lalalala, so now all my records are screwed.
Is there any way of actually undoing this? :)
Recover from your backup.
--
Don't have any recent, or actually I do not know, because I am not in charge
of the hosting part of this, only access to upload scripts and control MySQL
via phpMyAdmin.
:(
-Original Message-
From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 22, 2006 3:33 PM
To:
Not the best start to the day, if you have a fairly recent backup and
have enabled binary logging then you can recover up to the point before
you screwed the data.
Peter Lauri wrote:
Hi,
I did something terrible similar to UPDATE table SET testdate=NOW()
And I kind of forgot the
On Tuesday 22 August 2006 10:37, Peter Lauri wrote:
Don't have any recent, or actually I do not know, because I am not in
charge of the hosting part of this, only access to upload scripts and
control MySQL via phpMyAdmin.
:(
A good backup is always a good thing. I dump my databases every
On my website I'm looking to add a search box.
I have a number of different database fields. Does anyone have any
recommendations about how I can perform a search engine type search including
the text fields.
Regards
Neil
_
Be
Neil Tompkins wrote:
I have a number of different database fields.
Does anyone have any recommendations about how I can
perform a search engine type search including the text fields.
Full-Text Search:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
cheers,
--renato
--
MySQL
Hi everyone
I have a requirement to store in the region of 3 million entries per month (30
ish days) of data in a mySQL database totalling a maximum of 2 months (6
Million entries).
The database will be 'probably' reside on a Sun V240. I have a similar size
database running on an old Sun E450
I followed the instructions, but when doing a search I get no results returned.
here is my table
CREATE TABLE /*!32300 IF NOT EXISTS*/ MyTest ( id int(10) unsigned NOT NULL
auto_increment, title varchar(200) , body text , PRIMARY KEY (id), INDEX
title (title,body));
I created FULL
Hi all,
i developed a c+ programm which uses dbx to get access to my mysqlserver.
Now I needed to change provider and so I have my own server here :-)
the old server was a 4.0.24 and now I have a 4.1.21.
the problem is: when I connect and want to access any data, I get the error
message,
Hello all,
I have a couple of questions on storage engine types wrt performance
1.. Will there be any performance degrade when we do joins with tables
having different storage engines ?
2.. Where are the temporary tables created? (by default why not memory
storage engine?) will it be
Andy, performance will generally depend on several factors:
- size of each record
- amount of RAM
- speed of disks, for when RAM isn't enough
- concurrent inserts/writes (using InnoDB or MyISAM tables?)
At one level, 6 million records is no problem, and really not even
very many. If every
On Tue, Aug 22, 2006 at 10:42:52AM +, Neil Tompkins wrote:
On my website I'm looking to add a search box.
I have a number of different database fields. Does anyone have any
recommendations about how I can perform a search engine type search including
the text fields.
Have you
Sorry for the double post - I intended to mention this, but forgot.
For your automatic summary generation you could consider a cron job
piping in SQL, a la
*/3 * * * * mysql -D databaseName -e insert into summaryTable select
now(), sum(numberColumn) from liveTable where datestamp date_sub(
Jürgen, not sure if this would be it, but password handling changed
somewhat with MySQL 4.1. From your error msg it seems doubtful, but
thought I'd mention it.
http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html
Dan
On 8/22/06, Jürgen Ladstätter [EMAIL PROTECTED] wrote:
Hi all,
Hi Dan,
first of all thanks for your reply, but i already changed the password to
the old_style password, otherwise i wouldnt be able to connect and
authenticate at all!
But there must be anything else :-/
I dont think that I need to write a new MySQL component to talk with my
server, or let the
Hey everybody,
i´m becoming desperate about the following problem.
We´ve an online-community / network.
There´s a network table ( sql create below ), in which we store the
relationships between the member.
I need a SQL-statement or a PHP-Function to calculate the 2nd, 3rd and
4th degrees
I use something like this in my e-commerce for degrees of my category of
products. I think it´s the same thing you want.
I get everything to an array and then use it to work.
By this follow function, i get all options for my select field, it´s all in
portuguese but i think it can help you.
Hello
I have a server with the following specs but fear that the currently
running MySQL-4.1 does not completely utilize it as the database feels
to slow for the webservers although the system load is always only at
about 10%:
CPU: Quad Dualcore Xeon with Hyperthreading (4*2*2=16 logical
Turn off the hyperthreading. You're not going to see superior performance
with hyperthreading enabled, you're just going to create a massive
thread-thrash with 16 logical cpus running 16 threads with not nearly enough
resources to cover them.
- Original Message -
From: Christian
Christian, can you post the output of
SHOW STATUS
and
SHOW VARIABLES
please?
This will tell us how your server is configured, and how it has been
running. It's possible you're not set up to best utilize your CPU
power or memory.
Dan
On 8/22/06, Christian Hammers [EMAIL PROTECTED] wrote:
Jürgen, I wonder if you have properly set collations in just some areas?
show variables like collation%;
show create table tablename; (for each table involved)
I would think you'd want this all to match ... though I am not an
expert in this area.
Dan
SHOW COLLATION
On 8/22/06, Jürgen
Hallo
On Tue, Aug 22, 2006 at 09:25:09AM -0500, Dan Buettner wrote:
Christian, can you post the output of
SHOW STATUS
and
SHOW VARIABLES
please?
This will tell us how your server is configured, and how it has been
running. It's possible you're not set up to best utilize your CPU
power
The output of the cmds is this:
mysql show variables like collation%;
+--+---+
| Variable_name| Value |
+--+---+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_general_cs |
|
On 8/22/06, Karl Larsen [EMAIL PROTECTED] wrote:
$ mysqladmin -U make new password for root doesn't work.
can you copy the error?
if you want to set the root password you can use
mysqladmin -u root password newpwd
--
http://www.obed.org.mx --- blog
--
MySQL General Mailing List
For list
Hi Christian - thanks for posting that.
I see you are making excellent use of the query cache; also your
thread_cache is working well, seems that 30 is about the right number.
You have a high number of connections, by my calculations about 15 per second.
(connection / uptime, or
Hi,
I got 4 relatively big (for me at least) queries. At the moment, the data
in the tables are merely test data, but once the system goes into
production, I'm expecting millions of records in most of the tables. I'm
trying very hard thus to optimise my queries and tables to ensure I get a
I recently upgraded from MySql 4.0.x to 5.0.x and now my nightly
backups are giving me this error (from mysqlhotcopy).
Cannot open dir '/database/information_schema': No such file or
directory at /usr/bin/mysqlhotcopy line 283.
I don't know where it's getting that information_schema thing.
Thanks for the info Dan.
I'll check the resources you mentioned.
Regards
Andy
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Tue 8/22/2006 1:38 PM
To: Andy Ford
Cc: mysql@lists.mysql.com
Subject: Re: limitations of mySQL i.e. number of rows
Andy,
We had to rebuild the slave on our slave DB. After the raid got rebuilt
replication
broke. We tried to rebuild it from scratch by doing the following:
- RESET MASTER (on master)
- mysqldump -e --master-data --single-transaction --databases db1 db2
dbout
- on the slave: STOP SLAVE, RESET
We want to get:
Windows Server 2003 R2, Standard x64 Edition
2- Dual Core Intel Xeon 5080, 2x2MB Cache, 3.73GHz, 1066MHz FSB
8GB 533MHz (8x1GB), Dual Ranked DIMMs
3- 146GB, SAS, 3.5-inch, 15K RPM Hard Drives
What would be the recommended RAID configuration settings for a dedicated
MySQL db
David Lazo wrote:
We want to get:
Windows Server 2003 R2, Standard x64 Edition
2- Dual Core Intel Xeon 5080, 2x2MB Cache, 3.73GHz, 1066MHz FSB
8GB 533MHz (8x1GB), Dual Ranked DIMMs
3- 146GB, SAS, 3.5-inch, 15K RPM Hard Drives
What would be the recommended RAID configuration settings for a
I second what James recommends re: spindles and RAID 10. Better than
RAID 5 for live data in my opinion; RAID 5 is decent for archival
storage.
You've got a pretty decent setup there otherwise - 4 CPU cores, 8 GB
RAM - and you want to make sure your disks can keep things fed.
As far as
On Tue, Aug 22, 2006 at 10:04:06AM -0500, Dan Buettner wrote:
You have a high number of connections, by my calculations about 15 per
second. (connection / uptime, or 46944092/3052131 = 15.38) I would
think that is introducing a fair bit of overhead for you - you might
consider persistent
On Tue, Aug 22, 2006 at 10:20:47AM -0600, Michael Loftis wrote:
One other quick ? -- Are you using a 64 bit (x86_64/EMT64) or 32-bit? If
you're still in 32-bit mode the extra memory over 4Gb can actually slow the
system down since it has to page between memory zones.
It was choosen to run
Thanks for all the recommendations.
On 8/22/06 1:11 PM, Dan Buettner [EMAIL PROTECTED] wrote:
I second what James recommends re: spindles and RAID 10. Better than
RAID 5 for live data in my opinion; RAID 5 is decent for archival
storage.
You've got a pretty decent setup there otherwise -
hi
Why is it that I cannot connect to mysql-4.1 server using mysql-4.0.27
client?
ERROR 1251: Client does not support authentication protocol requested by
server; consider upgrading MySQL client
Where is the RTFM on this? I just want to read it.
-Wash
http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html
enable old-passwords in my.cnf
Hope that helps,
Ken
- Original Message -
From: Odhiambo Washington [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, August 22, 2006 1:38 PM
Subject: MySQL 4.0.27-client and
Disregard this question, it was a problem with a script I wrote, not
a problem with mysqlhotcopy. My bad!
Scott
Scott Baker wrote:
I recently upgraded from MySql 4.0.x to 5.0.x and now my nightly
backups are giving me this error (from mysqlhotcopy).
Cannot open dir
Is there any way to find a column name (or, better yet, a partial column
name) in all tables within a data base?
I inherited a complex and totally undocumented data base, and need to find
out (for example) which tables have a column name like xxx_exported.
Regards,
Jerry Schwartz
Global
Love it when that happens :)
Fastest way I can think of is dumping out the structure of the database
with mysqldump -d database.sql
and then searching the output to see where those columns appear
-Original Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
http://dev.mysql.com/doc/mysql/en/old-client.html
Regards,
Chris.
- Original Message -
From: Odhiambo Washington [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, August 22, 2006 7:38 PM
Subject: MySQL 4.0.27-client and MySQL-4.1.21 server
hi
Why is it that I cannot
:)
I went a similar way, actually. I pushed the output of a SHOW TABLES into a
text file, sucked it into Excel, and used a formula to make the necessary
SHOW COLUMNS FROM `tbl_name` LIKE expression. It took me a minute or two
to figure out I needed the back-ticks - the very first table is named
Is there any way to find a column name (or, better yet,
a partial column name) in all tables within a data base?
1. If the db is not in 5.0, mysqldump the DML to a file, run that file
in an instance of MySQL 5.x.
2. Query information_schema.
PB
-
Jerry Schwartz wrote:
Is there any way
I haven't ventured into MySQL 5.x, I have enough trouble working with this
house of cards I was handed. I'll try to remember this for the future,
though.
Thanks to all.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX:
Здравствуйте, Гордеев.
Вы писали 20 августа 2006 г., 12:58:35:
Здравствуйте!
Интересует такой момент. Мой сайт хостится у местного провайдера. Они
создали
базу mySQL где у меня и лежат таблицы для моего портала. Возникла
необходимость
перенести модули (гостевая книга и
Jerry
I haven't ventured into MySQL 5.x, I have enough trouble working
with this
house of cards I was handed. I'll try to remember this for the
future,
though.
All you need to do is install mysql 5 in any box, run the dump script,
then execute one query:
SELECT
LOWER(table_name) AS
Unfortunately, I have no experience running two versions of MySQL on the
same box, and we have no development environment. That contributes to my
timidity.
By the way, I thought I read that the list wouldn't accept HTML-coded
messages; but yours came through that way. Did I misread something?
If you are going to be storing only 2 months of data at a time, I would suggest using merge tables. Use one table per month. This
makes it very easy to delete data, simple redeclare what the union is. Then you can also retain previous months without affecting
performance.
One of the databases I
Jerry Schwartz wrote:
Unfortunately, I have no experience running two versions of MySQL on the
same box, and we have no development environment. That contributes to my
timidity.
Just one 'puter? Yikes.
By the way, I thought I read that the list wouldn't accept HTML-coded
messages; but yours
Your mysql db is only using 496Mb of ram? i have a server with 1GB ram
where mysql uses more mem than yours does - you should probably tune
your server system variables a bit to utilize your memory better.
Christian Hammers wrote:
On Tue, Aug 22, 2006 at 10:20:47AM -0600, Michael Loftis
Ratheesh K J wrote:
Hello all,
I have a couple of questions on storage engine types wrt performance
1.. Will there be any performance degrade when we do joins with tables having
different storage engines ?
Depends on the type of queries I think.
There could be something here
Chris Knipe wrote:
Hi,
I got 4 relatively big (for me at least) queries. At the moment, the
data in the tables are merely test data, but once the system goes into
production, I'm expecting millions of records in most of the tables.
I'm trying very hard thus to optimise my queries and
Neil Tompkins wrote:
I followed the instructions, but when doing a search I get no results returned.
here is my table
CREATE TABLE /*!32300 IF NOT EXISTS*/ MyTest ( id int(10) unsigned NOT NULL
auto_increment, title varchar(200) , body text , PRIMARY KEY (id), INDEX
title
Hi all,
Does anyone know how mysql stores dates?
I'm wondering whether it converts it back to UTC before storing it (and
back to the client timezone setting when you select) or whether it
leaves it as is with the timezone information.
So to change to a different timezone I'd have to convert
At 10:20 PM 8/22/2006, Chris wrote:
You can't store them in memory.
http://dev.mysql.com/doc/refman/5.1/en/temporary-table-problems.html
Despite what the doc says, I posted a working script here a couple of weeks
ago which creates temporary tables with engine=Memory. Either my
57 matches
Mail list logo
