Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-05-23, 21:15:33
« previous next »
Pages: [1]   Go Down

Author Topic: MariaDB gagal import backup SQL  (Read 2398 times)

0 Members and 1 Guest are viewing this topic.

Offline redpages

  • Master
  • **
  • Posts: 372
  • Karma: +0/-0
    • View Profile
MariaDB gagal import backup SQL
« on: 2015-07-29, 19:07:19 »
Dear masta,

Saya mau install jibas di VPS. Tapi saat import sql ditengah jalan berhenti dengan warning : "ERROR 1071 (42000) at line 8317: Specified key was too long; max key length is 1000 bytes."

Apakah ini terkait database yang menggunakan MariaDB? Adakah solusi mengatasi error tersebut?

Sysinfo VPS
Quote
A. Kloxo-MR: 7.0.0.b-2015072103
   - Web: hiawatha-9.13.0-f.6.mr.el6.i386
   - PHP: php54s-5.4.43-1.ius.el6 (cgi mode)
B. Plateform:
   - OS: CentOS release 6.6 (Final) i686
   - Hostname: server100.xbackbone.com
C. Services:
   1. MySQL: MariaDB-server-10.0.20-1.el6.i686
   2. PHP:
      - Branch: php54-cli-5.4.43-1.ius.el6.i686
      - Used: --Use PHP Branch--
   3. Httpd: --uninstalled--
      - PHP Type: suphp
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: nginx-1.9.3-1.el6.ngx.i386
   7. Cache: --uninstalled--
   8. Dns: nsd-4.1.3-1.mr.el6.i386
   9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1024        177        846         70          0        163
   -/+ buffers/cache:         14       1009
   Swap:            0          0          0
E. Disk Space:
   Filesystem      Size  Used Avail Use% Mounted on
   /dev/simfs       30G  2.2G   28G   8% /
Logged

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MariaDB gagal import backup SQL
« Reply #1 on: 2015-07-29, 19:53:23 »
Tidak terkait dengan MariaDB atau MySQL tapi isi sql sendiri yang bermasalah (Specified key was too long; max key length is 1000 bytes)
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline zenkul

  • Global Moderator
  • Master
  • *****
  • Posts: 383
  • Karma: +3/-0
    • View Profile
    • home & decor
Re: MariaDB gagal import backup SQL
« Reply #2 on: 2015-07-30, 11:03:40 »
barusan saya seperti itu, waktu mau downgrade web
sql saya kosongkan dulu, baru kemudian import dari /tmp/

browsing aja, pasti banyak petunjuk, krn dia masalah umum
Logged
easy, secure and speed up web panel ===> Kloxo-MR
Pages: [1]   Go Up
« previous next »
 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.033 seconds with 22 queries.

web stats analysis