{"id":1888,"date":"2020-12-15T11:52:39","date_gmt":"2020-12-15T04:52:39","guid":{"rendered":"https:\/\/www.domosquare.com\/tutorial\/?p=1888"},"modified":"2020-12-15T11:52:41","modified_gmt":"2020-12-15T04:52:41","slug":"solusi-error-row-size-too-large-8126","status":"publish","type":"post","link":"https:\/\/www.domosquare.com\/tutorial\/hosting\/solusi-error-row-size-too-large-8126.html","title":{"rendered":"Solusi error Row size too large (> 8126)"},"content":{"rendered":"\n<p>Pada tutorial kali ini terdapat solusi error saat import file SQL dengan error seperti:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to \nTEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored \ninline.<\/code><\/pre>\n\n\n\n<p>Untuk mengatasi itu maka silahkan ganti ROW_FORMAT pada table yang diinformasikan saat error menjadi ROW_FORMAT=DYNAMIC.<\/p>\n\n\n\n<p>Contoh pada gambar terlihat error saat create table:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"308\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/12\/image-1-1024x308.png\" alt=\"\" class=\"wp-image-1889\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/12\/image-1-1024x308.png 1024w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/12\/image-1-300x90.png 300w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/12\/image-1-768x231.png 768w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2020\/12\/image-1.png 1083w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>error Row size too large (> 8126)<\/figcaption><\/figure>\n\n\n\n<p>Jadi sebelum mengulangi importnya, silahkan rumah dahulu type ROW format di file SQL nya contoh:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci ROW_FORMAT=COMPACT;<\/code><\/pre>\n\n\n\n<p>Menjadi:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci ROW_FORMAT=DYNAMIC;<\/code><\/pre>\n\n\n\n<p>Nah seharusnya jika di import lagi file SQL nya, errornya akan hilang &#x1f601;<\/p>\n\n\n\n<p>Jangan sungkan hubungi Kami jika Anda membutuhkan Kami.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pada tutorial kali ini terdapat solusi error saat import file SQL dengan error seperti: Untuk mengatasi itu maka silahkan ganti ROW_FORMAT pada table yang diinformasikan saat error menjadi ROW_FORMAT=DYNAMIC. Contoh pada gambar terlihat error saat create table: Jadi sebelum mengulangi importnya, silahkan rumah dahulu type ROW format di file SQL nya contoh: Menjadi: Nah seharusnya [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"rating_form_position":"","rating_results_position":"","mr_structured_data_type":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1],"tags":[820,814,815,819],"class_list":["post-1888","post","type-post","status-publish","format-standard","hentry","category-hosting","tag-database","tag-mariadb","tag-mysql","tag-sql"],"jetpack_featured_media_url":"","multi-rating":{"mr_rating_results":[{"adjusted_star_result":0,"star_result":0,"total_max_option_value":5,"adjusted_score_result":0,"score_result":0,"percentage_result":0,"adjusted_percentage_result":0,"count":0,"post_id":1888}]},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/1888","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/comments?post=1888"}],"version-history":[{"count":1,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/1888\/revisions"}],"predecessor-version":[{"id":1890,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/1888\/revisions\/1890"}],"wp:attachment":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/media?parent=1888"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/categories?post=1888"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/tags?post=1888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}