今天打出表结构和数据遇到问题。
mysqldump -udbuser -p dbname > dbname.sql
保存信息为：
when doing LOCK TABLES
解决方法：
mysqldump -udbuser -p dbname --skip-lock-tables > dbname.sql
增加 --skip-lock-tables
相关文章
- 02-24Too many open files) when using LOCK TABLES
- 02-24mysqldump when doing LOCK TABLES问题
- 02-24在给mysql数据库备份时，报错： mysqldump: Got error: 145: Table '.\shengdaxcom\pre_forum_thread' is marked as c rashed and should be repaired when using LOCK TABLES
- 02-24解决备份数据库时database ‘information_schema‘“ when using LOCK TABLES的错误
- 02-24关于MYSQL 死锁的问题 Deadlock found when trying to get lock； try restarting
- 02-24Mysql 备份数据库方法及when using LOCK TABLES错误解决方法
- 02-24Mysql报Deadlock found when trying to get lock； try restarting transaction问题解决
- 02-24mysql deadlock found when trying to get lock 问题排查
- 02-24记一次mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table问题
- 02-24mysqldump 参数--lock-tables浅析