[SOLVED] MySQL : ERROR 1118 (42000) at line 640135: Row size too large (> 8126)

MySQL ERROR Row size too large 8126
Ada yang menarik ketika saya ingin mengimport file database MySQL dari laptop development (dev)  ke laptop deployment (dep). Kebetulan pada laptop dev saya menggunakan mysql versi 5.5 sedangkan untuk laptop dep sudah terpasang mysql versi 5.7. Nah, keanehan yang membuat saya sebal adalah munculnya error seperti ini : ERROR 1118 (42000) at line 640135: Row size too large (> 8126). Dengan modal browsing dan coba-coba akhirnya masalah ini terselesaikan.

Untuk uji cobanya saya menggunakan perintah MySQL berikut:

Buat databasenya terlebih dahulu:
CREATE DATABASE coba;

Pakai databasenya:
USE DATABASE coba;

Buat tabelnya:
CREATE TABLE `rc_organisasi` (
`id` int(11) NOT NULL,
`kdProviderBPJS` varchar(50) NOT NULL,
`kdpus` varchar(50) DEFAULT NULL,
`nmPuskes` varchar(50) DEFAULT NULL,
`status` varchar(50) DEFAULT NULL,
`alamat` varchar(255) DEFAULT NULL,
`kelurahan` varchar(50) DEFAULT NULL,
`kecamatan` varchar(50) DEFAULT NULL,
`kota` varchar(50) DEFAULT NULL,
`provinsi` varchar(50) DEFAULT NULL,
`kdpos` varchar(50) DEFAULT NULL,
`telp` varchar(50) DEFAULT NULL,
`fax` varchar(50) DEFAULT NULL,
`email` varchar(50) DEFAULT NULL,
`koordinat` varchar(100) DEFAULT NULL,
`ktWilayah` varchar(50) DEFAULT NULL,
`ktPenyelenggara` varchar(50) DEFAULT NULL,
`Jumlah_Pusban` int(11) NOT NULL,
`Kepala_Puskesmas` varchar(255) NOT NULL,
`NIP1` varchar(255) NOT NULL,
`Pengelola_Data` varchar(255) NOT NULL,
`NIP2` varchar(255) NOT NULL,
`Petugas_Surveilans` varchar(255) NOT NULL,
`NIP3` varchar(255) NOT NULL,
`pkm_luas_wil` varchar(50) NOT NULL,
`pkm_jml_penduduk` varchar(50) NOT NULL,
`pkm_jml_kel` varchar(50) NOT NULL,
`pkm_jml_kel_miskin` varchar(50) NOT NULL,
`pkm_jml_desa` varchar(50) NOT NULL,
`pkm_perumnas` varchar(50) NOT NULL,
`pkm_transmigrasi` varchar(50) NOT NULL,
`pkm_perkebunan` varchar(50) NOT NULL,
`pkm_nelayanan` varchar(50) NOT NULL,
`pkm_industri` varchar(50) NOT NULL,
`pkm_pariwisata` varchar(50) NOT NULL,
`pkm_kepulauan` varchar(50) NOT NULL,
`pkm_perbatasan` varchar(50) NOT NULL,
`pkm_jml_desa_aktif_pratama` varchar(50) NOT NULL,
`pkm_jml_desa_aktif_siaga_madya` varchar(50) NOT NULL,
`pkm_jml_desa_aktif_purnama` varchar(50) NOT NULL,
`pkm_jml_desa_aktif_siaga_mandiri` varchar(50) NOT NULL,
`pkm_rencana_lima_tahunan` varchar(50) NOT NULL,
`pkm_ruk` varchar(50) NOT NULL,
`pkm_rpk` varchar(50) NOT NULL,
`pkm_rpk_bulanan` varchar(50) NOT NULL,
`pkm_lokakarya_mini_bulanan` varchar(50) NOT NULL,
`pkm_lokakarya_mini_tribulanan` varchar(50) NOT NULL,
`pkm_pkp` varchar(50) NOT NULL,
`pkm_pkp_ditetapkan_dinas_kes_kota` varchar(50) NOT NULL,
`pkm_umpan_balik_dari_dinkes_kabupaten_yang_diterima_pusk` varchar(50) NOT NULL,
`pkm_pelayanan_promosi_kesehatan` varchar(50) NOT NULL,
`pkm_pelayanan_kesehatan_lingkungan` varchar(50) NOT NULL,
`pkm_pel_kes_ibu_anak_kb` varchar(50) NOT NULL,
`pkm_pelayanan_gizi` varchar(50) NOT NULL,
`pkm_pel_pencegahan_dan_pengendalian_penyakit` varchar(50) NOT NULL,
`pkm_pelayanan_kes_jiwa` varchar(50) NOT NULL,
`pkm_pel_kes_gigi_masy` varchar(50) NOT NULL,
`pkm_pel_kes_tradisional_komplementer` varchar(50) NOT NULL,
`pkm_usaha_kes_sekolah` varchar(50) NOT NULL,
`pkm_pel_kes_olah_raga` varchar(50) NOT NULL,
`pkm_pel_kes_indera` varchar(50) NOT NULL,
`pkm_pel_kes_lansia` varchar(50) NOT NULL,
`pkm_pel_kes_kerja` varchar(50) NOT NULL,
`pkm_pel_kes_haji` varchar(50) NOT NULL,
`pkm_poned` varchar(50) NOT NULL,
`pkm_pandu_ptm` varchar(50) NOT NULL,
`pkm_lainnya` varchar(50) NOT NULL,
`pkm_pel_pemeriksaan_umum` varchar(50) NOT NULL,
`pkm_pel_kes_gigi_dan_mulut` varchar(50) NOT NULL,
`pkm_pel_gawat_darurat` varchar(50) NOT NULL,
`pkm_pel_rawat_inap` varchar(50) NOT NULL,
`pkm_pel_satu_hari` varchar(50) NOT NULL,
`pkm_home_care` varchar(50) NOT NULL,
`pkm_pelayanan_kefarmasi` varchar(50) NOT NULL,
`pkm_pelayanan_keperawatan_kes_masy` varchar(50) NOT NULL,
`pkm_pelayanan_laboratorium` varchar(50) NOT NULL,
`pkm_pusk_blud` varchar(50) NOT NULL,
`pkm_akreditasi_nasional` varchar(50) NOT NULL,
`pkm_iso` varchar(50) NOT NULL,
`pkm_pusk_telah_kerjasama_dgn_bpjs` varchar(50) NOT NULL,
`pkm_besar_kapitasi_untk_pusk` varchar(50) NOT NULL,
`pkm_jum_peserta_jkn_terdaftar` varchar(50) NOT NULL,
`pkm_dana_kapitasi_yg_diterima_slma_1_th` varchar(50) NOT NULL,
`pkm_persen_alokasi_dana_kapitasi_jasa_pel_kes` varchar(50) NOT NULL,
`pkm_keg_biaya_kapitasi_dukungan_biaya_operasional_pel_kes` varchar(50) NOT NULL,
`pkm_klinik_pratama` varchar(50) NOT NULL,
`pkm_dokter_praktik_mandiri` varchar(50) NOT NULL,
`pkm_dokter_gigi_praktik_mandiri` varchar(50) NOT NULL,
`pkm_penerima_bantuan_iuran` varchar(50) NOT NULL,
`pkm_non_penerima_bantuan_iuran` varchar(50) NOT NULL,
`pkm_peserta_jamkesda` varchar(50) NOT NULL,
`pkm_peserta_asuransi_komersil` varchar(50) NOT NULL,
`pkm_tahun_dibangun` varchar(50) NOT NULL,
`pkm_luas_tanah_pusk` varchar(50) NOT NULL,
`pkm_sertifikat_tanah` varchar(50) NOT NULL,
`pkm_kepemilikan_tanah` varchar(50) NOT NULL,
`pkm_luas_lantai_dasar_bangunan` varchar(50) NOT NULL,
`pkm_luas_total_lantai_bangunan` varchar(50) NOT NULL,
`pkm_jum_tempat_tdr_perawatan_umum` varchar(50) NOT NULL,
`pkm_jum_tmp_tidur_perawatan_persalinan` varchar(50) NOT NULL,
`pkm_izin_penyelenggaraan_pusk_tgl` varchar(50) NOT NULL,
`pkm_izin_penyelenggaraan_pusk_no_sk` varchar(50) NOT NULL,
`pkm_izin_penyelenggaraan_pusk_oleh` varchar(50) NOT NULL,
`pkm_izin_penyelenggaraan_pusk_masa_berlaku` varchar(50) NOT NULL,
`pkm_registrasi_pusk_tanggal` varchar(50) NOT NULL,
`pkm_registrasi_pusk_no_sk` varchar(50) NOT NULL,
`pkm_akreditasi_pusk_tgl` varchar(50) NOT NULL,
`pkm_akreditasi_pusk_no_sk` varchar(50) NOT NULL,
`pkm_akreditasi_pusk_oleh` varchar(50) NOT NULL,
`pkm_akreditasi_pusk_masa_berlaku` varchar(50) NOT NULL,
`pkm_jrk_pemukiman_terjauh_ke_pusk` varchar(50) NOT NULL,
`pkm_waktu_tempuh_terlama_bagi_warga_menuju_pusk` varchar(50) NOT NULL,
`pkm_akses_jln_dpn_gedung_pusk` varchar(50) NOT NULL,
`pkm_status_jln_raya_terdekat_menuju_ke_pusk` varchar(50) NOT NULL,
`pkm_th_terakhir_pusk_direhabilitasi` varchar(50) NOT NULL,
`pkm_ktpenyelenggara` varchar(50) NOT NULL,
`pkm_keadaan_bangunan_pusk` varchar(50) NOT NULL,
`pkm_pp_baik` varchar(50) NOT NULL,
`pkm_pp_rusak_ringan` varchar(50) NOT NULL,
`pkm_pp_rusak_sedang` varchar(50) NOT NULL,
`pkm_pp_rusak_berat` varchar(50) NOT NULL,
`pkm_bangunan_rumah_dinas_tenaga_kesh_baik` varchar(50) NOT NULL,
`pkm_bangunan_rumah_dinas_tenaga_keshrusak_ringan` varchar(50) NOT NULL,
`pkm_bangunan_rumah_dinas_tenaga_kesh_rusak_sedang` varchar(50) NOT NULL,
`pkm_bangunan_rumah_dinas_tenaga_kesh_rusak_berat` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_1` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_1` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_1` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_1` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_2` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_2` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_2` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_2` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_3` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_3` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_3` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_3` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_4` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_4` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_4` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_4` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_5` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_5` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_5` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_5` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_6` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_6` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_6` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_6` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_7` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_7` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_7` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_7` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_8` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_8` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_8` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_8` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_9` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_9` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_9` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_9` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_10` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_10` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_10` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_10` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_11` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_11` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_11` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_11` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_12` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_12` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_12` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_12` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_13` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_13` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_13` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_13` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_14` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_14` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_14` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_14` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_15` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_15` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_15` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_15` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_16` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_16` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_16` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_16` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_17` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_17` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_17` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_17` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_18` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_18` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_18` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_18` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_19` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_19` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_19` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_19` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_20` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_20` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_20` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_20` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_21` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_21` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_21` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_21` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_22` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_22` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_22` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_22` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_23` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_23` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_23` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_23` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_24` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_24` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_24` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_24` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_25` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_25` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_25` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_25` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_26` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_26` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_26` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_26` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_27` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_27` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_27` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_27` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_28` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_28` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_28` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_28` varchar(50) NOT NULL,
`pkm_rkantor_tersedia_1` varchar(50) NOT NULL,
`pkm_rkantor_thn_pendirian_1` varchar(50) NOT NULL,
`pkm_rkantor_thn_renovasi_1` varchar(50) NOT NULL,
`pkm_rkantor_kondisi_1` varchar(50) NOT NULL,
`pkm_rkantor_tersedia_2` varchar(50) NOT NULL,
`pkm_rkantor_thn_pendirian_2` varchar(50) NOT NULL,
`pkm_rkantor_thn_renovasi_2` varchar(50) NOT NULL,
`pkm_rkantor_kondisi_2` varchar(50) NOT NULL,
`pkm_rkantor_tersedia_3` varchar(50) NOT NULL,
`pkm_rkantor_thn_pendirian_3` varchar(50) NOT NULL,
`pkm_rkantor_thn_renovasi_3` varchar(50) NOT NULL,
`pkm_rkantor_kondisi_3` varchar(50) NOT NULL,
`pkm_rkantor_tersedia_4` varchar(50) NOT NULL,
`pkm_rkantor_thn_pendirian_4` varchar(50) NOT NULL,
`pkm_rkantor_thn_renovasi_4` varchar(50) NOT NULL,
`pkm_rkantor_kondisi_4` varchar(50) NOT NULL,
`pkm_rkantor_tersedia_5` varchar(50) NOT NULL,
`pkm_rkantor_thn_pendirian_5` varchar(50) NOT NULL,
`pkm_rkantor_thn_renovasi_5` varchar(50) NOT NULL,
`pkm_rkantor_kondisi_5` varchar(50) NOT NULL,
`pkm_rpendukung_tersedia_1` varchar(50) NOT NULL,
`pkm_rpendukung_thn_pendirian_1` varchar(50) NOT NULL,
`pkm_rpendukung_thn_renovasi_1` varchar(50) NOT NULL,
`pkm_rpendukung_kondisi_1` varchar(50) NOT NULL,
`pkm_rpendukung_tersedia_2` varchar(50) NOT NULL,
`pkm_rpendukung_thn_pendirian_2` varchar(50) NOT NULL,
`pkm_rpendukung_thn_renovasi_2` varchar(50) NOT NULL,
`pkm_rpendukung_kondisi_2` varchar(50) NOT NULL,
`pkm_rpendukung_tersedia_3` varchar(50) NOT NULL,
`pkm_rpendukung_thn_pendirian_3` varchar(50) NOT NULL,
`pkm_rpendukung_thn_renovasi_3` varchar(50) NOT NULL,
`pkm_rpendukung_kondisi_3` varchar(50) NOT NULL,
`pkm_rpendukung_tersedia_4` varchar(50) NOT NULL,
`pkm_rpendukung_thn_pendirian_4` varchar(50) NOT NULL,
`pkm_rpendukung_thn_renovasi_4` varchar(50) NOT NULL,
`pkm_rpendukung_kondisi_4` varchar(50) NOT NULL,
`pkm_waktu_ketersediaan_listrik` varchar(50) NOT NULL,
`pkm_daya_listrik_terpasang` varchar(50) NOT NULL,
`pkm_jum_genset_yg_berfungsi` varchar(50) NOT NULL,
`pkm_kapasitas_genset_yg_berfungsi` varchar(50) NOT NULL,
`pkm_telepon_kabel` varchar(50) NOT NULL,
`pkm_telepon_seluler` varchar(50) NOT NULL,
`pkm_radio_komunikasi` varchar(50) NOT NULL,
`pkm_alat_komunikasi_lain` varchar(50) NOT NULL,
`pkm_jaringan_internet` varchar(50) NOT NULL,
`pkm_jml_kesling_roda_4_dbl_gardan_baik` varchar(50) NOT NULL,
`pkm_jml_kesling_roda_4_dbl_gardan_rusak_ringan` varchar(50) NOT NULL,
`pkm_jml_kesling_roda_4_dbl_gardan_rusak_berat` varchar(50) NOT NULL,
`pkm_jml_kesling_roda_4_single_gardan_baik` varchar(50) NOT NULL,
`pkm_jml_kesling_roda_4_single_gardan_rusak_ringan` varchar(50) NOT NULL,
`pkm_jml_kesling_roda_4_single_gardan_rusak_berat` varchar(50) NOT NULL,
`pkm_jml_kesling_perairan_baik` varchar(50) NOT NULL,
`pkm_jml_kesling_perairan_rusak_ringan` varchar(50) NOT NULL,
`pkm_jml_kesling_perairan_rusak_berat` varchar(50) NOT NULL,
`pkm_jml_sepeda_motor_baik` varchar(50) NOT NULL,
`pkm_jml_sepeda_motor_rusak_ringan` varchar(50) NOT NULL,
`pkm_jml_sepeda_motor_rusak_berat` varchar(50) NOT NULL,
`pkm_jml_sepeda_baik` varchar(50) NOT NULL,
`pkm_jml_sepeda_rusak_ringan` varchar(50) NOT NULL,
`pkm_jml_sepeda_rusak_berat` varchar(50) NOT NULL,
`pkm_kendaraan_ambulan_baik` varchar(50) NOT NULL,
`pkm_kendaraan_ambulan_rusak_ringan` varchar(50) NOT NULL,
`pkm_kendaraan_ambulan_rusak_berat` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_puskesmas_air_bersih` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_air_bersih_24_jam` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_sumber_air_bersih` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_jamban` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_sarana_pengelolaan_limbah` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_sarana_pengelolaan_limbah_padat` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_sarana_pengelolaan_limbah_cair` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_sarana_pengelolaan_limbah_septiktank` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_mou_limbah_padat_b3_ke_pihak_berijin` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_mou_limbah_cair_ke_pihak_berijin` varchar(50) NOT NULL,
`pkm_sistem_gas_medik_jml_berfungsi` varchar(50) NOT NULL,
`pkm_sistem_gas_medik_jml_oksigen_konsentrator_berfungsi` varchar(50) NOT NULL,
`pkm_sistem_gas_medik_jml_oksigen_konsentrator_tidak_berfungsi` varchar(50) NOT NULL,
`pkm_jml_alat_pemadam_kebakaran_berfungsi` varchar(50) NOT NULL,
`pkm_jml_alat_pemadam_kebakaran_tidak_berfungsi` varchar(50) NOT NULL,
`pkm_sistem_proteksi_petir` varchar(50) NOT NULL,
`pkm_jml_ac_berfungsi` varchar(50) NOT NULL,
`pkm_jml_ac__tidak_berfungsi` varchar(50) NOT NULL,
`jml_puskesmas_pembantu` varchar(50) NOT NULL,
`jml_bidan_desa` varchar(50) NOT NULL,
`kesling` varchar(50) NOT NULL,
`jml_klinik_pratama` varchar(50) NOT NULL,
`jml_klinik_utama` varchar(50) NOT NULL,
`jml_dokter_praktik_mandiri` varchar(50) NOT NULL,
`jml_dokter_gigi_praktik_mandiri` varchar(50) NOT NULL,
`jml_bidan_praktik_swasta` varchar(50) NOT NULL,
`jml_perawat_praktik_mandiri` varchar(50) NOT NULL,
`jml_rumah_sakit_kelas_D_pratama` varchar(50) NOT NULL,
`jml_apotek` varchar(50) NOT NULL,
`jml_optik` varchar(50) NOT NULL,
`jml_laboratorium_klinik` varchar(50) NOT NULL,
`program_kerjasama_rs_darah` varchar(50) NOT NULL,
`jml_rutan_lapas` varchar(50) NOT NULL,
`posyandu_pratama` varchar(50) NOT NULL,
`posyandu_madya` varchar(50) NOT NULL,
`posyandu_purnama` varchar(50) NOT NULL,
`posyandu_mandiri` varchar(50) NOT NULL,
`posyandu_lansia` varchar(50) NOT NULL,
`jml_poskesdes` varchar(50) NOT NULL,
`jml_poskestren` varchar(50) NOT NULL,
`jml_posbindu_ptm_aktif` varchar(50) NOT NULL,
`jml_desa_posbindu_ptm_aktif` varchar(50) NOT NULL,
`jml_pos_tb_desa_aktif` varchar(50) NOT NULL,
`jml_posmaldes_aktif` varchar(50) NOT NULL,
`pos_ukk_pratama` varchar(50) NOT NULL,
`pos_ukk_madya` varchar(50) NOT NULL,
`pos_ukk_purnama` varchar(50) NOT NULL,
`pos_ukk_mandiri` varchar(50) NOT NULL,
`jml_pod` varchar(50) NOT NULL,
`jml_polindes` varchar(50) NOT NULL,
`jml_desa_kegiatan_dana_sehat` varchar(50) NOT NULL,
`jml_peserta_dana_sehat` varchar(50) NOT NULL,
`jml_ukbm_lainnya` varchar(50) NOT NULL,
`jml_kelompok_kerja_operasional_ukbm` varchar(50) NOT NULL,
`jml_pokjanal_posyandu` varchar(50) NOT NULL,
`jml_forum_peduli_kesehatan` varchar(50) NOT NULL,
`jml_forum_desa_siaga_buah_aktif` varchar(50) NOT NULL,
`kader_posyandu` varchar(50) NOT NULL,
`kader_poskesdes` varchar(50) NOT NULL,
`kader_poskestren` varchar(50) NOT NULL,
`petugas_pelaksana_posbindu_ptm` varchar(50) NOT NULL,
`kader_pos_tb_desa` varchar(50) NOT NULL,
`kader_posmaldes` varchar(50) NOT NULL,
`kader_pos_ukk` varchar(50) NOT NULL,
`kader_desa_siaga_aktif` varchar(50) NOT NULL,
`organisasi_kemasyarakatan` varchar(50) NOT NULL,
`dunia_usaha` varchar(50) NOT NULL,
`ingo` varchar(50) NOT NULL,
`mitra_lainnya` varchar(50) NOT NULL,
`jml_kebijakan_publik_berwawasan_kesehatan` varchar(50) NOT NULL,
`puskesmas_wahana_pendidikan_tenaga` varchar(50) NOT NULL,
`pelayanan_kesehatan_begerak` varchar(50) NOT NULL,
`jml_sd` varchar(50) NOT NULL,
`jml_sltp` varchar(50) NOT NULL,
`jml_slta` varchar(50) NOT NULL,
`nik` varchar(50) NOT NULL,
`nip_nrp` varchar(50) NOT NULL,
`no_seri_kartu_pegawai` varchar(50) NOT NULL,
`nama_lengkap` varchar(50) NOT NULL,
`gelar_depan_nama` varchar(50) NOT NULL,
`gelar_belakang_nama` varchar(50) NOT NULL,
`jenis_kelamin` varchar(50) NOT NULL,
`tempat_lahir` varchar(50) NOT NULL,
`tanggal_lahir` varchar(50) NOT NULL,
`agama` varchar(50) NOT NULL,
`status_perkawinan` varchar(50) NOT NULL,
`alamat_email` varchar(50) NOT NULL,
`telp_hp` varchar(50) NOT NULL,
`tanggal_berlaku_str` varchar(50) NOT NULL,
`tanggal_berlaku_stp` varchar(50) NOT NULL,
`tanggal_berlaku_sik` varchar(50) NOT NULL,
`status_kepegawaian` varchar(50) NOT NULL,
`tmt_CPNS` varchar(50) NOT NULL,
`tmt_PNS` varchar(50) NOT NULL,
`tanggal_mulai_melaksanakan_tugas` varchar(50) NOT NULL,
`tanggal_berakhir_melaksanakan_tugas` varchar(50) NOT NULL,
`pendidikan_waktu_pengangkatan_pertama` varchar(50) NOT NULL,
`kode_sdmk` varchar(50) NOT NULL,
`pendidikan_tertinggi_saat_ini` varchar(50) NOT NULL,
`instansi_induk` varchar(50) NOT NULL,
`jenis_kepegawaian` varchar(50) NOT NULL,
`golongan_terakhir` varchar(50) NOT NULL,
`tmt_golongan` varchar(50) NOT NULL,
`masa_kerja_golongan` varchar(50) NOT NULL,
`nama_tempat_bekerja_sekarang` varchar(50) NOT NULL,
`nama_unit_kerja` varchar(50) NOT NULL,
`tanggal_mulai_tugas_unit_kerja` varchar(50) NOT NULL,
`desa_kelurahan` varchar(50) NOT NULL,
`kabupaten_kota` varchar(50) NOT NULL,
`chk_lokasi_gdg` varchar(50) NOT NULL,
`chk_kendaraan_jalan` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Lihat, tabel yang saya buat mempunyai kolom yang sangat banyak. Ketika saya melakukan impor dengan versi yang sama (5.5 ke 5.5) tidak jadi masalah, tapi ketika saya impor ke versi yang lebih baru (5.5 ke 5.7). Error tersebut kemudian muncul dan membuat proses impor gagal. Dan errornya pada pembuatan tabel tersebut.

Oke, akhirnya saya browsing-browsing dan ketemu penyelesaiannya. Ternyata permasalahan ada pada fitur keamanan dari MySQL versi 5.7 dimana variabel innodb_strict_mode masih ON. Cara melihatnya masih aktif atau tidak bisa menggunakan perintah MySQL berikut:

show variables like '%strict%';

innodb_strict_mode : ON
innodb_strict_mode : ON

Untuk menonaktifkannya, gunakan perintah MySQL berikut:

set innodb_strict_mode = 'OFF';

perintah MySQL untuk menon-aktifkan innodb_strict_mode
perintah MySQL untuk menon-aktifkan innodb_strict_mode
 innodb_strict_mode : OFF
 innodb_strict_mode : OFF


Lalu silakan coba ulangi membuat tabel tersebut. Taraaa, akhirnya sukses kan. Alhamdulillah.

Jika ada yang masih mengalami error silakan edit file my.cfg (linux) atau file my.ini (windows), tambahkan script berikut:

[mysqld]
max_allowed_packet = 1G
innodb_log_file_size = 2G
innodb_log_buffer_size = 512M
innodb_file_per_table
innodb_file_format = Barracuda

setting di my.cfg / my.ini
setting di my.cfg / my.ini

Semoga membantu.
Salam.

0 Response to "[SOLVED] MySQL : ERROR 1118 (42000) at line 640135: Row size too large (> 8126)"

Posting Komentar