Ok. Well, I put the entire log right below:
120126 12:12:49 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB:
2012/1/26 Suporte Avanutri supor...@avanutri.com.br:
[At this point I deleted the table “obras.frm”. Still trying to dump,
crashing every time, and restarting mysqld with a higher
“innodb_force_recovery” value at a time]
It doesn't matter what you set in innodb_force_recovery. If you do
not
- Original Message -
From: Todd Lyons tly...@ivenue.com
It doesn't matter what you set in innodb_force_recovery. If you do
not have the obras.frm file (which contains the schema definition of
the table), I don't know if you can retrieve the info. Put that file
I recommended he
Mysqld crashes when I try to dump everything at once. I made a test by
extracting information from only one table, and it worked. I will try yet with
another tables. But I guess that is it... Thanks a lot, people. You were great.
=)
-Mensagem original-
De: Johan De Meersman
thanks. it took about 15 hrs. but right now everything seems ok. does
the check last as long as the repair?
On 1/24/12 3:51 AM, Johan De Meersman wrote:
- Original Message -
From: kalin m ka...@el.net
ok. thanks. i thought so. it's been about 8 hrs so far. and the TMD
file is about
20120126 10:34 AM +0200, a bv
Database contains
tables (structures?) which gets montly data , and these tables are
named as
name1_name2_ yearmonth . I only want to have the whole database system
for last 2 years, and automaticly clean the data which became more
than 2 years old , so i need
login into another session, check the thread id and kill it. ( Kill
threadid.)
On Fri, Jan 27, 2012 at 3:51 AM, Dotan Cohen dotanco...@gmail.com wrote:
If I see that a query is taking a long time to finish, how can I
interrupt the MySQL CLI interpreter? Ctrl-C does not work. Thanks.
--
And also make sure that you have the SUPER privilege to kill it.
Regards,
KarthiK.P.R
On Fri, Jan 27, 2012 at 9:09 AM, Suresh Kuna sureshkumar...@gmail.comwrote:
login into another session, check the thread id and kill it. ( Kill
threadid.)
On Fri, Jan 27, 2012 at 3:51 AM, Dotan Cohen
Dear all,
Today i am creating a partition table in my mysql server
5.1.34-community-log .
create table sample( a integer, dt_stamp timestamp not null default
current timestamp, content varchar)engine= innodb
PARTITION BY RANGE ( UNIX_TIMESTAMP(dt_stamp) ) (
- PARTITION p0 VALUES