ERROR 1114 (HY000) The table '' is full
客戶的5.1的mysql遷移到5.7，tb_mk_revisit_id是innodb表
$mysql -u root -p webparty < /data2/woqu/tbover6.sql
Enter password:
ERROR 1114 (HY000) at line 24612: The table 'tb_mk_revisit_d' is full
看是否每個innodb表單獨表空間，問題的原因就是innodb_data_home_dir設定到根目錄了，並且共享表空間很大了，30G，然後檔案系統滿了。就醬紫。。。。後來改回來了，
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29990276/viewspace-2216992/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ERROR 1786 (HY000): Statement violates GTID consistency: CREATE TABLE ... SELECTError
- ERROR 2026 (HY000): SSL connection error: unknown error numberError
- Error!: SQLSTATE[HY000] [2002] Connection refusedErrorSQL
- ERROR 1290 (HY000): The MySQL server is running withErrorMySqlServer
- ERROR 1290 (HY000) 解決辦法Error
- MySQL 8.0.25 Bug 報"MY-013132 The table ...is full"MySql
- 解決ERROR 1030 (HY000): Got error 168 from storage engine apparmorErrorGoAPP
- Mysql連線錯誤ERROR 2003 (HY000)MySqlError
- 【MySQL】ERROR 1878 (HY000): Temporary file write failure.MySqlErrorAI
- ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization paErrorMySqlServer
- [20221227]a mutating table error without a trigger!.txtError
- SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-preparedSQLError
- MySQL 報錯 ERROR 1290 (HY000): running with the --secure-file-privMySqlError
- ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables optErrorMySqlServer
- 阿里雲mysql遠端登入報ERROR 2027(HY000)阿里MySqlError
- 1114模擬賽
- ORA-31633: unable to create master table "SYSTEM.SYS_EXPORT_FULL_XX"ASTExport
- 【TUNE_ORACLE】列出走了TABLE ACCESS FULL的SQL參考OracleSQL
- 【MySQL】ERROR 1290 (HY000): --secure-file-priv--匯出報錯MySqlError
- MySQL5.7叢集（MGR）啟動報ERROR 3092 (HY000)MySqlError
- MySQL報錯ERROR 2013 (HY000): Lost connection to MySQL server during queryMySqlErrorServer
- MySQL 使用 show tables 時出現 ERROR 1449 (HY000) 問題MySqlError
- MySQL案例02：ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGESMySqlError
- 1114 Family Property (25分)
- mysql 5.6.25報錯ERROR 1372 (HY000): Password hash 的一點思考MySqlError
- mysql無法建立儲存過程問題 ERROR 1307 (HY000)MySql儲存過程Error
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- Centos7-mysql執行報錯ERROR1820(HY000):YoumustresetyourpasswordusingALTERUSERstatementbeforeexecutingthisstatement.CentOSMySqlError
- ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAError
- Linux：ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannLinuxErrorMySqlServer
- MySQL建立使用者報錯 ERROR 1396 (HY000): Operation CREATE USER failed for 'afei'@'%'MySqlErrorAI
- mysql 8 報錯 ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repositoryMySqlErrorAIStruct
- mysql錯誤詳解（1819）：ERROR 1819 (HY000): Your password does not satisfy the current policy requirementsMySqlErrorUIREM
- 建立xtrbackup備份使用者 ERROR 1819 (HY000): Your password does not satisfy the current policy requirementsErrorUIREM
- MySQL 5.7 建立使用者報錯 ERROR 1805 (HY000): Column count of mysql.user is wrongMySqlError
- mysqldump匯出報錯"mysqldump: Error 2013 ... during query when dumping tableMySqlError
- SQLITE_ERROR - table sap_capire_bookshop_books has no column named currencySQLiteErrorAPI
- HDU - 1114 Piggy-Bank（完全揹包板題）