MRatWork Forum by Mustafa Ramadhan - MariaDB gagal import backup SQL

Sponsor:
Server and Web Integrator
Link:
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:

MRatWork Forum | Please login or register. | 2017-11-07, 23:14:17

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- MariaDB gagal import backup SQL

« previous next »

- Print

Pages: [1] Go Down

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

0 Members and 1 Guest are viewing this topic.

#### redpages

- Senior Member
- Posts: 316
- Karma: +0/-0

##### 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

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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!) --

#### zenkul

- Global Moderator
- Master
- Posts: 383
- Karma: +3/-0

##### 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

- Print

Pages: [1] Go Up
« previous next »

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- MariaDB gagal import backup SQL

Top 4 Global Search Engines: Google Bing Baidu Yahoo

- Design By SMFSimple.com
- SMF 2.0.14 | SMF © 2017, Simple Machines

Page created in 0.03 seconds with 18 queries.

Mirror created by MasterkinG32.CoM