/ Register

Learn about Centmin Mod LEMP Stack today
Register Now

MariaDB Help me MariaDB 10

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by computer19852007, May 16, 2015.

Tags:
Previous Thread Next Thread
Loading...
  1. May 16, 2015 #1
    computer19852007

    computer19852007 Member

    84
    8
    8
    Jun 25, 2014
    Ratings:
    +9
    Local Time:
    9:49 AM
    Centmin Mod 1.2.3-eva2000.06
    MariaDB 5.5.34
    i have used Centminmod v1.2.3-eva2000.07

    I have a database with MySQL 5.6, i have used mysqldump and backup it, but when i restore to VPS (used Centmin Mod), it show error: ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

    Please help me @eva2000

    Thank you
     
  2. May 16, 2015 #2
    eva2000

    eva2000 Administrator Staff Member

    53,461
    12,128
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,668
    Local Time:
    12:49 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Well it ain't a bug in MariaDB just specific to MySQL config defaults in MariaDB 10 and your specific database's table structure and design. Centmin Mod is provided as is, so such troubleshooting (which would require an understanding of your database table structure) is left up to you.

    Some of the better articles and info on this I found are below, so left up to you - fyi MariaDB 10 while based on MySQL 5.5 is also more inline with MySQL 5.6 too:
    1. Using innodb_large_prefix to avoid ERROR 1071 - Mechanics of Flite
    2. How to understand key length limitations in MySQL · Xaprb
    3. Specified key was too long; max key length is 1000 bytes in mysql 5.6 - Database Administrators Stack Exchange
    4. utf 8 - MySQl: Specified key too long ..max is 1000 bytes? - Server Fault
    5. sql - Mysql::Error: Specified key was too long; max key length is 1000 bytes - Stack Overflow
    6. utf8mb4 - MySQL VARCHAR(255) UTF8 is too long for key, but max length is 1000 bytes - Stack Overflow
    7. Let me google that for you
     
    Last edited: May 16, 2015
  3. May 16, 2015 #3
    computer19852007

    computer19852007 Member

    84
    8
    8
    Jun 25, 2014
    Ratings:
    +9
    Local Time:
    9:49 AM
    Centmin Mod 1.2.3-eva2000.06
    MariaDB 5.5.34
    I tried to handle, but I have not done

    I doing move Code Magento used Centminmod.

    Please Help me @eva2000
     
  4. May 16, 2015 #4
    eva2000

    eva2000 Administrator Staff Member

    53,461
    12,128
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,668
    Local Time:
    12:49 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Unfortunately, I don't have the time for such as I am not familiar with Magento and your specific database table structure. Best to ask on Magento forums Home - Magento Forums
     
  5. May 16, 2015 #5
    eva2000

    eva2000 Administrator Staff Member

    53,461
    12,128
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,668
    Local Time:
    12:49 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Actually, this might help you as it could be simple case of MariaDB 10 defaulting to MyISAM default storage engine in Centmin Mod instead of InnoDB which your MySQL 5.6 server might have had default - see how to switch it back to InnoDB default storage engine at Getting Started Guide
     
  6. May 16, 2015 #6
    computer19852007

    computer19852007 Member

    84
    8
    8
    Jun 25, 2014
    Ratings:
    +9
    Local Time:
    9:49 AM
    Centmin Mod 1.2.3-eva2000.06
    MariaDB 5.5.34
    I have change to default-storage-engine = InnoDB
    But i have restart mysql but it MySQL not Start
     
  7. May 16, 2015 #7
    eva2000

    eva2000 Administrator Staff Member

    53,461
    12,128
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,668
    Local Time:
    12:49 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  8. May 16, 2015 #8
    computer19852007

    computer19852007 Member

    84
    8
    8
    Jun 25, 2014
    Ratings:
    +9
    Local Time:
    9:49 AM
    Centmin Mod 1.2.3-eva2000.06
    MariaDB 5.5.34
    This is a log, Thank @eva2000

    150516 11:01:12 mysqld_safe mysqld from pid file /var/lib/mysql/tongdaitructuyen.com.pid ended
    150516 11:23:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150516 11:23:35

    /usr/sbin/mysqld (mysqld 5.5.43-MariaDB) starting as process 24500 ...
    150516 11:23:35

    Plugin 'InnoDB' is disabled.
    150516 11:23:35

    Plugin 'FEEDBACK' is disabled.
    150516 11:23:35 [ERROR] Unknown/unsupported storage engine: InnoDB
    150516 11:23:35 [ERROR] Aborting

    150516 11:23:35

    /usr/sbin/mysqld: Shutdown complete

    150516 11:23:35 mysqld_safe mysqld from pid file /var/lib/mysql/tongdaitructuyen.com.pid ended

     
    Last edited: May 16, 2015
  9. May 16, 2015 #9
    eva2000

    eva2000 Administrator Staff Member

    53,461
    12,128
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,668
    Local Time:
    12:49 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    InnoDB itself is disabled, you need to comment out and put hash # in front of line skip-innodb in /etc/my.cnf and restart MySQL

    But seriously, if you don't know about InnoDB basics, you want to read up on it as it's nothing like MyISAM tables.
     
Previous Thread Next Thread
Loading...

.