Welcome to Centmin Mod Community
Register Now

MariaDB Error importing sql database: Row size too large (> 8126)

Discussion in 'Install & Upgrades or Pre-Install Questions' started by 1121, Nov 29, 2018.

  1. 1121

    1121 New Member

    13
    1
    3
    Nov 29, 2018
    Ratings:
    +2
    Local Time:
    2:46 AM
    1.15.7
    MariaDB 10.1.37
    Hello, I am having difficulties installing FunnelFlux tracker application on Centminmod server. For some reason some tables would not get created when installing the script. I then tried to setup the tracker on ServerPilot server and it worked without issues. So I backed up the sql from the working setup and tried to import it to Centminmod server. That is when I stumbled on the mysql error below:

    ERROR 1118 (42000) at line 1525: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

    I tried couple of suggested edits to my.cnf such as
    innodb_strict_mode = 0
    and increasing log size
    innodb_log_file_size=10000M

    but none are working to fix this. Any ideas as to how to fix this? I think that is why the Funnelflux application cannot create the tables in the first place. I already have 2 working WordPress installations as well as Mautic on this Centminmod server. Thanks!
    ===============

    Please fill in any relevant information that applies to you:
    • CentOS Version: CentOS 7 64bit
    • Centmin Mod Version Installed: 123.09beta01
    • Nginx Version Installed: 1.15.7
    • PHP Version Installed: 7.0.32
    • MariaDB MySQL Version Installed: 10.1.37
    • When was last time updated Centmin Mod code base ? : today
     
  2. Jimmy

    Jimmy Premium Member Premium Member

    1,420
    293
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +725
    Local Time:
    2:46 AM
    1.13.x
    MariaDB 10.1.x
    I usually do this before importing large databases. After, I switch it back.

    Code:
    global net_buffer_length=1000000
    max_allowed_packet=10000M
     
  3. 1121

    1121 New Member

    13
    1
    3
    Nov 29, 2018
    Ratings:
    +2
    Local Time:
    2:46 AM
    1.15.7
    MariaDB 10.1.37
    Thanks, just tried it but still the same error. The db size is only 100kb.
     
    • Informative Informative x 1
  4. eva2000

    eva2000 Administrator Staff Member

    37,227
    8,133
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,521
    Local Time:
    5:46 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    problem is database structure you have for the database you are trying to import

    how did you back up and restore the database ? exact commands ?
    from MySQL Bugs: #69336: "Row size too large" error thrown even when it's not.

    what's output for commands below
    Code (Text):
    mysqladmin ver
    

    Code (Text):
    mysqladmin var | egrep 'innodb_file_format|innodb_file_per_table|innodb_large_prefix|innodb_strict_mode' | tr -s ' '
    

    Centmin Mod 123.09beta01 already enables Barracuda file format and innodb large prefix and per table settings
    Code (Text):
    mysqladmin var | egrep 'innodb_file_format|innodb_file_per_table|innodb_large_prefix|innodb_strict_mode' | tr -s ' '
    | innodb_file_format | Barracuda |
    | innodb_file_format_check | ON |
    | innodb_file_format_max | Antelope |
    | innodb_file_per_table | ON |
    | innodb_large_prefix | ON |
    | innodb_strict_mode | OFF |
    
     
  5. eva2000

    eva2000 Administrator Staff Member

    37,227
    8,133
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,521
    Local Time:
    5:46 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    If you know how, you can edit the backup sql file's create table statement for the table causing issues and add ROW_FORMAT=DYNAMIC and see if that works

    example if database backup sql file has table named table_two
    Code (Text):
    --
    -- Table structure for table `table_two`
    --
    
    DROP TABLE IF EXISTS `table_two`;
    /*!40101 SET @saved_cs_client     = @@character_set_client */;
    /*!40101 SET character_set_client = utf8 */;
    CREATE TABLE `table_two` (
      `col1` bigint(5) NOT NULL AUTO_INCREMENT,
      `col2` varchar(50) DEFAULT NULL,
      `col3` varchar(64) DEFAULT NULL,
      PRIMARY KEY (`col1`)
    ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
    /*!40101 SET character_set_client = @saved_cs_client */;
    

    change line from
    Code (Text):
    ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
    

    to
    Code (Text):
    ) ENGINE=InnoDB AUTO_INCREMENT=16 ROW_FORMAT=DYNAMIC CHARSET=utf8;
    
     
    Last edited: Nov 29, 2018
  6. 1121

    1121 New Member

    13
    1
    3
    Nov 29, 2018
    Ratings:
    +2
    Local Time:
    2:46 AM
    1.15.7
    MariaDB 10.1.37
    Thanks, George for the suggestions. I had to completely reset the OS install and try from scratch. Funnelflux would be the first host to be installed. Still no go. Some tables get created, some do not.
    Something in Funnelflux seems to be incompatible with the way Centminmod is setup, as the Servepilot stack does not have this issue. Hopefully Funnelflux support can fix this issue.
     
  7. eva2000

    eva2000 Administrator Staff Member

    37,227
    8,133
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,521
    Local Time:
    5:46 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    the limit is in innodb tables not myisam, so if serverpilot setup database as myisam table (less performant) then you may not run into the limitation imposed on innodb tables. Centmin Mod by default creates innodb tables unless your backup's create table statements specify an engine type specifically i.e. innodb or myisam. But yes Funnelflux is ultimately the folks who need to update their database structure to meet innodb limits.
     
  8. eva2000

    eva2000 Administrator Staff Member

    37,227
    8,133
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,521
    Local Time:
    5:46 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    @jdan1457 and @RB1 both use funnelflux from quick forum search. Maybe they have ideas ?
     
  9. 1121

    1121 New Member

    13
    1
    3
    Nov 29, 2018
    Ratings:
    +2
    Local Time:
    2:46 AM
    1.15.7
    MariaDB 10.1.37
    This has not been properly resolved with clean Centminmod setup, but I do have an update that made the script work. George or other database experts may be able to enlighten as to what setting actually made a difference and what may have prevented the tables from being created in the Centminmod.

    Here is how I made it work:

    FunnelFlux docs has a series of .sh scripts for Centos 7 that take care of the whole setup, including nginx, mysql and other requirements. When I run those scripts on clean (without Centminmod) Centos machine, FunnelFlux script installed fully and all tables got created. So I thought since the issues are in db tables creation, there must be something in the mysql settings in Centminmod my.cnf.
    I then copied the my.cnf settings from this working FunnelFlux machine and then reformatted the VPS again. This time I installed the Centminmod and created the v-host through option 2 and database/user as described in the docs. However, before I executed the FunnelFlux browser based setup script, I completely replaced the content of Centminmod my.cnf with the content of my.cnf of the previously working FunnelFlux stack (without the Centminmod). I then restarted the machine and executed the browser based setup script. This time the tables got created and there was no issue.

    Below are the 2 versions of the mysql config file: 1st from the FunnelFlux stack and the 2nd from Centminmod. Can anyone tell what line(s) from the FunnelFlux likely made the difference in the successful installation? I would like to adapt the Centminmod version with the appropriate FunnelFlux lines. I may need to put the Centminmod version back as I am not sure how negatively lack of it may affect the function of Centminmod.

    Funnelflux version:
    Code (Text):
    [mysqld]
    character-set-server=utf8
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    
    back_log = 75
    max_connections = 600
    key_buffer_size = 32M
    myisam_sort_buffer_size = 32M
    myisam_max_sort_file_size = 2048M
    join_buffer_size = 4M
    read_buffer_size = 512K
    sort_buffer_size = 128K
    table_definition_cache = 4096
    table_open_cache = 2048
    thread_cache_size = 64
    wait_timeout = 120
    connect_timeout = 10
    tmp_table_size = 32M
    max_heap_table_size = 32M
    max_allowed_packet = 512M
    
    
    max_seeks_for_key = 1000
    group_concat_max_len = 1024
    max_length_for_sort_data = 1024
    net_buffer_length = 16384
    max_connect_errors = 100000
    concurrent_insert = 2
    read_rnd_buffer_size = 256K
    bulk_insert_buffer_size = 8M
    query_cache_limit = 512K
    query_cache_size = 16M
    query_cache_type = 0
    query_cache_min_res_unit = 2K
    query_prealloc_size = 262144
    query_alloc_block_size = 65536
    transaction_alloc_block_size = 8192
    transaction_prealloc_size = 4096
    
    log_warnings=0
    slow_query_log=0
    long_query_time=5
    slow_query_log_file=/var/lib/mysql/slowq.log
    log_error=/var/log/mysql/mysqld.log
    
    innodb_purge_threads=1
    
    innodb_file_per_table = 1
    innodb_open_files = 1000
    innodb_data_file_path= ibdata1:10M:autoextend
    innodb_buffer_pool_size=6402M
    
    innodb_log_files_in_group = 2
    innodb_log_file_size = 2G
    innodb_log_buffer_size = 8M
    innodb_flush_log_at_trx_commit = 0
    innodb_thread_concurrency = 6
    innodb_lock_wait_timeout=50
    innodb_flush_method = O_DIRECT
    innodb_support_xa=1
    
    # 200 * # DISKS
    innodb_io_capacity = 100
    innodb_read_io_threads = 4
    innodb_write_io_threads = 8
    
    # mariadb settings
    [mariadb]
    
    userstat = 0
    key_cache_segments = 1
    aria_group_commit = none
    aria_group_commit_interval = 0
    aria_log_file_size = 32M
    aria_log_purge_type = immediate
    aria_pagecache_buffer_size = 8M
    aria_sort_buffer_size = 8M
    
    query_cache_strip_comments=0
    
    log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
    
    [mysqld_safe]
    socket=/var/lib/mysql/mysql.sock
    log_error=/var/log/mysqld.log
    open-files-limit = 16192
    
    [mysqldump]
    quick
    max_allowed_packet = 32M
    
    [myisamchk]
    key_buffer = 32M
    sort_buffer = 16M
    read_buffer = 16M
    write_buffer = 16M
    
    [mysqlhotcopy]
    interactive-timeout


    Centminmod my.cnf:

    Code (Text):
    [client]
    socket=/var/lib/mysql/mysql.sock
    
    [mysql]
    max_allowed_packet = 128M
    
    [mysqld]
    ignore_db_dirs=cmsetiofiotest
    local-infile=0
    ignore_db_dirs=lost+found
    character-set-server=utf8
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    
    #bind-address=127.0.0.1
    # optimized my.cnf for MariaDB 5.5.x
    # by eva2000
    # vbtechsupport.com
    
    tmpdir=/home/mysqltmp
    
    innodb=ON
    #skip-federated
    ##skip-pbxt
    ##skip-pbxt_statistics
    #skip-archive
    #skip-name-resolve
    #old_passwords
    back_log = 1024
    max_connections = 1000
    key_buffer_size = 768M
    myisam_sort_buffer_size = 768M
    myisam_max_sort_file_size = 8192M
    join_buffer_size = 2M
    read_buffer_size = 2M
    sort_buffer_size = 2M
    table_definition_cache = 10240
    table_open_cache = 10240
    thread_cache_size = 384
    wait_timeout = 1800
    connect_timeout = 10
    tmp_table_size = 1024M
    max_heap_table_size = 1024M
    max_allowed_packet = 128M
    #max_seeks_for_key = 4294967295
    #group_concat_max_len = 1024
    max_length_for_sort_data = 1024
    net_buffer_length = 16384
    max_connect_errors = 100000
    concurrent_insert = 2
    read_rnd_buffer_size = 512K
    bulk_insert_buffer_size = 8M
    # query_cache boost for MariaDB >10.1.2+
    # https://community.centminmod.com/posts/30811/
    query_cache_limit = 1536K
    query_cache_size = 256M
    query_cache_type = 1
    query_cache_min_res_unit = 2K
    query_prealloc_size = 262144
    query_alloc_block_size = 65536
    transaction_alloc_block_size = 8192
    transaction_prealloc_size = 4096
    default-storage-engine = InnoDB
    
    log_warnings=1
    slow_query_log=0
    long_query_time=1
    slow_query_log_file=/var/lib/mysql/slowq.log
    #log-error=/var/log/mysqld.log
    
    # innodb settings
    innodb_large_prefix=1
    innodb_purge_threads = 2
    innodb_file_format = Barracuda
    innodb_file_per_table = 1
    innodb_open_files = 10000
    innodb_data_file_path= ibdata1:10M:autoextend
    innodb_buffer_pool_size = 8192M
    
    ## https://mariadb.com/kb/en/mariadb/xtradbinnodb-server-system-variables/#innodb_buffer_pool_instances
    innodb_buffer_pool_instances=8
    
    innodb_log_files_in_group = 2
    innodb_log_file_size = 768M
    innodb_log_buffer_size = 16M
    innodb_flush_log_at_trx_commit = 2
    #innodb_thread_concurrency = 12
    innodb_lock_wait_timeout=50
    innodb_flush_method = O_DIRECT
    innodb_support_xa=1
    
    # 200 * # DISKS
    innodb_io_capacity = 2400
    innodb_io_capacity_max = 4800
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    innodb_flush_neighbors = 0
    
    # mariadb settings
    [mariadb]
    #thread-handling = pool-of-threads
    #thread-pool-size= 20
    #mysql --port=3307 --protocol=tcp
    #extra-port=3307
    #extra-max-connections=1
    
    userstat = 0
    key_cache_segments = 1
    aria_group_commit = none
    aria_group_commit_interval = 0
    aria_log_file_size = 1024M
    aria_log_purge_type = immediate
    aria_pagecache_buffer_size = 1024M
    aria_sort_buffer_size = 256M
    
    [mariadb-5.5]
    innodb_file_format = Barracuda
    innodb_file_per_table = 1
    
    #ignore_db_dirs=
    query_cache_strip_comments=0
    
    innodb_read_ahead = linear
    innodb_adaptive_flushing_method = estimate
    innodb_flush_neighbor_pages = 1
    innodb_stats_update_need_lock = 0
    innodb_log_block_size = 512
    
    log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
    
    [mysqld_safe]
    socket=/var/lib/mysql/mysql.sock
    #log-error=/var/log/mysqld.log
    #nice = -5
    open-files-limit = 8192
    
    [mysqldump]
    quick
    max_allowed_packet = 128M
    
    [myisamchk]
    tmpdir=/home/mysqltmp
    key_buffer = 1024M
    sort_buffer = 256M
    read_buffer = 256M
    write_buffer = 256M
    
    [mysqlhotcopy]
    interactive-timeout
    
    [mariadb-10.0]
    innodb_file_format = Barracuda
    innodb_file_per_table = 1
    
    # 2 variables needed to switch from XtraDB to InnoDB plugins
    #plugin-load=ha_innodb
    #ignore_builtin_innodb
    
    ## MariaDB 10 only save and restore buffer pool pages
    ## warm up InnoDB buffer pool on server restarts
    #innodb_buffer_pool_dump_at_shutdown=1
    #innodb_buffer_pool_load_at_startup=1
    innodb_buffer_pool_populate=0
    ## Disabled settings
    performance_schema=OFF
    innodb_stats_on_metadata=OFF
    innodb_sort_buffer_size=2M
    innodb_online_alter_log_max_size=128M
    query_cache_strip_comments=0
    log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
    
    [mariadb-10.1]
    innodb_file_format = Barracuda
    innodb_default_row_format = dynamic
    innodb_file_per_table = 1
    
    ## wsrep specific
    # wsrep_on=OFF
    # wsrep_provider
    # wsrep_cluster_address
    # binlog_format=ROW
    # default_storage_engine=InnoDB
    # innodb_autoinc_lock_mode=2
    # innodb_doublewrite=1
    # query_cache_size=0
    
    # 2 variables needed to switch from XtraDB to InnoDB plugins
    #plugin-load=ha_innodb
    #ignore_builtin_innodb
    
    ## MariaDB 10 only save and restore buffer pool pages
    ## warm up InnoDB buffer pool on server restarts
    #innodb_buffer_pool_dump_at_shutdown=1
    #innodb_buffer_pool_load_at_startup=1
    innodb_buffer_pool_populate=0
    ## Disabled settings
    performance_schema=OFF
    innodb_stats_on_metadata=OFF
    innodb_sort_buffer_size=2M
    innodb_online_alter_log_max_size=128M
    query_cache_strip_comments=0
    log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
    
    # Defragmenting unused space on InnoDB tablespace
    innodb_defragment=1
    innodb_defragment_n_pages=7
    innodb_defragment_stats_accuracy=0
    innodb_defragment_fill_factor_n_recs=20
    innodb_defragment_fill_factor=0.9
    innodb_defragment_frequency=40
    
    
     
    Last edited: Dec 4, 2018
  10. eva2000

    eva2000 Administrator Staff Member

    37,227
    8,133
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,521
    Local Time:
    5:46 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    you can do side by side diff compare via Diff Checker put one version on left and one on right and share link with us edit: seems you need a registered account to save diff
     
  11. 1121

    1121 New Member

    13
    1
    3
    Nov 29, 2018
    Ratings:
    +2
    Local Time:
    2:46 AM
    1.15.7
    MariaDB 10.1.37
    What a great online tool! Will add it my arsenal. Thanks, George!

    Here is the link:
    Diff Checker
     
  12. eva2000

    eva2000 Administrator Staff Member

    37,227
    8,133
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,521
    Local Time:
    5:46 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Hard to see diff as if you don't have a setting in my.cnf, it uses mysql server defaults and that varies from mysql version and fork i.e. percona, oracle and mariadb might have different defaults.. one comes to mine is Centmin Mod defaults to InnoDB tables when creating databases via
    Code (Text):
    default-storage-engine = InnoDB
    

    Depending on MySQL version used absence of this option in working my.cnf means default to MyISAM tables instead of InnoDB so that may explain why FunnelFlux works as it created MyISAM tables not optimal performance instead of InnoDB which has that 8192 bytes limit which MyISAM tables don't have such limits. So essentially root problem is FunnelFlux's database design/structure not adhering to InnoDB table's limits.

    However, MariaDB 10.0/10.1+ default storage engine is InnoDB Server System Variables
    You can verify this by running this command both servers non-centminmod and centmin mod to get the default storage engine value which Centmin Mod sets to = InnoDB
    Code (Text):
    mysqladmin var | grep 'default_storage_engine' | tr -s ' '
    

    example output
    Code (Text):
    mysqladmin var | grep 'default_storage_engine' | tr -s ' '
    | default_storage_engine | InnoDB |
    

    and also checking your database's individual table engines via command below, replace end of line dbname text with the name of your database
    Code (Text):
    mysql -t -e "SELECT CONCAT(table_schema,'.',table_name) AS 'Table Name', CONCAT(ROUND(table_rows,2),' Rows') AS 'Number of Rows',ENGINE AS 'Storage Engine',CONCAT(ROUND(data_length/(1024*1024),2),'MB') AS 'Data Size',CONCAT(ROUND(index_length/(1024*1024),2),'MB') AS 'Index Size' ,CONCAT(ROUND((data_length+index_length)/(1024*1024),2),'MB') AS'Total', ROW_FORMAT, TABLE_COLLATION FROM information_schema.TABLES WHERE table_schema LIKE 'dbname';"
    

    example inspecting default mysql database named = mysql
    Code (Text):
    mysql -t -e "SELECT CONCAT(table_schema,'.',table_name) AS 'Table Name', CONCAT(ROUND(table_rows,2),' Rows') AS 'Number of Rows',ENGINE AS 'Storage Engine',CONCAT(ROUND(data_length/(1024*1024),2),'MB') AS 'Data Size',CONCAT(ROUND(index_length/(1024*1024),2),'MB') AS 'Index Size' ,CONCAT(ROUND((data_length+index_length)/(1024*1024),2),'MB') AS'Total', ROW_FORMAT, TABLE_COLLATION FROM information_schema.TABLES WHERE table_schema LIKE 'mysql';"
    +---------------------------------+----------------+----------------+-----------+------------+--------+------------+-------------------+
    | Table Name                      | Number of Rows | Storage Engine | Data Size | Index Size | Total  | ROW_FORMAT | TABLE_COLLATION   |
    +---------------------------------+----------------+----------------+-----------+------------+--------+------------+-------------------+
    | mysql.column_stats              | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Dynamic    | utf8_bin          |
    | mysql.columns_priv              | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Fixed      | utf8_bin          |
    | mysql.db                        | 4 Rows         | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB | Fixed      | utf8_bin          |
    | mysql.event                     | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Dynamic    | utf8_general_ci   |
    | mysql.func                      | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Fixed      | utf8_bin          |
    | mysql.general_log               | 2 Rows         | CSV            | 0.00MB    | 0.00MB     | 0.00MB | Dynamic    | utf8_general_ci   |
    | mysql.gtid_slave_pos            | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB | Compact    | latin1_swedish_ci |
    | mysql.help_category             | 39 Rows        | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Dynamic    | utf8_general_ci   |
    | mysql.help_keyword              | 464 Rows       | MyISAM         | 0.09MB    | 0.02MB     | 0.10MB | Fixed      | utf8_general_ci   |
    | mysql.help_relation             | 1028 Rows      | MyISAM         | 0.01MB    | 0.02MB     | 0.03MB | Fixed      | utf8_general_ci   |
    | mysql.help_topic                | 508 Rows       | MyISAM         | 0.39MB    | 0.02MB     | 0.41MB | Dynamic    | utf8_general_ci   |
    | mysql.host                      | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Fixed      | utf8_bin          |
    | mysql.index_stats               | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Dynamic    | utf8_bin          |
    | mysql.innodb_index_stats        | 289 Rows       | InnoDB         | 0.08MB    | 0.00MB     | 0.08MB | Compact    | utf8_bin          |
    | mysql.innodb_table_stats        | 30 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB | Compact    | utf8_bin          |
    | mysql.plugin                    | 4 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Dynamic    | utf8_general_ci   |
    | mysql.proc                      | 2 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.01MB | Dynamic    | utf8_general_ci   |
    | mysql.procs_priv                | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Fixed      | utf8_bin          |
    | mysql.proxies_priv              | 2 Rows         | MyISAM         | 0.00MB    | 0.01MB     | 0.01MB | Fixed      | utf8_bin          |
    | mysql.roles_mapping             | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Fixed      | utf8_bin          |
    | mysql.servers                   | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Fixed      | utf8_general_ci   |
    | mysql.slow_log                  | 2 Rows         | CSV            | 0.00MB    | 0.00MB     | 0.00MB | Dynamic    | utf8_general_ci   |
    | mysql.table_stats               | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Dynamic    | utf8_bin          |
    | mysql.tables_priv               | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Fixed      | utf8_bin          |
    | mysql.time_zone                 | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Fixed      | utf8_general_ci   |
    | mysql.time_zone_leap_second     | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Fixed      | utf8_general_ci   |
    | mysql.time_zone_name            | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Fixed      | utf8_general_ci   |
    | mysql.time_zone_transition      | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Fixed      | utf8_general_ci   |
    | mysql.time_zone_transition_type | 0 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Fixed      | utf8_general_ci   |
    | mysql.user                      | 6 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB | Dynamic    | utf8_bin          |
    +---------------------------------+----------------+----------------+-----------+------------+--------+------------+-------------------+
    
     
    Last edited: Dec 4, 2018
  13. eva2000

    eva2000 Administrator Staff Member

    37,227
    8,133
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,521
    Local Time:
    5:46 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    The other possibility is the innodb_log_file_size setting, working version has 2G while Centmin Mod defaulted to 768MB.

    or sql_mode

    Centmin Mod MariaDB defaults
    Code (Text):
    mysqladmin var | egrep 'default_storage_engine|sql_mode' | tr -s ' '
    | default_storage_engine | InnoDB |
    | sql_mode | NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
    


    while FunnelFlux working my.cnf has
    Code (Text):
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    


    SQL_MODE
     
    Last edited: Dec 4, 2018
  14. 1121

    1121 New Member

    13
    1
    3
    Nov 29, 2018
    Ratings:
    +2
    Local Time:
    2:46 AM
    1.15.7
    MariaDB 10.1.37
    This is what I get on the Centminmod with Funnelflux working:

    Code (Text):
    | default_storage_engine | InnoDB |


    and the tables:

    Code (Text):
    +---------------------+----------------+----------------+-----------+------------+--------+------------+-----------------+
    | Table Name          | Number of Rows | Storage Engine | Data Size | Index Size | Total  | ROW_FORMAT | TABLE_COLLATION |
    +---------------------+----------------+----------------+-----------+------------+--------+------------+-----------------+
    | funnelflux.table    | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB | Compact    | utf8_general_ci |
    
    


    All tables show Storage Engine as InnoDB

    Off-topic: How do I format the output in terminal style? The insert Code seems to format differently.
     
    Last edited: Dec 4, 2018
  15. eva2000

    eva2000 Administrator Staff Member

    37,227
    8,133
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,521
    Local Time:
    5:46 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    For posting code or output from commands to keep the formatting, you might want to use CODE or CODEB tags for code How to use forum BBCODE code tags :)

    Interesting so it is InnoDB though. Can you post the output for the table's structure/create table via command
    Code (Text):
    mysql -e "SHOW CREATE TABLE databasename.tablename\G;"
    

    replacing databasename with your db name and tablename with your table name.
     
  16. 1121

    1121 New Member

    13
    1
    3
    Nov 29, 2018
    Ratings:
    +2
    Local Time:
    2:46 AM
    1.15.7
    MariaDB 10.1.37
    Thanks!
    I can't post the full output for this command as Cloudflare thinks I am attacking this forum.
    But here is a partial output of one table that caused the database import to halt with ERROR 1118 (42000) back in the beginning of my efforts:
    Code (Text):
    mysql -e "SHOW CREATE TABLE databasename.tablename\G;"
    *************************** 1. row ***************************
           Table: tablename
    Create Table: CREATE TABLE `tablename` (
      `name` varchar(150) NOT NULL,
      `bDefault` tinyint(4) DEFAULT '0',
      `bDeleted` tinyint(1) NOT NULL DEFAULT '0',
      PRIMARY KEY (`name`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    
    
     
    Last edited: Dec 4, 2018
  17. eva2000

    eva2000 Administrator Staff Member

    37,227
    8,133
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,521
    Local Time:
    5:46 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    try now.. updated the CF WAF rules :)
     
  18. 1121

    1121 New Member

    13
    1
    3
    Nov 29, 2018
    Ratings:
    +2
    Local Time:
    2:46 AM
    1.15.7
    MariaDB 10.1.37
    Updated. Thank you
     
  19. eva2000

    eva2000 Administrator Staff Member

    37,227
    8,133
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,521
    Local Time:
    5:46 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    looks ok to me
    so you can try creating a 2nd empty mysql database, setting to centmin mod /etc/my.cnf but edit innodb_log_file_size setting=2G and restart mysql server and try importing your backup into that 2nd empty mysql database and see if it works
     
  20. eva2000

    eva2000 Administrator Staff Member

    37,227
    8,133
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,521
    Local Time:
    5:46 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    oh i noticed there's no row/data in that table ?? is it meant to not have any rows when imported ? as other possibility is working = not importing data properly ?
     
..