Welcome to Centmin Mod Community
Register Now

MariaDB Help me MariaDB 10

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

  1. computer19852007

    computer19852007 Member

    53
    5
    8
    Jun 25, 2014
    Ratings:
    +5
    Local Time:
    10:33 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. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    1:33 PM
    Nginx 1.13.x
    MariaDB 5.5
    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
    • Like Like x 1
  3. computer19852007

    computer19852007 Member

    53
    5
    8
    Jun 25, 2014
    Ratings:
    +5
    Local Time:
    10:33 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. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    1:33 PM
    Nginx 1.13.x
    MariaDB 5.5
    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. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    1:33 PM
    Nginx 1.13.x
    MariaDB 5.5
    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. computer19852007

    computer19852007 Member

    53
    5
    8
    Jun 25, 2014
    Ratings:
    +5
    Local Time:
    10:33 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. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    1:33 PM
    Nginx 1.13.x
    MariaDB 5.5
  8. computer19852007

    computer19852007 Member

    53
    5
    8
    Jun 25, 2014
    Ratings:
    +5
    Local Time:
    10:33 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. eva2000

    eva2000 Administrator Staff Member

    30,161
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    1:33 PM
    Nginx 1.13.x
    MariaDB 5.5
    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.