Re: Error importing databases in mysql: ERROR 1005 (HY000) (errno:-1)

[Rick James]

innodb_buffer_pool_size, currently 128M, increase it to 1G or more.

In the OS, do ulimit -n -- it will probably limit you to 1024. Suggest increasing that.

Run the SHOW GLOBAL STATUS after mysql has been in use for more than a day; this will improve the validity of the conclusions.

innodb_log_file_size may need increasing. But it means doing a clean shutdown, changing the setting, removing the iblog* files, and restarting.

thread_cache_size is probably not an issue.

Have you spotted what settings are different between the machines? Or what activity is different? Or maybe the tables are much bigger in one than the other?