mysql> SELECT * FROM alog WHERE id=12163578;
ERROR 1032 (HY000): Can't find record in 'alog'
mysql> SELECT * FROM alog WHERE id=12163577;
Empty set (0,00 sec)

mysql> SELECT * FROM alog WHERE id=12163576;
(выводятся нормальные данные.)
1 row in set (0,00 sec)




mysql> DELETE FROM alog WHERE id=12163578;
Query OK, 0 rows affected (0,00 sec)

mysql> SELECT * FROM alog WHERE id=12163578;
ERROR 1032 (HY000): Can't find record in 'alog'
mysql> REPLACE INTO alog( id, mes, nomer ) VALUES ( 12163578, 'test', 111 );
ERROR 1062 (23000): Duplicate entry '12163578' for key 'PRIMARY'

> SELECT * INTO OUTFILE 'my_tb_alog.sql' FROM alog;

# ls -l /var/db/mysql/log
-rw-rw----  1 mysql  mysql   268 Mb 12 янв 08:42 alog.MYD
-rw-rw----  1 mysql  mysql   106 Mb 12 янв 11:41 alog.MYI
-rw-rw----  1 mysql  mysql        8854 24 мар  2017 alog.frm
-rw-rw----  1 mysql  mysql          61 23 май  2016 db.opt
-rw-rw-rw-  1 mysql  mysql  3318 Mb 15 янв 11:49 my_tb_alog.sql

> SHOW COLUMNS FROM alog;
+--------+-----------------+------+-----+---------+----------------+
| Field  | Type            | Null | Key | Default | Extra          |
+--------+-----------------+------+-----+---------+----------------+
| id     | int(8) unsigned | NO   | PRI | NULL    | auto_increment |
| date   | date            | YES  |     | NULL    |                |
| time   | time            | YES  |     | NULL    |                |
| mesayc | varchar(3)      | YES  |     | NULL    |                |
| day    | int(1)          | YES  |     | NULL    |                |
| god    | int(1)          | YES  |     | NULL    |                |
| vremya | time            | YES  |     | NULL    |                |
| nomer  | varchar(8)      | YES  | MUL | NULL    |                |
| mes    | varchar(255)    | YES  |     | NULL    |                |
| ip     | varchar(15)     | YES  |     | NULL    |                |
| lev    | int(1)          | YES  |     | NULL    |                |
+--------+-----------------+------+-----+---------+----------------+
11 rows in set (0,01 sec)

> SELECT * INTO OUTFILE 'my_tb_alog.sql' FROM alog WHERE id BETWEEN 1 AND 12345678;
> SELECT * INTO OUTFILE 'my_tb_alog.sql' FROM alog WHERE id BETWEEN 1 AND 12345677;
> SELECT * INTO OUTFILE 'my_tb_alog.sql' FROM alog WHERE id BETWEEN 1 AND 12345670;

> SELECT * INTO OUTFILE 'my_tb_alog.sql' FROM alog WHERE id BETWEEN 1 AND 12163576;

# head -n 15 /var/db/mysql/log/my_tb_alog.sql
# tail -n 15 /var/db/mysql/log/my_tb_alog.sql

$ mysql -b -ulogin -p -D log -e "REPAIR TABLE alog" -ulogin -hhost
Enter password: 
+----------+--------+----------+------------------------------------------------+
| Table    | Op     | Msg_type | Msg_text                                       |
+----------+--------+----------+------------------------------------------------+
| log.alog | repair | info     | Key 1 - Found wrong stored record at 259882996 |
| log.alog | repair | warning  | Number of rows changed from 1438558 to 1442415 |
| log.alog | repair | status   | OK                                             |
+----------+--------+----------+------------------------------------------------+
+