Ao tentar restaurar um backup no MySQL recebi a mensagem de erro:<\/p>\n
ERROR 1118 (42000) at line 667: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.<\/p>\n
Isto \u00e9 um problema causado por um Bug do InnoDB que pode ser consertado da seguinte maneira:<\/p>\n
Encontre seu arquivo de configura\u00e7\u00e3o do MySQL. Caso voc\u00ea n\u00e3o saiba onde se localiza (ele pode mudar de pasta de acordo com o sistema que voc\u00ea est\u00e1 utilizando), utilizeo o comando abaixo e localize o arquivo que tenha a se\u00e7\u00e3o [mysqld]:<\/p>\n
[code]
sudo find \/ -name "*.cnf"
[\/code]<\/p>\n
Depois de encontrar o arquivo de configura\u00e7\u00e3o do MySQL, abra-o:<\/p>\n
[code]
sudo nano \/etc\/mysql\/mysql.conf.d\/mysqld.cnf
[\/code]<\/p>\n
Adicione as duas linhas abaixo \u00e0 se\u00e7\u00e3o [mysqld] (Configura\u00e7\u00f5es B\u00e1sicas do MySQL):<\/p>\n
[code]
innodb_log_file_size = 256M
innodb_strict_mode = 0
[\/code]<\/p>\n
Salve as modifica\u00e7\u00f5es e reinicie o servidor MySQL:<\/p>\n
[code]
sudo \/etc\/init.d\/mysql restart
[\/code]<\/p>\n
Apague os dados e estruturas j\u00e1 criadas na tentativa de restaura\u00e7\u00e3o anterior do banco de dados; e realize uma nova tentativa de restaurar o banco de dados:<\/p>\n
[code]
mysql -uUSUARIO -pSENHA NOMEDOBANCODEDADOS < ARQUIVO.sql
[\/code]<\/p>\n","protected":false},"excerpt":{"rendered":"
Ao tentar restaurar um backup no MySQL recebi a mensagem de erro: ERROR 1118 (42000) at line 667: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. Isto \u00e9 um problema causado por um Bug do InnoDB […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"categories":[383,633,399],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.pauloacosta.com\/wp-json\/wp\/v2\/posts\/1201"}],"collection":[{"href":"https:\/\/www.pauloacosta.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pauloacosta.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pauloacosta.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pauloacosta.com\/wp-json\/wp\/v2\/comments?post=1201"}],"version-history":[{"count":0,"href":"https:\/\/www.pauloacosta.com\/wp-json\/wp\/v2\/posts\/1201\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.pauloacosta.com\/wp-json\/wp\/v2\/media?parent=1201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pauloacosta.com\/wp-json\/wp\/v2\/categories?post=1201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pauloacosta.com\/wp-json\/wp\/v2\/tags?post=1201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}