BMS-HOSxP Community
HOSxP => นอกเรื่อง => ข้อความที่เริ่มโดย: panus_t ที่ พฤษภาคม 06, 2013, 10:44:37 AM
-
ทำไม dump database ไมได้ (เครื่องสำรอง)
[root@hosxp ~]# mysqldump -u root -p hos > /tmp/hos239.sql
Enter password:
mysqldump: Got error: 23: Out of resources when opening file './hos/stock_project_plan.MYD' (Errcode: 24) when using LOCK TABLES
-
ลอง mysqldump -u root -p hos > /tmp/hos239.sql --lock-tables=false
-----------------------------------------------------
Does the --lock-tables=false option work?
According to the man page, if you are dumping InnoDB tables you can use the --single-transaction option:
--lock-tables, -l
Lock all tables before dumping them. The tables are locked with READ
LOCAL to allow concurrent inserts in the case of MyISAM tables. For
transactional tables such as InnoDB and BDB, --single-transaction is
a much better option, because it does not need to lock the tables at
all.
http://stackoverflow.com/questions/104612/run-mysqldump-without-locking-tables
-
ขอบคุณครับ ;D