search

kawadhiya21 / mysql-migrations

A tool to use with mysql package to maintain migrations
MIT License
31 stars 25 forks source link

Specified key was too long #10

Closed weylermaldonado closed 5 years ago

weylermaldonado commented 5 years ago

This is my migrations.js file

const mysql = require('mysql');
const migration = require('mysql-migrations');

const connection = mysql.createPool({
    connectionLimit : 10,
    host: 'host',
    user: 'user',
    password: 'mypass',
    database: 'my_db'
});

migration.init(connection, __dirname + '/migrations');

but when I run node migration.js add migration create_table_users get this error:

ER_TOO_LONG_KEY: Specified key was too long; max key length is 767 bytes

but I don't create any table, and all credentials and database are correct. Any ideas?

kawadhiya21 commented 5 years ago

I think it could be one of these:

  1. https://github.com/sequelize/sequelize/issues/4171
  2. https://github.com/mozilla/chronicle/issues/98
kawadhiya21 commented 5 years ago

Closing the issue.