The index file will rebuild by using the above command.
On Thu, May 19, 2011 at 11:16 AM, Ramesh wrote:
> Is that index and all will be fine in that table, or have to create again?
>
> On 19 May 2011 11:11, Ramesh wrote:
>
>>
>> Lost all the records once i done the repair table with use_frm.
>>
Is that index and all will be fine in that table, or have to create again?
On 19 May 2011 11:11, Ramesh wrote:
>
> Lost all the records once i done the repair table with use_frm.
>
> On 19 May 2011 10:30, Suresh Kuna wrote:
>
>> Run this - repair table SystemEvents use_frm ;
>>
>>
>> On Thu, Ma
Can you paste the table files in the datadir and the execution part of the
below query.
On Thu, May 19, 2011 at 11:11 AM, Ramesh wrote:
>
> Lost all the records once i done the repair table with use_frm.
>
> On 19 May 2011 10:30, Suresh Kuna wrote:
>
>> Run this - repair table SystemEvents use_
Lost all the records once i done the repair table with use_frm.
On 19 May 2011 10:30, Suresh Kuna wrote:
> Run this - repair table SystemEvents use_frm ;
>
>
> On Thu, May 19, 2011 at 10:24 AM, Ramesh wrote:
>
>> mysql> repair table SystemEvents.frm;
>>
>> +--++-
Run this - repair table SystemEvents use_frm ;
On Thu, May 19, 2011 at 10:24 AM, Ramesh wrote:
> mysql> repair table SystemEvents.frm;
>
> +--++--++
> | Table| Op | Msg_type |
> Msg_text
mysql> repair table SystemEvents.frm;
+--++--++
| Table| Op | Msg_type |
Msg_text |
+--++--++
| SysEvents.frm
Try to take a tab separated dump, so you can restore what ever you want in
terms of tables or databases.
On Thu, May 19, 2011 at 9:53 AM, Adarsh Sharma wrote:
> I take a complete backup through mysqldump command.
> It includes MyISAM & Innodb tables both.
>
> But now i am thinking to take backup
Looks like your test succeeded and you win!!!
On Thu, May 19, 2011 at 9:41 AM, Adarsh Sharma wrote:
>
> Hi all,
>
> Thanks
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
>
>
--
I take a complete backup through mysqldump command.
It includes MyISAM & Innodb tables both.
But now i am thinking to take backup in compressed format.
Thanks
Suresh Kuna wrote:
It really depends on What kind of backup you performed a month ago rather
than the type of tables at the moment...
Hi all,
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
use repair table table_name use_frm ; and try it out.
It needs to be run inside mysql.
On Thu, May 19, 2011 at 9:30 AM, Ramesh wrote:
> Hi,
>
> I am trying to repair the table and i got this error
>
> I tried with myisamchk --rq --tmpdir= /var/lib/mysql/tablog/TabEvents.MYI
>
> [root@uidsyslo
Hi,
I am trying to repair the table and i got this error
I tried with myisamchk --rq --tmpdir= /var/lib/mysql/tablog/TabEvents.MYI
[root@uidsyslog001 mysql]# myisamchk --rq --tmpdir=/var/lib/mysql
/var/lib/mysql/tablog/TabEvents.MYI
check record delete-chain
- recovering (with sort) MyISAM-tabl
It really depends on What kind of backup you performed a month ago rather
than the type of tables at the moment...
On Thu, May 19, 2011 at 6:50 AM, Michael Dykman wrote:
> What tables types are you using? If MyISAM, this can be done easily.
> If InnoDB it will depend on your settings (file-per-
What tables types are you using? If MyISAM, this can be done easily.
If InnoDB it will depend on your settings (file-per-table)
- michael dykman
On Tue, May 17, 2011 at 7:11 AM, Adarsh Sharma wrote:
> Dear all,
>
> I read all the different ways to backp and restore data in mysql.
> Say, i perf
Dear all,
I read all the different ways to backp and restore data in mysql.
Say, i perform a complete backup of all databases 1 month ago
Now, is it possible to restore only a single database from a complete
backup file of 250 GB that contains backup of more than 50 databases.
Or if we want t
Hi
I am trying to retrieve record from 2 tables (book and author), but my
problem is how to retrieve all the names of authors where more than one
author wrote a book.
Here is what i have: it works OK, except that it returns more than one row
for books that have more than one author.
select conca
16 matches
Mail list logo