Import database on maria error

Posted In Wave
  • oltean-tiberiu 1 year ago
    Hello, I have this error on import on maria db MySQL version: 10.1.36-MariaDB
    ![](http://prntscr.com/lsncqn)
    
    
    CREATE TABLE IF NOT EXISTS `categories` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `parent_id` int(10) unsigned DEFAULT NULL,
      `order` int(11) NOT NULL DEFAULT '1',
      `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
      `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
      `created_at` timestamp NULL DEFAULT NULL,
    	
    	Error: 
    #1709 - Index column size too large. The maximum column size is 767 bytes.

    Hello, I have this error on import on maria db MySQL version: 10.1.36-MariaDB

    CREATE TABLE IF NOT EXISTS categories ( id int(10) unsigned NOT NULL AUTO_INCREMENT, parent_id int(10) unsigned DEFAULT NULL, order int(11) NOT NULL DEFAULT '1', name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, slug varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, created_at timestamp NULL DEFAULT NULL,

    Error: 
    

    #1709 - Index column size too large. The maximum column size is 767 bytes.

  • balam-web 1 year ago
    read the doc :
    
    [down to **Index Lengths & MySQL / MariaDB**](https://laravel.com/docs/5.7/migrations#creating-indexes)

    read the doc :

    down to Index Lengths & MySQL / MariaDB

  • oltean-tiberiu 1 year ago
    Thanks working

    Thanks working

Please login or signup to leave a response.

Login

or Sign Up

Sign Up

or Login
×
Want to create your own SAAS?

I can teach you to create your own Software as a Service. Click here to learn more!

Visit SAAS Adventure!