StartingMySQL…ERROR!TheserverquitwithoutupdatingPIDfile(/mydata/data/t1.pid).
測試環境:
mysql 5.6.25 (適用5.1.73 5.1.65)
1
vim /etc/my.cnf
pid-file=/mypid/t1.pid
今天在備份的時候,我測試把mysql-log.index刪除之後報錯如下:
[root@t1 data]# /etc/init.d/mysqld start
Starting MySQL… ERROR! The server quit without updating PID file (/mydata/data/t1.pid).
2 、
我還原 mysql-log.index
重新 service mysqld start
報錯:Starting MySQL… ERROR! The server quit without updating PID file (/mydata/data/t1.pid).
3.1 測試:
1.1
剛開始註冊(未改動):
log-bin=mysql.log
1.2
為了增量備份(改動後):
log-bin=/var/lib/mysql/mysql-bin.log
啟動。
報錯:Starting MySQL… ERROR! The server quit without updating PID file (/mydata/data/t1.pid).
1.3
再次修改(為原路徑):
log-bin=mysql.log
再次啟動,成功。
[root@localhost data]# /etc/init.d/mysqld start
Starting MySQL. ERROR! The server quit without updating PID file (/mydata/data/localhost.localdomain.pid).
[root@localhost data]# vim /etc/my.cnf
[root@localhost data]# ls /binlog/
[root@localhost data]# vim /etc/my.cnf
[root@localhost data]# chown -R mysql.mysql /binlog/
[root@localhost data]# /etc/init.d/mysqld start
修改了my.cnf裡面的binlog路徑,必須給binlog路徑授權,不然,資料庫根本不能啟動。切記。
3、
我禁用:
vim /etc/my.cnf
#pid-file=/mypid/t1.pid
重新 service mysqld start
OK
然後查詢,mysql-log.index 生成了一個新的。
當不小心刪除mysql-log.index mysql-log.00001 mysql-log.00002 檔案的時候,如果要啟動mysqld 必須禁用pid-file選項在my.cnf裡面。
相關文章
- StartingMySQL.ERROR!TheserverquitwithoutupdatingPIDfile(/data/mysql/mysql.pid).MySqlErrorServerUI
- #pragma data_seg() 共享資料// MyData段 // 程式 // DLL
- mysql起動報錯TheserverquitwithoutupdatingPIDfile/usr/local/mysql/data/MySqlServerUI
- load data infile ERROR 1045 (28000)Error
- Composer 提示 zlib_decode (): data errorError
- 【Jenkins】data stream error|Error cloning remote repo ‘origin‘ 錯誤解決JenkinsErrorREM
- DBLOGIN ERROR: Failed to open data source for user OGG.ErrorAI
- Inserting Data with DML Error Logging(轉)Error
- Dynamics CRM CRM Reporting Error: Error occurred while fetching the data extension的解決方法ErrorWhile
- kernel_data_inpage_error藍屏錯誤怎麼修復Error
- mysql錯誤: [ERROR] InnoDB: auto-extending data file /data/ibdata1 is of a different size 768 pages...MySqlError
- 密碼檔案導致Data Guard同步錯誤:error 12514,Error 1033 - 2密碼Error
- 密碼檔案導致Data Guard同步錯誤:error 12514,Error 1033 - 1密碼Error
- fatal: [192.168.65.128]: UNREACHABLE! => {"changed": false, "msg": "SSH Error: data could not be senFalseError
- ORA-39097: Data Pump job encountered unexpected error -12801Error
- 緊急 - InvalidOperationException: Internal .Net Framework Data Provider error 30ExceptionFrameworkIDEError
- ORA-00607: Internal error occurred while making a change to a data blockErrorWhileBloC
- grid control Error in getting data for creating new listenerError
- The server quit without updating PID file (/mydata/mysql/BIDB.pid).[FAILED]ServerUIMySqlAI
- kernel_data_inpage_error藍色畫面錯誤怎麼修復Error
- error: RPC failed; curl 18 transfer closed with outstanding read data remainingErrorRPCAIREM
- mysql 5.7.21 CMake Error: The source directory "/data/server/mysql" does not appear to contain CMakMySqlErrorServerAPPAI
- ORA-01565: error in identifying file '+DATA/devdb/spfiledevdb.ora'ErrorIDEdev
- ORA-01565: error in identifying file '+DATA/rac/dataile/datfile/system'ErrorIDEAI
- MySQL案例09:Last_IO_Error: Got fatal error 1236 from master when reading data from binary logMySqlASTErrorGo
- python匯入資料錯誤:ParserError: Error tokenizing data. C error: Expected 1 fields in line 3, saw 2PythonError
- ERROR3948: Loading local data is disabled - this must be enabled on both the client and server sidesErrorclientServerIDE
- 詭異的OGG-01004 Database error 1403 no data foundDatabaseError
- python關於Error tokenizing data. C error: Expected 10 fields in line 30, saw 31可能出現的問題PythonError
- MySQL 8.0.26 bug ERROR 1064(42000) -master-data is deprecated and will be removeMySqlErrorASTREM
- Got fatal error 1236 from master when reading data from binary logGoErrorAST
- ttAdmin -Ramload Error TT0848: Recovery failed on 2 set(s) of data store filesErrorAI
- ERROR! The server quit without updating PID file (/opt/mysql/mysql/data/cvs.pid)ErrorServerUIMySql
- Data Quality and Data Cleaning
- Export data from a data blockExportBloC
- MySQL 儲存過程空結果集錯誤Error 1329 No data 的異常處理MySql儲存過程Error
- MySQL主從複製報錯:Got fatal error 1236 from master when reading data fromMySqlGoErrorAST
- MySQL複製環境Slave報錯"Got fatal error 1236 from master when reading data"MySqlGoErrorAST