/how-to-recover-deleted-rows-from-an-innodb-tablespace/
I've never used it (yay backups!), so I can't tell you if it will work for an
entire dropped database.
Regards,
Derek Downey
On Oct 26, 2012, at 10:15 AM, Lorenzo Milesi max...@ufficyo.com wrote:
innodb will not be consistent
I do agree with Reindl that it is highly unlikely to work, but without
specifics of how busy your DB is and how much write activity you have, it will
at least give a shot for perhaps some data.
Derek Downey
On Oct 26, 2012, at 10:29 AM, Reindl Harald h.rei...@thelounge.net wrote:
Am
Hrm, what version of MySQL? I just ran the query on 5.5.24 and it worked as
expected.
- Derek Downey
On Oct 4, 2012, at 9:52 AM, MAS! wrote:
Hi
I know there'd be a reason, but I can't understand that..
mysql select @valore:=rand(), @valore, @valore:=ciao, @valore
attempting the SET NAMES.
Derek Downey
On Sep 24, 2012, at 7:53 PM, Rick James wrote:
If you have a mixture of encodings, you are in deep doodoo.
This page describes some debugging techniques and some issues:
http://mysql.rjweb.org/doc.php/charcoll
That apostrophe might
Be careful deleting with limit. If you're replicating, you're not guaranteed
the same order of those you've deleted.
Perhaps a better way to delete in smaller chunks is to increase the id value:
DELETE FROM my_big_table WHERE id 5000;
DELETE FROM my_big_table WHERE id 4000;
etc
-- Derek
On
| 483, 723|
Or some such. Note I haven't tested the actual query. It's just a general
direction.
- Derek Downey
On Oct 19, 2011, at 1:32 PM, Michael Dykman wrote:
I'm afraid that what you are looking for simply cannot be done with MySQL
alone. You will need to pare your results
, and not something I need to run
everyday.
-- Derek Downey
On Oct 19, 2011, at 6:06 PM, Basil Daoust wrote:
For me given the sample data the following worked.
The inner select says find all first messages, the outer says give me all
messages that are thus not first messages.
select * from table1
You could look into the sphinx engine http://sphinxsearch.com/about/sphinx/
No experience with this personally though
- Derek
On Sep 29, 2011, at 1:07 PM, Tompkins Neil wrote:
Yes, unless I can set-up some sort of replication between the two tables.
On Thu, Sep 29, 2011 at 6:05 PM, Reindl
SELECT id INTO @row_id FROM myTable WHERE blah blah LIMIT 1;
Source
http://dev.mysql.com/doc/refman/5.5/en/select-into-statement.html
On Sep 21, 2011, at 2:23 PM, Brandon Phelps wrote:
Hello all,
I would like to create a stored procedure that does the following:
1. Accepts 4 values as
Try searching for a row that has a login_date of '-00-00 00:00:00'
- Derek
On Sep 9, 2011, at 8:52 AM, umapathi b wrote:
Any update from anybody ?
-- Forwarded message --
From: umapathi b umapath...@gmail.com
Date: Thu, Sep 8, 2011 at 4:28 AM
Subject: Re: strange
Correct me if I'm wrong. You're wanting to get all records that have an
open_date or a close_date between two times.
If that's correct, you might be able to get an index_merge by doing a query
like:
WHERE ((starting time)=open_dt= (ending time)) OR ((starting
time)=close_dt=(ending time))
/local/mysql5.5
$ sudo make install
I think my cmake step was missing a flag to specify x86_64 arch
Derek Downey
On Sep 3, 2011, at 2:38 PM, Jan Steinman wrote:
From: Derek Downey de...@orange-pants.com
I am trying to setup a development machine to start delving into some of the
internal
Hello,
I am trying to setup a development machine to start delving into some of the
internal code of the MySQL DB. I'm off to a great start, since I can't even get
it to build properly. I'm sure I'm missing an important step, but am following
the instructions from
13 matches
Mail list logo
