数据库里的数据导不出来了,是不是数据损坏了?

2013-07-24 16:42:25 +08:00
 54dev
mysqldump: Got error: 2013: Lost connection to MySQL server during query when using LOCK TABLES

表是innodb的。

百度上的结果让去修改mysql的一些参数,但无效。

在GOOGLE上搜的第一条结果就是要修改表了

求dba高手指导。
2631 次点击
所在节点    问与答
3 条回复
nybux
2013-07-24 17:10:33 +08:00
看看mysql的错误日志
54dev
2013-07-24 17:18:05 +08:00
54dev
2013-07-24 17:18:12 +08:00
@nybux
130724 11:13:15 [Note] Plugin 'FEDERATED' is disabled.
130724 11:13:15 InnoDB: Initializing buffer pool, size = 2.0G
130724 11:13:16 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 68 990469989
130724 11:13:16 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: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 68 990540111
InnoDB: Transaction 0 1257862957 was in the XA prepared state.
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 0 row operations to undo
InnoDB: Trx id counter is 0 1257863424
130724 11:13:16 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 11814, file name ./mysql-bin.000040
130724 11:13:17 InnoDB: Started; log sequence number 68 990540111
130724 11:13:17 [Note] Recovering after a crash using mysql-bin
130724 11:13:17 [Note] Starting crash recovery...
130724 11:13:17 InnoDB: Starting recovery for XA transactions...
130724 11:13:17 InnoDB: Transaction 0 1257862957 in prepared state after recovery
130724 11:13:17 InnoDB: Transaction contains changes to 1 rows
130724 11:13:17 InnoDB: 1 transactions in prepared state after recovery
130724 11:13:17 [Note] Found 1 prepared transaction(s) in InnoDB
InnoDB: Starting in background the rollback of uncommitted transactions
130724 11:13:17 InnoDB: Rollback of non-prepared transactions completed
130724 11:13:17 [Note] Crash recovery finished.
130724 11:13:17 [Note] Event Scheduler: Loaded 0 events
130724 11:13:17 [Note] /web/database/bin/mysqld: ready for connections.
Version: '5.1.66-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)

这是一个专为移动设备优化的页面(即为了让你能够在 Google 搜索结果里秒开这个页面),如果你希望参与 V2EX 社区的讨论,你可以继续到 V2EX 上打开本讨论主题的完整版本。

https://www.v2ex.com/t/76840

V2EX 是创意工作者们的社区,是一个分享自己正在做的有趣事物、交流想法,可以遇见新朋友甚至新机会的地方。

V2EX is a community of developers, designers and creative people.

© 2021 V2EX