mysqldump: Got error: 1016: Can’t open file: ‘./bdm0140379_db/lady_forumrecommend.frm’ (errno: 24) when using LOCK TABLES
Add an open_files_limit = 100000 to my.conf (etc/my.conf in my environment)
Service mysqld Restart.
Warning: Skipping the data of table mysql.event.specify the –events option explicitly.
Add –events –ignore-table=mysql.event
mysqldump -u root -pxxxxxxx –all-databases –events –ignore-table=mysql.event > /alidata/26.sql
Read More:
- mysql error 1033 Incorrect information in file: ‘xxx.frm’ (Fixed)
- Can’t open file: (errno: 24)
- Error in exporting MySQL database from Linux mysqldump:got error :1045
- Global lock, table lock and row lock in MySQL
- Vs2017 cannot open the source file “XXX. H” by adding a file name after creating a new class
- Error in startup after the supervisor modifies the configuration file: error: cannot open an HTTP server: socket.error reported errno.eaddnotavail
- Vs cannot open source file “XXX. H” problem
- Solution to error 1045 in mysqldump
- Error in header file when calling OpenGL to open obj file in vs2013: unable to open include file: “GL / glut. H”: no such file or directories
- When linux installs rpm, it prompts: can’t create transaction lock on /var/lib/rpm/.rpm.lock error
- Flutter SocketException: OS Error: No route to host, errno = 113, address = XXX
- VMware failed to lock memory file. Error restoring virtual machine state from file
- [Solved] KEIL Error: source file ‘.XXX.o‘ – object file renamed from ‘XXX.o‘ to …
- 【Exception】mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table…
- Unity Cursor Lock& Camera Lock
- MySQL partitions the existing tables of the data table
- MySQL skip grant tables add user error 1290
- Fatal: unable to create ‘project_ path/.git/ index.lock ‘: File exists.
- Centos 7 | mariadb/mysql | [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
- If you want to open more than one program “pdc140.xxx”, the CL.EXE To write to the same. Pdb file, please use